[
https://issues.apache.org/jira/browse/ASTERIXDB-3308?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ian Maxon updated ASTERIXDB-3308:
---------------------------------
Labels: triaged (was: )
> CH2 Q7 fails with internal error (with CBO on)
> ----------------------------------------------
>
> Key: ASTERIXDB-3308
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3308
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler
> Affects Versions: 0.9.6
> Reporter: Vijay Sarathy
> Assignee: Vijay Sarathy
> Priority: Major
> Labels: triaged
>
> Query 7 of CH2 fails with an internal error.
> A simplified reproduction is shown below:
> {code:java}
> create dataset customer(id uuid not unknown) open type primary key `id`
> autogenerated;
> create dataset supplier(id uuid not unknown) open type primary key `id`
> autogenerated;
> create dataset nation(id uuid not unknown) open type primary key `id`
> autogenerated;
> analyze dataset customer;
> analyze dataset supplier;
> analyze dataset nation;
> SELECT
> count(*)
> FROM supplier su, customer c, nation n1, nation n2
> WHERE su.su_nationkey = n1.n_nationkey
> AND string_to_codepoint(c.c_state)[0] = n2.n_nationkey
> ;
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
