Custom Query (2765 matches)

for example, this query should work

for c in (test_mr)
let x := imageCrsDomain(c)
return encode(scale(c, {x}), "png")

The pow function currently supports only floating-point exponent, e.g.

SELECT pow(2, 2.0)

It should also support integer type exponents (octet, char, short, ushort, long, ulong), i.e. these shouldn't return an error:

SELECT pow(2, 2o)
SELECT pow(2, 2c)
SELECT pow(2, 2s)
SELECT pow(2, 2us)
SELECT pow(2, 2)
SELECT pow(2, 2ul)

Also, it has trouble parsing exponent expressions, e.g.

SELECT encode(POW(c, ( 2.5 ) ), "png" , "{\"metadata\":{\"resolution\":\"1\"},\"nodata\":[]}") FROM test_mr AS c

with error

rasdaman error 300: Parsing error 300 in line 1, column 22: Unexpected name (

r="rasql --user rasadmin --passwd rasadmin"
$r -q 'create collection test_sdom_error GreySet3'
$r -q 'insert into test_sdom_error values marray i in [0:0,0:0,0:0] values 0c'
$r -q 'update test_sdom_error as c set c assign marray i in [2:2,2035:3034,126:1125] values 200c'
$r -q 'update test_sdom_error as c set c assign marray i in [2:2,2035:3034,1126:1375] values 200c'
$r -q 'update test_sdom_error as c set c assign marray i in [2:2,3035:3051,126:1125] values 200c'
$r -q 'update test_sdom_error as c set c assign marray i in [2:2,3035:3051,1126:1375] values 200c'
$r -q 'update test_sdom_error as c set c assign marray i in [1:1,3199:3204,-9:1302] values 100c'

$r -q 'SELECT
        scale(
          c0[2,2446:3204,-9:1166], [0:257, 0:337]
        )[172:257, 47:191]
  FROM test_sdom_error AS c0'

the SELECT query throws

rasdaman error 344: Execution error 344 in line 3, column 13, near token [: Subset extends outside the array sdom.

but it should work without error.