You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2023/01/10 21:45:00 UTC
[jira] [Commented] (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:comment-tabpanel&focusedCommentId=17656982#comment-17656982 ]
ASF subversion and git services commented on ASTERIXDB-3096:
------------------------------------------------------------
Commit cbdf6fdb4822f3aa530e80bcd1964dc5d766d4a2 in asterixdb's branch refs/heads/master from glennga
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=cbdf6fdb48 ]
[ASTERIXDB-3096][COMP] Array-index recognition bug w/ multiple subplans
- user model changes: no
- storage format changes: no
- interface changes: no
details:
Fixing a bug where an error is thrown for a query containing multiple
subplans. A deep-copy was being made alongside the original, and there
was a use of the original instead of the deep-copy.
Change-Id: I567fa4e47a5cf10bf6ab571c06780f7e41d028ef
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17306
Integration-Tests: Jenkins <je...@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
Reviewed-by: Ali Alsuliman <al...@gmail.com>
> 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)