[
https://issues.apache.org/jira/browse/ASTERIXDB-3096?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17681871#comment-17681871
]
ASF subversion and git services commented on ASTERIXDB-3096:
------------------------------------------------------------
Commit 40ca2a27a98d15c593ca03e7eb51813e038a59a3 in asterixdb's branch
refs/heads/master from glennga
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=40ca2a27a9 ]
[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 <[email protected]>
Tested-by: Jenkins <[email protected]>
Reviewed-by: Ali Alsuliman <[email protected]>
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17353
Reviewed-by: Michael Blow <[email protected]>
Tested-by: Michael Blow <[email protected]>
> 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)
