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')
Following SQL:
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')