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