Changes between Initial Version and Version 2 of Ticket #1293


Ignore:
Timestamp:
Jul 31, 2019, 8:12:43 AM (5 years ago)
Author:
Dimitar Misev
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #1293

    • Property Owner changed from Vlad Merticariu to apercov
    • Property Status new → assigned
    • Property Type defect → enhancement

  • Ticket #1293 – Description

    initial v2  
    1 A query like this (array expression in the ''using'' clause)
     1A query using test_grey3d (assumes domain [0:99,0:99,0:4]):
     2
    23{{{
    3 rasql -q 'select csv(condense + over i_i in [358:364] where ((max_cells((c[1993:1993,1936:1937,i_i[0]])))=(1)) using (long)(c[1993:1993,1936:1937,i_i[0]])) from coll AS c'
     4select condense + over i in [0:4]
     5   using a[0:99,0:99,i]
     6   where avg_cells(a[0:99,0:99,i]) > 30
     7from test_grey3d as a
    48}}}
    5  seems to fail with
     9fails with:
    610{{{
    7 SemanticError..
    8 Caused by: org.odmg.QueryException: Execution error 361 in line 1, column 1, near token select: Multiple query targets are not supported.
     11rasdaman error 300: Parsing error 300 in line 3, column 4: Unexpected name where.
    912}}}
     13It should correctly parse the `where` in the condenser, and then evaluate it: only the array slices for which `avg_cells(a[0:99,0:99,i]) > 30` is true should be added up in the condenser.