Opened 11 months ago

Closed 9 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 Bang Pham Huu)

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 Bang Pham Huu, 11 months ago

Description: modified (diff)

comment:2 by Dimitar Misev, 9 months ago

Resolution: worksforme
Status: assignedclosed

See "Restrictions" here, this is expected/documented behavior.

Note: See TracTickets for help on using tickets.