Skip to content

[SQL] IN/NOT IN(ROW literal) fails with error: operator must have compatible types #4890

@rivudhk

Description

@rivudhk

Following SQL:

CREATE TABLE tbl(
roww ROW(i1 INT, v1 VARCHAR NULL));

CREATE MATERIALIZED VIEW v1 AS SELECT
roww IN (ROW(4,'cat')) AS roww
FROM tbl;

CREATE MATERIALIZED VIEW v2 AS SELECT
roww NOT IN (ROW(4,'cat')) AS roww
FROM tbl;

Given example input: {"roww": {"i1": 4, "v1": "cat"}}

v1 fails with the message:
error: Compilation error
Values passed to IN operator must have compatible types

v2 fails with the message:
error: Compilation error
Values passed to NOT IN operator must have compatible types

Metadata

Metadata

Assignees

Labels

SQL compilerRelated to the SQL compiler

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions