You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Glenn Justo Galvizo (Jira)" <ji...@apache.org> on 2023/01/10 21:49:00 UTC
[jira] [Resolved] (ASTERIXDB-3096) Error raised for queries with TRUE IN [ expr, array-indexable-expr, ... ]
[ https://issues.apache.org/jira/browse/ASTERIXDB-3096?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Glenn Justo Galvizo resolved ASTERIXDB-3096.
--------------------------------------------
Resolution: Fixed
> 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
> Priority: Major
>
> 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)