CREATE TABLE t (id INT, arr ROW(name VARCHAR, score INT) ARRAY);
CREATE MATERIALIZED VIEW v AS
SELECT id, TRANSFORM(arr, x -> x.name) AS names FROM t;
This complains about parameter x.name not being found. That is not even a parameter!
The problem seems to be that x.name is treated as a single compound identifier instead of a field access.
This complains about parameter
x.namenot being found. That is not even a parameter!The problem seems to be that
x.nameis treated as a single compound identifier instead of a field access.