Skip to content

[SQL] BUG in operation: IN/NOT IN(ROW value) #4891

@rivudhk

Description

@rivudhk

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')

Metadata

Metadata

Assignees

Labels

CalciteFix available in the next Calcite releaseSQL compilerRelated to the SQL compiler

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions