-
Notifications
You must be signed in to change notification settings - Fork 109
[SQL] BUG in operation: IN/NOT IN(ROW value) #4891
Copy link
Copy link
Labels
CalciteFix available in the next Calcite releaseFix available in the next Calcite releaseSQL compilerRelated to the SQL compilerRelated to the SQL compiler
Description
Following SQL:
CREATE TABLE tbl(
roww ROW(i1 INT, v1 VARCHAR NULL));
CREATE MATERIALIZED VIEW v1 AS SELECT
roww IN (roww) AS roww
FROM tbl;
CREATE MATERIALIZED VIEW v2 AS SELECT
roww NOT IN (roww) AS roww
FROM tbl;
Given example input: {"roww": {"i1": 4, "v1": "cat"}}
Both v1 and v2 fail with the message:
error: This is a bug in the compiler (please report it to the developers)
class org.apache.calcite.sql.SqlIdentifier cannot be cast to class org.apache.calcite.sql.SqlCall (org.apache.calcite.sql.SqlIdentifier and org.apache.calcite.sql.SqlCall are in unnamed module of loader 'app')
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
CalciteFix available in the next Calcite releaseFix available in the next Calcite releaseSQL compilerRelated to the SQL compilerRelated to the SQL compiler