[jira] [Created] (ASTERIXDB-3308) CH2 Q7 fails with internal error (with CBO on)

[Vijay Sarathy (Jira)]

Vijay Sarathy created ASTERIXDB-3308:
----------------------------------------

             Summary: 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


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)