sql: allow unaliased subqueries within UDFs #96375
Description
There is a compatibility difference with postgres for queries with ambiguous columns.
Examples that fail in postgres with "subquery in FROM must have an alias" but not crdb:
CREATE TABLE t1 (a INT);
CREATE TABLE t2 (a INT);
SELECT * FROM (SELECT a FROM t1) JOIN (SELECT a FROM t2) ON true;
SELECT * FROM (SELECT * FROM (SELECT a FROM t1));
SELECT a FROM (SELECT * FROM (SELECT a FROM t1));
The following example fails correctly in crdb with "column reference "a" is ambiguous":
SELECT a FROM (SELECT * FROM (SELECT a FROM t1) JOIN (SELECT a FROM t2) ON true);
Jira issue: CRDB-24094
Metadata
Metadata
Assignees
Labels
Type
Projects
Status