Changes between Initial Version and Version 1 of Ticket #2732


Ignore:
Timestamp:
May 24, 2023, 11:19:05 AM (12 months ago)
Author:
Bang Pham Huu
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #2732 – Description

    initial v1  
    1010rasdaman error 427: Execution error 427 in line 1, column 19, near token CASE: The condition and result MDDs don't have the same tiling.
    1111}}}
     12
     13NOTE: without pushing down `scale()`, this query also doesn't work
     14
     15{{{
     16SELECT 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
     17}}}
     18
     19with error:
     20
     21{{{
     22Execution error 427 in line 1, column 25, near token CASE: The condition and result MDDs don't have the same tiling
     23}}}