[jira] [Created] (ASTERIXDB-3096) Error raised for queries with TRUE IN [ expr, array-indexable-expr, ... ]

["Glenn Justo Galvizo (Jira)" <ji...@apache.org>]

Glenn Justo Galvizo created ASTERIXDB-3096:
----------------------------------------------

             Summary: Error raised for queries with TRUE IN [ expr, array-indexable-expr, ... ]
                 Key: ASTERIXDB-3096
                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-3096
             Project: Apache AsterixDB
          Issue Type: Bug
          Components: COMP - Compiler
            Reporter: Glenn Justo Galvizo
            Assignee: Glenn Justo Galvizo


The following query raises an error:

 
{code:java}
DROP DATAVERSE TestYelp IF EXISTS;
CREATE DATAVERSE TestYelp;
USE TestYelp;CREATE TYPE CheckinType AS {
    checkin_id: uuid
};

CREATE DATASET YelpCheckin(CheckinType) PRIMARY KEY checkin_id AUTOGENERATED;
CREATE INDEX IdxYelpCheckinDates ON YelpCheckin (UNNEST dates : string) EXCLUDE UNKNOWN KEY;SELECT *
FROM YelpCheckin Y
WHERE TRUE IN ["10" /*+ indexnl */ IN Y.dates,  Y.b = 10 ];{code}
When the "Y.b = 10" item in the list is removed, the query does not throw an error (but the index is not used, a separate issue). Placing "Y.b = 10" before or after the array indexable expression does not get rid of the issue.

 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)