Opened 18 months ago
Closed 15 months ago
#2732 closed defect (worksforme)
FIX - rasql wrong error about tiling in switch case
Reported by: | Bang Pham Huu | Owned by: | Dimitar Misev |
---|---|---|---|
Priority: | major | Milestone: | 10.2 |
Component: | rasserver | Version: | 10.2 |
Keywords: | Cc: | ||
Complexity: | Medium |
Description (last modified by )
This query from a test wcst_import coverage should work
SELECT encode( ( CASE WHEN ( SCALE(c_0[0,0:150,0:118], [0:60,0:47]) ) > 20 THEN ( SCALE(c_0[0,0:150,0:118], [0:60,0:47]) ) * { 107, 17, 68 } ELSE ( SCALE(c_0[0,0:150,0:118], [0:60,0:47]) ) * { 150, 103, 14 } END ) , "png" , "{\"geoReference\":{\"crs\":\"EPSG:4326\",\"bbox\":{\"xmin\":5.565789213302955,\"ymin\":47.13501923451767455,\"xmax\":15.652387627060358595,\"ymax\":55.06020370246992}},\"nodata\":[0.0]}") FROM test_wcps_irregular_time_germany_4 AS c_0
but it has error:
rasdaman error 427: Execution error 427 in line 1, column 19, near token CASE: The condition and result MDDs don't have the same tiling.
NOTE: without pushing down scale()
, this query also doesn't work
SELECT encode(SCALE( ( CASE WHEN ( c_0[0,0:150,0:118] ) > 20 THEN ( c_0[0,0:150,0:118] ) * { 107, 17, 68 } ELSE ( c_0[0,0:150,0:118] ) * { 150, 103, 14 } END ) , [0:60,0:47]), "png" , "{\"geoReference\":{\"crs\":\"EPSG:4326\",\"bbox\":{\"xmin\":5.565789213302955,\"ymin\":47.13501923451767455,\"xmax\":15.652387627060358595,\"ymax\":55.06020370246992}},\"nodata\":[0.0]}") FROM test_wcps_irregular_time_germany_4 AS c_0
with error:
Execution error 427 in line 1, column 25, near token CASE: The condition and result MDDs don't have the same tiling
Change History (2)
comment:1 by , 18 months ago
Description: | modified (diff) |
---|
comment:2 by , 15 months ago
Resolution: | → worksforme |
---|---|
Status: | assigned → closed |
Note:
See TracTickets
for help on using tickets.
See "Restrictions" here, this is expected/documented behavior.