sql: tuple expansion of table in udfs fails with "column...does not exist" #97602
Description
In postgres, we can expand tables as tuples:
create table t (a int, b int);
insert into t values (1,2),(3,4);
select (t).* from t;
a | b
---+---
1 | 2
3 | 4
create function f() returns setof record language sql begin atomic; select (t).* from t; end;
select f();
f
-------
(1,2)
(3,4)
In CRDB, we can expand tables this way outside of UDFs, but not inside UDFs:
select (t).* from t;
a | b
----+----
1 | 2
3 | 4
create function f() returns setof record language sql as $$ select
-> (t).* from t; $$;
ERROR: column "t" does not exist
Jira issue: CRDB-24776