: Fatal: tools/enum_parser/enum_serialization_runtime/enum_runtime.cpp:70: Key 'default_values' not found in enum NYql::EYtSettingType. Valid options are: 'initial', 'infer_scheme', 'force_infer_schema', 'do_not_fail_on_invalid_schema', 'direct_read', 'view', 'mode', 'scheme', 'weak_concat', 'anonymous', 'with_qb', 'inline', 'sample', 'joinLabel', 'ignore_non_existing', 'warn_non_existing', 'xlock', 'unordered', 'nonUnique', 'userschema', 'usercolumns', 'statcolumns', 'syscolumns', 'ignoretypev3', 'memUsage', 'itemsCount', 'rowFactor', 'ordered', 'keyFilter', 'keyFilter2', 'take', 'skip', 'limit', 'sortLimitBy', 'sortBy', 'reduceBy', 'reduceFilterBy', 'forceTransform', 'weakFields', 'sharded', 'combineChunks', 'jobCount', 'joinReduce', 'firstAsPrimary', 'flow', 'keepSorted', 'keySwitch', 'uniqueBy', 'opHash', 'mapOutputType', 'reduceInputType', 'noDq', 'split', 'compression_codec', 'erasure_codec', 'expiration', 'replication_factor', 'user_attrs', 'media', 'primary_medium', 'keep_meta', 'monotonic_keys', 'mutationid'. analyze onerow; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 275 analyze onerow; ^ -- -- CORRELATION NAMES -- Make sure that table/column aliases are supported -- before diving into more complex join syntax. -- SELECT * FROM J1_TBL AS tx;

SELECT * FROM J1_TBL tx;

SELECT * FROM J1_TBL AS t1 (a, b, c);

SELECT * FROM J1_TBL t1 (a, b, c);

SELECT * FROM J1_TBL t1 (a, b, c), J2_TBL t2 (d, e);

SELECT t1.a, t2.e FROM J1_TBL t1 (a, b, c), J2_TBL t2 (d, e) WHERE t1.a = t2.d;

-- -- CROSS JOIN -- Qualifications are not allowed on cross joins, -- which degenerate into a standard unqualified inner join. -- SELECT * FROM J1_TBL CROSS JOIN J2_TBL; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem -- ^ -stdin-:

:1:1: Error: Duplicated member: i -- ^ -- ambiguous column SELECT i, k, t FROM J1_TBL CROSS JOIN J2_TBL; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem -- ambiguous column ^ -stdin-:

:2:8: Error: Column reference is ambiguous: i SELECT i, k, t ^ -- resolve previous ambiguity by specifying the table name SELECT t1.i, k, t FROM J1_TBL t1 CROSS JOIN J2_TBL t2; SELECT ii, tt, kk FROM (J1_TBL CROSS JOIN J2_TBL) AS tx (ii, jj, tt, ii2, kk); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: JoinExpr: unsupported alias SELECT ii, tt, kk ^ SELECT tx.ii, tx.jj, tx.kk FROM (J1_TBL t1 (a, b, c) CROSS JOIN J2_TBL t2 (d, e)) AS tx (ii, jj, tt, ii2, kk); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: JoinExpr: unsupported alias SELECT tx.ii, tx.jj, tx.kk ^ SELECT * FROM J1_TBL CROSS JOIN J2_TBL a CROSS JOIN J2_TBL b; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem SELECT * ^ -stdin-:

:1:1: Error: Duplicated member: i SELECT * ^ -- -- -- Inner joins (equi-joins) -- -- -- -- Inner joins (equi-joins) with USING clause -- The USING syntax changes the shape of the resulting table -- by including a column in the USING clause only once in the result. -- -- Inner equi-join on specified column SELECT * FROM J1_TBL INNER JOIN J2_TBL USING (i);

-- Same as above, slightly different syntax SELECT * FROM J1_TBL JOIN J2_TBL USING (i);

SELECT * FROM J1_TBL t1 (a, b, c) JOIN J2_TBL t2 (a, d) USING (a) ORDER BY a, d;

SELECT * FROM J1_TBL t1 (a, b, c) JOIN J2_TBL t2 (a, b) USING (b) ORDER BY b, t1.a; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem SELECT * ^ -stdin-:

:1:1: Error: Duplicated member: a SELECT * ^ -- test join using aliases SELECT * FROM J1_TBL JOIN J2_TBL USING (i) WHERE J1_TBL.t = 'one'; -- ok SELECT * FROM J1_TBL JOIN J2_TBL USING (i) AS x WHERE J1_TBL.t = 'one'; -- ok -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: join USING: unsupported AS SELECT * FROM J1_TBL JOIN J2_TBL USING (i) AS x WHERE J1_TBL.t = 'one'; -- ok ^ SELECT * FROM (J1_TBL JOIN J2_TBL USING (i)) AS x WHERE J1_TBL.t = 'one'; -- error -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: JoinExpr: unsupported alias SELECT * FROM (J1_TBL JOIN J2_TBL USING (i)) AS x WHERE J1_TBL.t = 'one'; -- error ^ SELECT * FROM J1_TBL JOIN J2_TBL USING (i) AS x WHERE x.i = 1; -- ok -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: join USING: unsupported AS SELECT * FROM J1_TBL JOIN J2_TBL USING (i) AS x WHERE x.i = 1; -- ok ^ SELECT * FROM J1_TBL JOIN J2_TBL USING (i) AS x WHERE x.t = 'one'; -- error -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: join USING: unsupported AS SELECT * FROM J1_TBL JOIN J2_TBL USING (i) AS x WHERE x.t = 'one'; -- error ^ SELECT * FROM (J1_TBL JOIN J2_TBL USING (i) AS x) AS xx WHERE x.i = 1; -- error (XXX could use better hint) -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: JoinExpr: unsupported alias SELECT * FROM (J1_TBL JOIN J2_TBL USING (i) AS x) AS xx WHERE x.i = 1; -- error (XXX could use better hint) ^ SELECT * FROM J1_TBL a1 JOIN J2_TBL a2 USING (i) AS a1; -- error -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: join USING: unsupported AS SELECT * FROM J1_TBL a1 JOIN J2_TBL a2 USING (i) AS a1; -- error ^ SELECT x.* FROM J1_TBL JOIN J2_TBL USING (i) AS x WHERE J1_TBL.t = 'one'; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: join USING: unsupported AS SELECT x.* FROM J1_TBL JOIN J2_TBL USING (i) AS x WHERE J1_TBL.t = 'one'; ^ SELECT ROW(x.*) FROM J1_TBL JOIN J2_TBL USING (i) AS x WHERE J1_TBL.t = 'one'; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: join USING: unsupported AS SELECT ROW(x.*) FROM J1_TBL JOIN J2_TBL USING (i) AS x WHERE J1_TBL.t = 'one'; ^ SELECT row_to_json(x.*) FROM J1_TBL JOIN J2_TBL USING (i) AS x WHERE J1_TBL.t = 'one'; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: join USING: unsupported AS SELECT row_to_json(x.*) FROM J1_TBL JOIN J2_TBL USING (i) AS x WHERE J1_TBL.t = 'one'; ^ -- -- NATURAL JOIN -- Inner equi-join on all columns with the same name -- SELECT * FROM J1_TBL NATURAL JOIN J2_TBL; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: JoinExpr: unsupported isNatural -- ^ SELECT * FROM J1_TBL t1 (a, b, c) NATURAL JOIN J2_TBL t2 (a, d); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: JoinExpr: unsupported isNatural SELECT * ^ SELECT * FROM J1_TBL t1 (a, b, c) NATURAL JOIN J2_TBL t2 (d, a); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: JoinExpr: unsupported isNatural SELECT * ^ -- mismatch number of columns -- currently, Postgres will fill in with underlying names SELECT * FROM J1_TBL t1 (a, b) NATURAL JOIN J2_TBL t2 (a); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: JoinExpr: unsupported isNatural -- mismatch number of columns ^ -- -- Inner joins (equi-joins) -- SELECT * FROM J1_TBL JOIN J2_TBL ON (J1_TBL.i = J2_TBL.i); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem -- ^ -stdin-:

:1:1: Error: Duplicated member: i -- ^ SELECT * FROM J1_TBL JOIN J2_TBL ON (J1_TBL.i = J2_TBL.k); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem SELECT * ^ -stdin-:

:1:1: Error: Duplicated member: i SELECT * ^ -- -- Non-equi-joins -- SELECT * FROM J1_TBL JOIN J2_TBL ON (J1_TBL.i <= J2_TBL.k); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem -- ^ -stdin-:

:1:1: Error: Duplicated member: i -- ^ -- -- Outer joins -- Note that OUTER is a noise word -- SELECT * FROM J1_TBL LEFT OUTER JOIN J2_TBL USING (i) ORDER BY i, k, t;

SELECT * FROM J1_TBL LEFT JOIN J2_TBL USING (i) ORDER BY i, k, t;

SELECT * FROM J1_TBL RIGHT OUTER JOIN J2_TBL USING (i);

SELECT * FROM J1_TBL RIGHT JOIN J2_TBL USING (i);

SELECT * FROM J1_TBL FULL OUTER JOIN J2_TBL USING (i) ORDER BY i, k, t;

SELECT * FROM J1_TBL FULL JOIN J2_TBL USING (i) ORDER BY i, k, t;

SELECT * FROM J1_TBL LEFT JOIN J2_TBL USING (i) WHERE (k = 1);

SELECT * FROM J1_TBL LEFT JOIN J2_TBL USING (i) WHERE (i = 1); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem SELECT * ^ -stdin-:

:2:49: Error: Column reference is ambiguous: i FROM J1_TBL LEFT JOIN J2_TBL USING (i) WHERE (i = 1); ^ -- -- semijoin selectivity for <> -- explain (costs off) select * from int4_tbl i4, tenk1 a where exists(select * from tenk1 b where a.twothousand = b.twothousand and a.fivethous <> b.fivethous) and i4.f1 = a.tenthous; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- ^ -- -- More complicated constructs -- -- -- Multiway full join -- CREATE TABLE t1 (name TEXT, n INTEGER);

CREATE TABLE t2 (name TEXT, n INTEGER);

CREATE TABLE t3 (name TEXT, n INTEGER);

INSERT INTO t1 VALUES ( 'bb', 11 );

INSERT INTO t2 VALUES ( 'bb', 12 );

INSERT INTO t2 VALUES ( 'cc', 22 );

INSERT INTO t2 VALUES ( 'ee', 42 );

INSERT INTO t3 VALUES ( 'bb', 13 );

INSERT INTO t3 VALUES ( 'cc', 23 );

INSERT INTO t3 VALUES ( 'dd', 33 );

SELECT * FROM t1 FULL JOIN t2 USING (name) FULL JOIN t3 USING (name); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem SELECT * FROM t1 FULL JOIN t2 USING (name) FULL JOIN t3 USING (name); ^ -stdin-:

:1:1: Error: Duplicated member: n SELECT * FROM t1 FULL JOIN t2 USING (name) FULL JOIN t3 USING (name); ^ -- -- Test interactions of join syntax and subqueries -- -- Basic cases (we expect planner to pull up the subquery here) SELECT * FROM (SELECT * FROM t2) as s2 INNER JOIN (SELECT * FROM t3) s3 USING (name); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem -- ^ -stdin-:

:1:1: Error: Duplicated member: n -- ^ SELECT * FROM (SELECT * FROM t2) as s2 LEFT JOIN (SELECT * FROM t3) s3 USING (name); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem SELECT * FROM ^ -stdin-:

:1:1: Error: Duplicated member: n SELECT * FROM ^ SELECT * FROM (SELECT * FROM t2) as s2 FULL JOIN (SELECT * FROM t3) s3 USING (name); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem SELECT * FROM ^ -stdin-:

:1:1: Error: Duplicated member: n SELECT * FROM ^ -- Cases with non-nullable expressions in subquery results; -- make sure these go to null as expected SELECT * FROM (SELECT name, n as s2_n, 2 as s2_2 FROM t2) as s2 NATURAL INNER JOIN (SELECT name, n as s3_n, 3 as s3_2 FROM t3) s3; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: JoinExpr: unsupported isNatural -- Cases with non-nullable expressions in subquery results; ^ SELECT * FROM (SELECT name, n as s2_n, 2 as s2_2 FROM t2) as s2 NATURAL LEFT JOIN (SELECT name, n as s3_n, 3 as s3_2 FROM t3) s3; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: JoinExpr: unsupported isNatural SELECT * FROM ^ SELECT * FROM (SELECT name, n as s2_n, 2 as s2_2 FROM t2) as s2 NATURAL FULL JOIN (SELECT name, n as s3_n, 3 as s3_2 FROM t3) s3; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: JoinExpr: unsupported isNatural SELECT * FROM ^ SELECT * FROM (SELECT name, n as s1_n, 1 as s1_1 FROM t1) as s1 NATURAL INNER JOIN (SELECT name, n as s2_n, 2 as s2_2 FROM t2) as s2 NATURAL INNER JOIN (SELECT name, n as s3_n, 3 as s3_2 FROM t3) s3; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: JoinExpr: unsupported isNatural SELECT * FROM ^ SELECT * FROM (SELECT name, n as s1_n, 1 as s1_1 FROM t1) as s1 NATURAL FULL JOIN (SELECT name, n as s2_n, 2 as s2_2 FROM t2) as s2 NATURAL FULL JOIN (SELECT name, n as s3_n, 3 as s3_2 FROM t3) s3; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: JoinExpr: unsupported isNatural SELECT * FROM ^ SELECT * FROM (SELECT name, n as s1_n FROM t1) as s1 NATURAL FULL JOIN (SELECT * FROM (SELECT name, n as s2_n FROM t2) as s2 NATURAL FULL JOIN (SELECT name, n as s3_n FROM t3) as s3 ) ss2; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: JoinExpr: unsupported isNatural SELECT * FROM ^ SELECT * FROM (SELECT name, n as s1_n FROM t1) as s1 NATURAL FULL JOIN (SELECT * FROM (SELECT name, n as s2_n, 2 as s2_2 FROM t2) as s2 NATURAL FULL JOIN (SELECT name, n as s3_n FROM t3) as s3 ) ss2; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: JoinExpr: unsupported isNatural SELECT * FROM ^ -- Constants as join keys can also be problematic SELECT * FROM (SELECT name, n as s1_n FROM t1) as s1 FULL JOIN (SELECT name, 2 as s2_n FROM t2) as s2 ON (s1_n = s2_n); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem -- Constants as join keys can also be problematic ^ -stdin-:

:1:1: Error: Duplicated member: name -- Constants as join keys can also be problematic ^ -- Test for propagation of nullability constraints into sub-joins create temp table x (x1 int, x2 int);

insert into x values (1,11);

insert into x values (2,22);

insert into x values (3,null);

insert into x values (4,44);

insert into x values (5,null);

create temp table y (y1 int, y2 int);

insert into y values (1,111);

insert into y values (2,222);

insert into y values (3,333);

insert into y values (4,null);

select * from x;

select * from y;

select * from x left join y on (x1 = y1 and x2 is not null);

select * from x left join y on (x1 = y1 and y2 is not null);

select * from (x left join y on (x1 = y1)) left join x xx(xx1,xx2) on (x1 = xx1);

select * from (x left join y on (x1 = y1)) left join x xx(xx1,xx2) on (x1 = xx1 and x2 is not null);

select * from (x left join y on (x1 = y1)) left join x xx(xx1,xx2) on (x1 = xx1 and y2 is not null);

select * from (x left join y on (x1 = y1)) left join x xx(xx1,xx2) on (x1 = xx1 and xx2 is not null);

-- these should NOT give the same answers as above select * from (x left join y on (x1 = y1)) left join x xx(xx1,xx2) on (x1 = xx1) where (x2 is not null);

select * from (x left join y on (x1 = y1)) left join x xx(xx1,xx2) on (x1 = xx1) where (y2 is not null);

select * from (x left join y on (x1 = y1)) left join x xx(xx1,xx2) on (x1 = xx1) where (xx2 is not null);

-- -- regression test: check for bug with propagation of implied equality -- to outside an IN -- select count(*) from tenk1 a where unique1 in (select unique1 from tenk1 b join tenk1 c using (unique1) where b.unique2 = 42);

-- -- regression test: check for failure to generate a plan with multiple -- degenerate IN clauses -- select count(*) from tenk1 x where x.unique1 in (select a.f1 from int4_tbl a,float8_tbl b where a.f1=b.f1) and x.unique1 = 0 and x.unique1 in (select aa.f1 from int4_tbl aa,float8_tbl bb where aa.f1=bb.f1);

-- try that with GEQO too begin;

set geqo = on; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: VariableSetStmt, not supported name: geqo set geqo = on; ^ set geqo_threshold = 2; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: VariableSetStmt, not supported name: geqo_threshold set geqo_threshold = 2; ^ select count(*) from tenk1 x where x.unique1 in (select a.f1 from int4_tbl a,float8_tbl b where a.f1=b.f1) and x.unique1 = 0 and x.unique1 in (select aa.f1 from int4_tbl aa,float8_tbl bb where aa.f1=bb.f1);

rollback;

-- -- regression test: be sure we cope with proven-dummy append rels -- explain (costs off) select aa, bb, unique1, unique1 from tenk1 right join b on aa = unique1 where bb < bb and bb is null; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- ^ select aa, bb, unique1, unique1 from tenk1 right join b on aa = unique1 where bb < bb and bb is null; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.b -- -- regression test: check handling of empty-FROM subquery underneath outer join -- explain (costs off) select * from int8_tbl i1 left join (int8_tbl i2 join (select 123 as x) ss on i2.q1 = x) on i1.q2 = i2.q2 order by 1, 2; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- ^ select * from int8_tbl i1 left join (int8_tbl i2 join (select 123 as x) ss on i2.q1 = x) on i1.q2 = i2.q2 order by 1, 2; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem select * from int8_tbl i1 left join (int8_tbl i2 join ^ -stdin-:

:1:1: Error: Duplicated member: q1 select * from int8_tbl i1 left join (int8_tbl i2 join ^ -- -- regression test: check a case where join_clause_is_movable_into() gives -- an imprecise result, causing an assertion failure -- select count(*) from (select t3.tenthous as x1, coalesce(t1.stringu1, t2.stringu1) as x2 from tenk1 t1 left join tenk1 t2 on t1.unique1 = t2.unique1 join tenk1 t3 on t1.unique2 = t3.unique2) ss, tenk1 t4, tenk1 t5 where t4.thousand = t5.unique1 and ss.x1 = t4.tenthous and ss.x2 = t5.stringu1; -- -- regression test: check a case where we formerly missed including an EC -- enforcement clause because it was expected to be handled at scan level -- explain (costs off) select a.f1, b.f1, t.thousand, t.tenthous from tenk1 t, (select sum(f1)+1 as f1 from int4_tbl i4a) a, (select sum(f1) as f1 from int4_tbl i4b) b where b.f1 = t.thousand and a.f1 = b.f1 and (a.f1+b.f1+999) = t.tenthous; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- ^ select a.f1, b.f1, t.thousand, t.tenthous from tenk1 t, (select sum(f1)+1 as f1 from int4_tbl i4a) a, (select sum(f1) as f1 from int4_tbl i4b) b where b.f1 = t.thousand and a.f1 = b.f1 and (a.f1+b.f1+999) = t.tenthous; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem select a.f1, b.f1, t.thousand, t.tenthous from ^ -stdin-:

:1:1: Error: Duplicated member: f1 select a.f1, b.f1, t.thousand, t.tenthous from ^ -- -- check a case where we formerly got confused by conflicting sort orders -- in redundant merge join path keys -- explain (costs off) select * from j1_tbl full join (select * from j2_tbl order by j2_tbl.i desc, j2_tbl.k asc) j2_tbl on j1_tbl.i = j2_tbl.i and j1_tbl.i = j2_tbl.k; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- ^ select * from j1_tbl full join (select * from j2_tbl order by j2_tbl.i desc, j2_tbl.k asc) j2_tbl on j1_tbl.i = j2_tbl.i and j1_tbl.i = j2_tbl.k; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.j1_tbl -- -- a different check for handling of redundant sort keys in merge joins -- explain (costs off) select count(*) from (select * from tenk1 x order by x.thousand, x.twothousand, x.fivethous) x left join (select * from tenk1 y order by y.unique2) y on x.thousand = y.unique2 and x.twothousand = y.hundred and x.fivethous = y.unique2; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- ^ select count(*) from (select * from tenk1 x order by x.thousand, x.twothousand, x.fivethous) x left join (select * from tenk1 y order by y.unique2) y on x.thousand = y.unique2 and x.twothousand = y.hundred and x.fivethous = y.unique2;

-- -- Clean up -- DROP TABLE t1;

DROP TABLE t2;

DROP TABLE t3;

DROP TABLE J1_TBL;

DROP TABLE J2_TBL;

-- Both DELETE and UPDATE allow the specification of additional tables -- to "join" against to determine which rows should be modified. CREATE TEMP TABLE t1 (a int, b int);

CREATE TEMP TABLE t2 (a int, b int);

CREATE TEMP TABLE t3 (x int, y int);

INSERT INTO t1 VALUES (5, 10);

INSERT INTO t1 VALUES (15, 20);

INSERT INTO t1 VALUES (100, 100);

INSERT INTO t1 VALUES (200, 1000);

INSERT INTO t2 VALUES (200, 2000);

INSERT INTO t3 VALUES (5, 20);

INSERT INTO t3 VALUES (6, 7);

INSERT INTO t3 VALUES (7, 8);

INSERT INTO t3 VALUES (500, 100);

DELETE FROM t3 USING t1 table1 WHERE t3.x = table1.a; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: using is not supported DELETE FROM t3 USING t1 table1 WHERE t3.x = table1.a; ^ SELECT * FROM t3; DELETE FROM t3 USING t1 JOIN t2 USING (a) WHERE t3.x > t1.a; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: using is not supported DELETE FROM t3 USING t1 JOIN t2 USING (a) WHERE t3.x > t1.a; ^ SELECT * FROM t3; DELETE FROM t3 USING t3 t3_other WHERE t3.x = t3_other.x AND t3.y = t3_other.y; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: using is not supported DELETE FROM t3 USING t3 t3_other WHERE t3.x = t3_other.x AND t3.y = t3_other.y; ^ SELECT * FROM t3; -- Test join against inheritance tree create temp table t2a () inherits (t2); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: table inheritance not supported -- Test join against inheritance tree ^ insert into t2a values (200, 2001); -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.t2a select * from t1 left join t2 on (t1.a = t2.a); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem select * from t1 left join t2 on (t1.a = t2.a); ^ -stdin-:

:1:1: Error: Duplicated member: a select * from t1 left join t2 on (t1.a = t2.a); ^ -- Test matching of column name with wrong alias select t1.x from t1 join t3 on (t1.a = t3.x); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem -- Test matching of column name with wrong alias ^ -stdin-:

:2:8: Error: No such column: x select t1.x from t1 join t3 on (t1.a = t3.x); ^ -- Test matching of locking clause with wrong alias select t1.*, t2.*, unnamed_join.* from t1 join t2 on (t1.a = t2.a), t3 as unnamed_join for update of unnamed_join; -stdin-:

: Warning: Parse Sql -stdin-:

:1:1: Warning: SelectStmt: lockingClause is ignored -- Test matching of locking clause with wrong alias ^ -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem -- Test matching of locking clause with wrong alias ^ -stdin-:

:1:1: Error: Duplicated member: a -- Test matching of locking clause with wrong alias ^ select foo.*, unnamed_join.* from t1 join t2 using (a) as foo, t3 as unnamed_join for update of unnamed_join; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: join USING: unsupported AS select foo.*, unnamed_join.* from ^ select foo.*, unnamed_join.* from t1 join t2 using (a) as foo, t3 as unnamed_join for update of foo; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: join USING: unsupported AS select foo.*, unnamed_join.* from ^ select bar.*, unnamed_join.* from (t1 join t2 using (a) as foo) as bar, t3 as unnamed_join for update of foo; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: JoinExpr: unsupported alias select bar.*, unnamed_join.* from ^ select bar.*, unnamed_join.* from (t1 join t2 using (a) as foo) as bar, t3 as unnamed_join for update of bar; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: JoinExpr: unsupported alias select bar.*, unnamed_join.* from ^ -- -- regression test for 8.1 merge right join bug -- CREATE TEMP TABLE tt1 ( tt1_id int4, joincol int4 );

INSERT INTO tt1 VALUES (1, 11);

INSERT INTO tt1 VALUES (2, NULL);

CREATE TEMP TABLE tt2 ( tt2_id int4, joincol int4 );

INSERT INTO tt2 VALUES (21, 11);

INSERT INTO tt2 VALUES (22, 11);

set enable_hashjoin to off; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: VariableSetStmt, not supported name: enable_hashjoin set enable_hashjoin to off; ^ set enable_nestloop to off; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: VariableSetStmt, not supported name: enable_nestloop set enable_nestloop to off; ^ -- these should give the same results select tt1.*, tt2.* from tt1 left join tt2 on tt1.joincol = tt2.joincol; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem -- these should give the same results ^ -stdin-:

:1:1: Error: Duplicated member: joincol -- these should give the same results ^ select tt1.*, tt2.* from tt2 right join tt1 on tt1.joincol = tt2.joincol; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem select tt1.*, tt2.* from tt2 right join tt1 on tt1.joincol = tt2.joincol; ^ -stdin-:

:1:1: Error: Duplicated member: joincol select tt1.*, tt2.* from tt2 right join tt1 on tt1.joincol = tt2.joincol; ^ reset enable_hashjoin; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: VariableSetStmt, not supported kind: 4 reset enable_hashjoin; ^ reset enable_nestloop; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: VariableSetStmt, not supported kind: 4 reset enable_nestloop; ^ -- -- regression test for bug #13908 (hash join with skew tuples & nbatch increase) -- set work_mem to '64kB'; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: VariableSetStmt, not supported name: work_mem -- ^ set enable_mergejoin to off; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: VariableSetStmt, not supported name: enable_mergejoin set enable_mergejoin to off; ^ set enable_memoize to off; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: VariableSetStmt, not supported name: enable_memoize set enable_memoize to off; ^ explain (costs off) select count(*) from tenk1 a, tenk1 b where a.hundred = b.thousand and (b.fivethous % 10) < 10; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) ^ select count(*) from tenk1 a, tenk1 b where a.hundred = b.thousand and (b.fivethous % 10) < 10; reset work_mem; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: VariableSetStmt, not supported kind: 4 reset work_mem; ^ reset enable_mergejoin; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: VariableSetStmt, not supported kind: 4 reset enable_mergejoin; ^ reset enable_memoize; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: VariableSetStmt, not supported kind: 4 reset enable_memoize; ^ -- -- regression test for 8.2 bug with improper re-ordering of left joins -- create temp table tt3(f1 int, f2 text);

insert into tt3 select x, repeat('xyzzy', 100) from generate_series(1,10000) x;

create index tt3i on tt3(f1);

analyze tt3; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 275 analyze tt3; ^ create temp table tt4(f1 int);

insert into tt4 values (0),(1),(9999);

analyze tt4; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 275 analyze tt4; ^ SELECT a.f1 FROM tt4 a LEFT JOIN ( SELECT b.f1 FROM tt3 b LEFT JOIN tt3 c ON (b.f1 = c.f1) WHERE c.f1 IS NULL ) AS d ON (a.f1 = d.f1) WHERE d.f1 IS NULL;

-- -- regression test for proper handling of outer joins within antijoins -- create temp table tt4x(c1 int, c2 int, c3 int);

explain (costs off) select * from tt4x t1 where not exists ( select 1 from tt4x t2 left join tt4x t3 on t2.c3 = t3.c1 left join ( select t5.c1 as c1 from tt4x t4 left join tt4x t5 on t4.c2 = t5.c1 ) a1 on t3.c2 = a1.c1 where t1.c1 = t2.c2 ); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) ^ -- -- regression test for problems of the sort depicted in bug #3494 -- create temp table tt5(f1 int, f2 int);

create temp table tt6(f1 int, f2 int);

insert into tt5 values(1, 10);

insert into tt5 values(1, 11);

insert into tt6 values(1, 9);

insert into tt6 values(1, 2);

insert into tt6 values(2, 9);

select * from tt5,tt6 where tt5.f1 = tt6.f1 and tt5.f1 = tt5.f2 - tt6.f2; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem select * from tt5,tt6 where tt5.f1 = tt6.f1 and tt5.f1 = tt5.f2 - tt6.f2; ^ -stdin-:

:1:1: Error: Duplicated member: f1 select * from tt5,tt6 where tt5.f1 = tt6.f1 and tt5.f1 = tt5.f2 - tt6.f2; ^ -- -- regression test for problems of the sort depicted in bug #3588 -- create temp table xx (pkxx int);

create temp table yy (pkyy int, pkxx int);

insert into xx values (1);

insert into xx values (2);

insert into xx values (3);

insert into yy values (101, 1);

insert into yy values (201, 2);

insert into yy values (301, NULL);

select yy.pkyy as yy_pkyy, yy.pkxx as yy_pkxx, yya.pkyy as yya_pkyy, xxa.pkxx as xxa_pkxx, xxb.pkxx as xxb_pkxx from yy left join (SELECT * FROM yy where pkyy = 101) as yya ON yy.pkyy = yya.pkyy left join xx xxa on yya.pkxx = xxa.pkxx left join xx xxb on coalesce (xxa.pkxx, 1) = xxb.pkxx;

-- -- regression test for improper pushing of constants across outer-join clauses -- (as seen in early 8.2.x releases) -- create temp table zt1 (f1 int primary key);

create temp table zt2 (f2 int primary key);

create temp table zt3 (f3 int primary key);

insert into zt1 values(53);

insert into zt2 values(53);

select * from zt2 left join zt3 on (f2 = f3) left join zt1 on (f3 = f1) where f2 = 53;

create temp view zv1 as select *,'dummy'::text AS junk from zt1; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: expected at least one target column create temp view zv1 as select *,'dummy'::text AS junk from zt1; ^ select * from zt2 left join zt3 on (f2 = f3) left join zv1 on (f3 = f1) where f2 = 53; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.zv1 -- -- regression test for improper extraction of OR indexqual conditions -- (as seen in early 8.3.x releases) -- select a.unique2, a.ten, b.tenthous, b.unique2, b.hundred from tenk1 a left join tenk1 b on a.unique2 = b.tenthous where a.unique1 = 42 and ((b.unique2 is null and a.ten = 2) or b.hundred = 3); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem -- ^ -stdin-:

:1:1: Error: Duplicated member: unique2 -- ^ -- -- test proper positioning of one-time quals in EXISTS (8.4devel bug) -- prepare foo(bool) as select count(*) from tenk1 a left join tenk1 b on (a.unique2 = b.unique1 and exists (select 1 from tenk1 c where c.thousand = b.unique2 and $1)); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 301 -- ^ execute foo(true); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 302 execute foo(true); ^ execute foo(false); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 302 execute foo(false); ^ -- -- test for sane behavior with noncanonical merge clauses, per bug #4926 -- begin; set enable_mergejoin = 1; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: VariableSetStmt, not supported name: enable_mergejoin set enable_mergejoin = 1; ^ set enable_hashjoin = 0; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: VariableSetStmt, not supported name: enable_hashjoin set enable_hashjoin = 0; ^ set enable_nestloop = 0; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: VariableSetStmt, not supported name: enable_nestloop set enable_nestloop = 0; ^ create temp table a (i integer);

create temp table b (x integer, y integer);

select * from a left join b on i = x and i = y and x = i;

rollback;

-- -- test handling of merge clauses using record_ops -- begin;

create type mycomptype as (id int, v bigint); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 314 create type mycomptype as (id int, v bigint); ^ create temp table tidv (idv mycomptype);

create index on tidv (idv);

explain (costs off) select a.idv, b.idv from tidv a, tidv b where a.idv = b.idv; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) ^ set enable_mergejoin = 0; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: VariableSetStmt, not supported name: enable_mergejoin set enable_mergejoin = 0; ^ set enable_hashjoin = 0; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: VariableSetStmt, not supported name: enable_hashjoin set enable_hashjoin = 0; ^ explain (costs off) select a.idv, b.idv from tidv a, tidv b where a.idv = b.idv; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) ^ rollback; -- -- test NULL behavior of whole-row Vars, per bug #5025 -- select t1.q2, count(t2.*) from int8_tbl t1 left join int8_tbl t2 on (t1.q2 = t2.q1) group by t1.q2 order by 1; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem -- ^ -stdin-:

:4:15: Error: At function: PgAgg select t1.q2, count(t2.*) ^ -stdin-:

:4:21: Error: Expected PG type, but got: Struct select t1.q2, count(t2.*) ^ select t1.q2, count(t2.*) from int8_tbl t1 left join (select * from int8_tbl) t2 on (t1.q2 = t2.q1) group by t1.q2 order by 1; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem select t1.q2, count(t2.*) ^ -stdin-:

:1:15: Error: At function: PgAgg select t1.q2, count(t2.*) ^ -stdin-:

:1:21: Error: Expected PG type, but got: Struct select t1.q2, count(t2.*) ^ select t1.q2, count(t2.*) from int8_tbl t1 left join (select * from int8_tbl offset 0) t2 on (t1.q2 = t2.q1) group by t1.q2 order by 1; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem select t1.q2, count(t2.*) ^ -stdin-:

:1:15: Error: At function: PgAgg select t1.q2, count(t2.*) ^ -stdin-:

:1:21: Error: Expected PG type, but got: Struct select t1.q2, count(t2.*) ^ select t1.q2, count(t2.*) from int8_tbl t1 left join (select q1, case when q2=1 then 1 else q2 end as q2 from int8_tbl) t2 on (t1.q2 = t2.q1) group by t1.q2 order by 1; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem select t1.q2, count(t2.*) ^ -stdin-:

:1:15: Error: At function: PgAgg select t1.q2, count(t2.*) ^ -stdin-:

:1:21: Error: Expected PG type, but got: Struct select t1.q2, count(t2.*) ^ -- -- test incorrect failure to NULL pulled-up subexpressions -- begin;

create temp table a ( code char not null, constraint a_pk primary key (code) );

create temp table b ( a char not null, num integer not null, constraint b_pk primary key (a, num) );

create temp table c ( name char not null, a char, constraint c_pk primary key (name) );

insert into a (code) values ('p');

insert into a (code) values ('q');

insert into b (a, num) values ('p', 1);

insert into b (a, num) values ('p', 2);

insert into c (name, a) values ('A', 'p');

insert into c (name, a) values ('B', 'q');

insert into c (name, a) values ('C', null);

select c.name, ss.code, ss.b_cnt, ss.const from c left join (select a.code, coalesce(b_grp.cnt, 0) as b_cnt, -1 as const from a left join (select count(1) as cnt, b.a from b group by b.a) as b_grp on a.code = b_grp.a ) as ss on (c.a = ss.code) order by c.name; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgSelect, At function: PgSetItem, At function: PgSelect, At function: PgSetItem select c.name, ss.code, ss.b_cnt, ss.const ^ -stdin-:

:5:51: Error: No such column: a (select count(1) as cnt, b.a from b group by b.a) as b_grp ^ rollback;

-- -- test incorrect handling of placeholders that only appear in targetlists, -- per bug #6154 -- SELECT * FROM ( SELECT 1 as key1 ) sub1 LEFT JOIN ( SELECT sub3.key3, sub4.value2, COALESCE(sub4.value2, 66) as value3 FROM ( SELECT 1 as key3 ) sub3 LEFT JOIN ( SELECT sub5.key5, COALESCE(sub6.value1, 1) as value2 FROM ( SELECT 1 as key5 ) sub5 LEFT JOIN ( SELECT 2 as key6, 42 as value1 ) sub6 ON sub5.key5 = sub6.key6 ) sub4 ON sub4.key5 = sub3.key3 ) sub2 ON sub1.key1 = sub2.key3;

-- test the path using join aliases, too SELECT * FROM ( SELECT 1 as key1 ) sub1 LEFT JOIN ( SELECT sub3.key3, value2, COALESCE(value2, 66) as value3 FROM ( SELECT 1 as key3 ) sub3 LEFT JOIN ( SELECT sub5.key5, COALESCE(sub6.value1, 1) as value2 FROM ( SELECT 1 as key5 ) sub5 LEFT JOIN ( SELECT 2 as key6, 42 as value1 ) sub6 ON sub5.key5 = sub6.key6 ) sub4 ON sub4.key5 = sub3.key3 ) sub2 ON sub1.key1 = sub2.key3;

-- -- test case where a PlaceHolderVar is used as a nestloop parameter -- EXPLAIN (COSTS OFF) SELECT qq, unique1 FROM ( SELECT COALESCE(q1, 0) AS qq FROM int8_tbl a ) AS ss1 FULL OUTER JOIN ( SELECT COALESCE(q2, -1) AS qq FROM int8_tbl b ) AS ss2 USING (qq) INNER JOIN tenk1 c ON qq = unique2; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- ^ SELECT qq, unique1 FROM ( SELECT COALESCE(q1, 0) AS qq FROM int8_tbl a ) AS ss1 FULL OUTER JOIN ( SELECT COALESCE(q2, -1) AS qq FROM int8_tbl b ) AS ss2 USING (qq) INNER JOIN tenk1 c ON qq = unique2; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem SELECT qq, unique1 ^ -stdin-:

:7:25: Error: Column reference is ambiguous: qq INNER JOIN tenk1 c ON qq = unique2; ^ -- -- nested nestloops can require nested PlaceHolderVars -- create temp table nt1 ( id int primary key, a1 boolean, a2 boolean ); create temp table nt2 ( id int primary key, nt1_id int, b1 boolean, b2 boolean, foreign key (nt1_id) references nt1(id) ); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: table constraint not supported create temp table nt2 ( ^ create temp table nt3 ( id int primary key, nt2_id int, c1 boolean, foreign key (nt2_id) references nt2(id) ); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: table constraint not supported create temp table nt3 ( ^ insert into nt1 values (1,true,true);

insert into nt1 values (2,true,false);

insert into nt1 values (3,false,false);

insert into nt2 values (1,1,true,true); -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.nt2 insert into nt2 values (2,2,true,false); -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.nt2 insert into nt2 values (3,3,false,false); -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.nt2 insert into nt3 values (1,1,true); -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.nt3 insert into nt3 values (2,2,false); -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.nt3 insert into nt3 values (3,3,true); -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.nt3 explain (costs off) select nt3.id from nt3 as nt3 left join (select nt2.*, (nt2.b1 and ss1.a3) AS b3 from nt2 as nt2 left join (select nt1.*, (nt1.id is not null) as a3 from nt1) as ss1 on ss1.id = nt2.nt1_id ) as ss2 on ss2.id = nt3.nt2_id where nt3.id = 1 and ss2.b3; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) ^ select nt3.id from nt3 as nt3 left join (select nt2.*, (nt2.b1 and ss1.a3) AS b3 from nt2 as nt2 left join (select nt1.*, (nt1.id is not null) as a3 from nt1) as ss1 on ss1.id = nt2.nt1_id ) as ss2 on ss2.id = nt3.nt2_id where nt3.id = 1 and ss2.b3; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.nt2 -- -- test case where a PlaceHolderVar is propagated into a subquery -- explain (costs off) select * from int8_tbl t1 left join (select q1 as x, 42 as y from int8_tbl t2) ss on t1.q2 = ss.x where 1 = (select 1 from int8_tbl t3 where ss.y is not null limit 1) order by 1,2; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- ^ select * from int8_tbl t1 left join (select q1 as x, 42 as y from int8_tbl t2) ss on t1.q2 = ss.x where 1 = (select 1 from int8_tbl t3 where ss.y is not null limit 1) order by 1,2; -- -- variant where a PlaceHolderVar is needed at a join, but not above the join -- explain (costs off) select * from int4_tbl as i41, lateral (select 1 as x from (select i41.f1 as lat, i42.f1 as loc from int8_tbl as i81, int4_tbl as i42) as ss1 right join int4_tbl as i43 on (i43.f1 > 1) where ss1.loc = ss1.lat) as ss2 where i41.f1 > 0; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- ^ select * from int4_tbl as i41, lateral (select 1 as x from (select i41.f1 as lat, i42.f1 as loc from int8_tbl as i81, int4_tbl as i42) as ss1 right join int4_tbl as i43 on (i43.f1 > 1) where ss1.loc = ss1.lat) as ss2 where i41.f1 > 0; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RangeSubselect: unsupported lateral select * from ^ -- -- test the corner cases FULL JOIN ON TRUE and FULL JOIN ON FALSE -- select * from int4_tbl a full join int4_tbl b on true; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem -- ^ -stdin-:

:1:1: Error: Duplicated member: f1 -- ^ select * from int4_tbl a full join int4_tbl b on false; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem select * from int4_tbl a full join int4_tbl b on false; ^ -stdin-:

:1:1: Error: Duplicated member: f1 select * from int4_tbl a full join int4_tbl b on false; ^ -- -- test for ability to use a cartesian join when necessary -- create temp table q1 as select 1 as q1; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 277 -- ^ create temp table q2 as select 0 as q2; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 277 create temp table q2 as select 0 as q2; ^ analyze q1; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 275 analyze q1; ^ analyze q2; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 275 analyze q2; ^ explain (costs off) select * from tenk1 join int4_tbl on f1 = twothousand, q1, q2 where q1 = thousand or q2 = thousand; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) ^ explain (costs off) select * from tenk1 join int4_tbl on f1 = twothousand, q1, q2 where thousand = (q1 + q2); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) ^ -- -- test ability to generate a suitable plan for a star-schema query -- explain (costs off) select * from tenk1, int8_tbl a, int8_tbl b where thousand = a.q1 and tenthous = b.q1 and a.q2 = 1 and b.q2 = 2; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- ^ -- -- test a corner case in which we shouldn't apply the star-schema optimization -- explain (costs off) select t1.unique2, t1.stringu1, t2.unique1, t2.stringu2 from tenk1 t1 inner join int4_tbl i1 left join (select v1.x2, v2.y1, 11 AS d1 from (select 1,0 from onerow) v1(x1,x2) left join (select 3,1 from onerow) v2(y1,y2) on v1.x1 = v2.y2) subq1 on (i1.f1 = subq1.x2) on (t1.unique2 = subq1.d1) left join tenk1 t2 on (subq1.y1 = t2.unique1) where t1.unique2 < 42 and t1.stringu1 > t2.stringu2; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- ^ select t1.unique2, t1.stringu1, t2.unique1, t2.stringu2 from tenk1 t1 inner join int4_tbl i1 left join (select v1.x2, v2.y1, 11 AS d1 from (select 1,0 from onerow) v1(x1,x2) left join (select 3,1 from onerow) v2(y1,y2) on v1.x1 = v2.y2) subq1 on (i1.f1 = subq1.x2) on (t1.unique2 = subq1.d1) left join tenk1 t2 on (subq1.y1 = t2.unique1) where t1.unique2 < 42 and t1.stringu1 > t2.stringu2; -- variant that isn't quite a star-schema case select ss1.d1 from tenk1 as t1 inner join tenk1 as t2 on t1.tenthous = t2.ten inner join int8_tbl as i8 left join int4_tbl as i4 inner join (select 64::information_schema.cardinal_number as d1 from tenk1 t3, lateral (select abs(t3.unique1) + random()) ss0(x) where t3.fivethous < 0) as ss1 on i4.f1 = ss1.d1 on i8.q1 = i4.f1 on t1.tenthous = ss1.d1 where t1.unique1 < i4.f1; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RangeSubselect: unsupported lateral -- variant that isn't quite a star-schema case ^ -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect -- variant that isn't quite a star-schema case ^ -stdin-:

:1:1: Error: Recursive query does not have the form non-recursive-term UNION [ALL] recursive-term -- variant that isn't quite a star-schema case ^ -- this variant is foldable by the remove-useless-RESULT-RTEs code explain (costs off) select t1.unique2, t1.stringu1, t2.unique1, t2.stringu2 from tenk1 t1 inner join int4_tbl i1 left join (select v1.x2, v2.y1, 11 AS d1 from (values(1,0)) v1(x1,x2) left join (values(3,1)) v2(y1,y2) on v1.x1 = v2.y2) subq1 on (i1.f1 = subq1.x2) on (t1.unique2 = subq1.d1) left join tenk1 t2 on (subq1.y1 = t2.unique1) where t1.unique2 < 42 and t1.stringu1 > t2.stringu2; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- this variant is foldable by the remove-useless-RESULT-RTEs code ^ select t1.unique2, t1.stringu1, t2.unique1, t2.stringu2 from tenk1 t1 inner join int4_tbl i1 left join (select v1.x2, v2.y1, 11 AS d1 from (values(1,0)) v1(x1,x2) left join (values(3,1)) v2(y1,y2) on v1.x1 = v2.y2) subq1 on (i1.f1 = subq1.x2) on (t1.unique2 = subq1.d1) left join tenk1 t2 on (subq1.y1 = t2.unique1) where t1.unique2 < 42 and t1.stringu1 > t2.stringu2; -- Here's a variant that we can't fold too aggressively, though, -- or we end up with noplace to evaluate the lateral PHV explain (verbose, costs off) select * from (select 1 as x) ss1 left join (select 2 as y) ss2 on (true), lateral (select ss2.y as z limit 1) ss3; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- Here's a variant that we can't fold too aggressively, though, ^ select * from (select 1 as x) ss1 left join (select 2 as y) ss2 on (true), lateral (select ss2.y as z limit 1) ss3; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RangeSubselect: unsupported lateral select * from ^ -- Test proper handling of appendrel PHVs during useless-RTE removal explain (costs off) select * from (select 0 as z) as t1 left join (select true as a) as t2 on true, lateral (select true as b union all select a as b) as t3 where b; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- Test proper handling of appendrel PHVs during useless-RTE removal ^ select * from (select 0 as z) as t1 left join (select true as a) as t2 on true, lateral (select true as b union all select a as b) as t3 where b; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RangeSubselect: unsupported lateral select * from ^ -- -- test inlining of immutable functions -- create function f_immutable_int4(i integer) returns integer as $$ begin return i; end; $$ language plpgsql immutable; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 261 -- ^ -- check optimization of function scan with join explain (costs off) select unique1 from tenk1, (select * from f_immutable_int4(1) x) x where x = unique1; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- check optimization of function scan with join ^ explain (verbose, costs off) select unique1, x.* from tenk1, (select *, random() from f_immutable_int4(1) x) x where x = unique1; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (verbose, costs off) ^ explain (costs off) select unique1 from tenk1, f_immutable_int4(1) x where x = unique1; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) ^ explain (costs off) select unique1 from tenk1, lateral f_immutable_int4(1) x where x = unique1; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) ^ explain (costs off) select unique1 from tenk1, lateral f_immutable_int4(1) x where x in (select 17); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) ^ explain (costs off) select unique1, x from tenk1 join f_immutable_int4(1) x on unique1 = x; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) ^ explain (costs off) select unique1, x from tenk1 left join f_immutable_int4(1) x on unique1 = x; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) ^ explain (costs off) select unique1, x from tenk1 right join f_immutable_int4(1) x on unique1 = x; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) ^ explain (costs off) select unique1, x from tenk1 full join f_immutable_int4(1) x on unique1 = x; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) ^ -- check that pullup of a const function allows further const-folding explain (costs off) select unique1 from tenk1, f_immutable_int4(1) x where x = 42; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- check that pullup of a const function allows further const-folding ^ -- test inlining of immutable functions with PlaceHolderVars explain (costs off) select nt3.id from nt3 as nt3 left join (select nt2.*, (nt2.b1 or i4 = 42) AS b3 from nt2 as nt2 left join f_immutable_int4(0) i4 on i4 = nt2.nt1_id ) as ss2 on ss2.id = nt3.nt2_id where nt3.id = 1 and ss2.b3; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- test inlining of immutable functions with PlaceHolderVars ^ drop function f_immutable_int4(int); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: DropStmt: alternative is not implemented yet : 386 drop function f_immutable_int4(int); ^ -- test inlining when function returns composite create function mki8(bigint, bigint) returns int8_tbl as $$select row($1,$2)::int8_tbl$$ language sql; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 261 -- test inlining when function returns composite ^ create function mki4(int) returns int4_tbl as $$select row($1)::int4_tbl$$ language sql; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 261 create function mki4(int) returns int4_tbl as ^ explain (verbose, costs off) select * from mki8(1,2); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (verbose, costs off) ^ select * from mki8(1,2); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem select * from mki8(1,2); ^ -stdin-:

:1:15: Error: At function: PgCall select * from mki8(1,2); ^ -stdin-:

:1:15: Error: No such proc: mki8 select * from mki8(1,2); ^ explain (verbose, costs off) select * from mki4(42); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (verbose, costs off) ^ select * from mki4(42); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem select * from mki4(42); ^ -stdin-:

:1:15: Error: At function: PgCall select * from mki4(42); ^ -stdin-:

:1:15: Error: No such proc: mki4 select * from mki4(42); ^ drop function mki8(bigint, bigint); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: DropStmt: alternative is not implemented yet : 386 drop function mki8(bigint, bigint); ^ drop function mki4(int); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: DropStmt: alternative is not implemented yet : 386 drop function mki4(int); ^ -- -- test extraction of restriction OR clauses from join OR clause -- (we used to only do this for indexable clauses) -- explain (costs off) select * from tenk1 a join tenk1 b on (a.unique1 = 1 and b.unique1 = 2) or (a.unique2 = 3 and b.hundred = 4); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- ^ explain (costs off) select * from tenk1 a join tenk1 b on (a.unique1 = 1 and b.unique1 = 2) or (a.unique2 = 3 and b.ten = 4); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) ^ explain (costs off) select * from tenk1 a join tenk1 b on (a.unique1 = 1 and b.unique1 = 2) or ((a.unique2 = 3 or a.unique2 = 7) and b.hundred = 4); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) ^ -- -- test placement of movable quals in a parameterized join tree -- explain (costs off) select * from tenk1 t1 left join (tenk1 t2 join tenk1 t3 on t2.thousand = t3.unique2) on t1.hundred = t2.hundred and t1.ten = t3.ten where t1.unique1 = 1; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- ^ explain (costs off) select * from tenk1 t1 left join (tenk1 t2 join tenk1 t3 on t2.thousand = t3.unique2) on t1.hundred = t2.hundred and t1.ten + t2.ten = t3.ten where t1.unique1 = 1; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) ^ explain (costs off) select count(*) from tenk1 a join tenk1 b on a.unique1 = b.unique2 left join tenk1 c on a.unique2 = b.unique1 and c.thousand = a.thousand join int4_tbl on b.thousand = f1; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) ^ select count(*) from tenk1 a join tenk1 b on a.unique1 = b.unique2 left join tenk1 c on a.unique2 = b.unique1 and c.thousand = a.thousand join int4_tbl on b.thousand = f1; explain (costs off) select b.unique1 from tenk1 a join tenk1 b on a.unique1 = b.unique2 left join tenk1 c on b.unique1 = 42 and c.thousand = a.thousand join int4_tbl i1 on b.thousand = f1 right join int4_tbl i2 on i2.f1 = b.tenthous order by 1; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) ^ select b.unique1 from tenk1 a join tenk1 b on a.unique1 = b.unique2 left join tenk1 c on b.unique1 = 42 and c.thousand = a.thousand join int4_tbl i1 on b.thousand = f1 right join int4_tbl i2 on i2.f1 = b.tenthous order by 1; explain (costs off) select * from ( select unique1, q1, coalesce(unique1, -1) + q1 as fault from int8_tbl left join tenk1 on (q2 = unique2) ) ss where fault = 122 order by fault; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) ^ select * from ( select unique1, q1, coalesce(unique1, -1) + q1 as fault from int8_tbl left join tenk1 on (q2 = unique2) ) ss where fault = 122 order by fault; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: PgSelect, At function: PgSetItem, At function: AssumeColumnOrder, At function: PgReplaceUnknown, At function: OrderedMap, At function: OrderedMap, At function: EquiJoin select * from ^ -stdin-:

:1:1: Error: Cannot compare key columns (a._alias_int8_tbl.q2 has type: pgint8, b._alias_tenk1.unique2 has type: pgint4) select * from ^ explain (costs off) select * from (values (1, array[10,20]), (2, array[20,30])) as v1(v1x,v1ys) left join (values (1, 10), (2, 20)) as v2(v2x,v2y) on v2x = v1x left join unnest(v1ys) as u1(u1y) on u1y = v2y; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) ^ select * from (values (1, array[10,20]), (2, array[20,30])) as v1(v1x,v1ys) left join (values (1, 10), (2, 20)) as v2(v2x,v2y) on v2x = v1x left join unnest(v1ys) as u1(u1y) on u1y = v2y; -stdin-:

: Error: Parse Sql -stdin-:

:4:18: Error: Columns are not allowed in: RANGE FUNCTION left join unnest(v1ys) as u1(u1y) on u1y = v2y; ^ -- -- test handling of potential equivalence clauses above outer joins -- explain (costs off) select q1, unique2, thousand, hundred from int8_tbl a left join tenk1 b on q1 = unique2 where coalesce(thousand,123) = q1 and q1 = coalesce(hundred,123); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- ^ select q1, unique2, thousand, hundred from int8_tbl a left join tenk1 b on q1 = unique2 where coalesce(thousand,123) = q1 and q1 = coalesce(hundred,123); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: AssumeColumnOrder, At function: PgReplaceUnknown, At function: OrderedMap, At function: OrderedFilter, At function: OrderedMap, At function: EquiJoin select q1, unique2, thousand, hundred ^ -stdin-:

:1:1: Error: Cannot compare key columns (a._alias_a.q1 has type: pgint8, b._alias_b.unique2 has type: pgint4) select q1, unique2, thousand, hundred ^ explain (costs off) select f1, unique2, case when unique2 is null then f1 else 0 end from int4_tbl a left join tenk1 b on f1 = unique2 where (case when unique2 is null then f1 else 0 end) = 0; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) ^ select f1, unique2, case when unique2 is null then f1 else 0 end from int4_tbl a left join tenk1 b on f1 = unique2 where (case when unique2 is null then f1 else 0 end) = 0; -- -- another case with equivalence clauses above outer joins (bug #8591) -- explain (costs off) select a.unique1, b.unique1, c.unique1, coalesce(b.twothousand, a.twothousand) from tenk1 a left join tenk1 b on b.thousand = a.unique1 left join tenk1 c on c.unique2 = coalesce(b.twothousand, a.twothousand) where a.unique2 < 10 and coalesce(b.twothousand, a.twothousand) = 44; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- ^ select a.unique1, b.unique1, c.unique1, coalesce(b.twothousand, a.twothousand) from tenk1 a left join tenk1 b on b.thousand = a.unique1 left join tenk1 c on c.unique2 = coalesce(b.twothousand, a.twothousand) where a.unique2 < 10 and coalesce(b.twothousand, a.twothousand) = 44; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem select a.unique1, b.unique1, c.unique1, coalesce(b.twothousand, a.twothousand) ^ -stdin-:

:1:1: Error: Duplicated member: unique1 select a.unique1, b.unique1, c.unique1, coalesce(b.twothousand, a.twothousand) ^ -- -- check handling of join aliases when flattening multiple levels of subquery -- explain (verbose, costs off) select foo1.join_key as foo1_id, foo3.join_key AS foo3_id, bug_field from (values (0),(1)) foo1(join_key) left join (select join_key, bug_field from (select ss1.join_key, ss1.bug_field from (select f1 as join_key, 666 as bug_field from int4_tbl i1) ss1 ) foo2 left join (select unique2 as join_key from tenk1 i2) ss2 using (join_key) ) foo3 using (join_key); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- ^ select foo1.join_key as foo1_id, foo3.join_key AS foo3_id, bug_field from (values (0),(1)) foo1(join_key) left join (select join_key, bug_field from (select ss1.join_key, ss1.bug_field from (select f1 as join_key, 666 as bug_field from int4_tbl i1) ss1 ) foo2 left join (select unique2 as join_key from tenk1 i2) ss2 using (join_key) ) foo3 using (join_key); -- -- test successful handling of nested outer joins with degenerate join quals -- explain (verbose, costs off) select t1.* from text_tbl t1 left join (select *, '***'::text as d1 from int8_tbl i8b1) b1 left join int8_tbl i8 left join (select *, null::int as d2 from int8_tbl i8b2) b2 on (i8.q1 = b2.q1) on (b2.d2 = b1.q2) on (t1.f1 = b1.d1) left join int4_tbl i4 on (i8.q2 = i4.f1); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- ^ select t1.* from text_tbl t1 left join (select *, '***'::text as d1 from int8_tbl i8b1) b1 left join int8_tbl i8 left join (select *, null::int as d2 from int8_tbl i8b2) b2 on (i8.q1 = b2.q1) on (b2.d2 = b1.q2) on (t1.f1 = b1.d1) left join int4_tbl i4 on (i8.q2 = i4.f1); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: AssumeColumnOrder, At function: PgReplaceUnknown, At function: OrderedMap, At function: OrderedMap, At function: EquiJoin, At function: OrderedMap, At function: EquiJoin, At function: OrderedMap, At function: EquiJoin select t1.* from ^ -stdin-:

:1:1: Error: Cannot compare key columns (a._alias_b1.q2 has type: pgint8, b._alias_b2.d2 has type: pgint4) select t1.* from ^ explain (verbose, costs off) select t1.* from text_tbl t1 left join (select *, '***'::text as d1 from int8_tbl i8b1) b1 left join int8_tbl i8 left join (select *, null::int as d2 from int8_tbl i8b2, int4_tbl i4b2) b2 on (i8.q1 = b2.q1) on (b2.d2 = b1.q2) on (t1.f1 = b1.d1) left join int4_tbl i4 on (i8.q2 = i4.f1); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (verbose, costs off) ^ select t1.* from text_tbl t1 left join (select *, '***'::text as d1 from int8_tbl i8b1) b1 left join int8_tbl i8 left join (select *, null::int as d2 from int8_tbl i8b2, int4_tbl i4b2) b2 on (i8.q1 = b2.q1) on (b2.d2 = b1.q2) on (t1.f1 = b1.d1) left join int4_tbl i4 on (i8.q2 = i4.f1); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: Cannot compare key columns (a._alias_b1.q2 has type: pgint8, b._alias_b2.d2 has type: pgint4) select t1.* from ^ explain (verbose, costs off) select t1.* from text_tbl t1 left join (select *, '***'::text as d1 from int8_tbl i8b1) b1 left join int8_tbl i8 left join (select *, null::int as d2 from int8_tbl i8b2, int4_tbl i4b2 where q1 = f1) b2 on (i8.q1 = b2.q1) on (b2.d2 = b1.q2) on (t1.f1 = b1.d1) left join int4_tbl i4 on (i8.q2 = i4.f1); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (verbose, costs off) ^ select t1.* from text_tbl t1 left join (select *, '***'::text as d1 from int8_tbl i8b1) b1 left join int8_tbl i8 left join (select *, null::int as d2 from int8_tbl i8b2, int4_tbl i4b2 where q1 = f1) b2 on (i8.q1 = b2.q1) on (b2.d2 = b1.q2) on (t1.f1 = b1.d1) left join int4_tbl i4 on (i8.q2 = i4.f1); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: Cannot compare key columns (a._alias_b1.q2 has type: pgint8, b._alias_b2.d2 has type: pgint4) select t1.* from ^ explain (verbose, costs off) select * from text_tbl t1 inner join int8_tbl i8 on i8.q2 = 456 right join text_tbl t2 on t1.f1 = 'doh!' left join int4_tbl i4 on i8.q1 = i4.f1; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (verbose, costs off) ^ select * from text_tbl t1 inner join int8_tbl i8 on i8.q2 = 456 right join text_tbl t2 on t1.f1 = 'doh!' left join int4_tbl i4 on i8.q1 = i4.f1; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem select * from ^ -stdin-:

:1:1: Error: Duplicated member: f1 select * from ^ -- -- test for appropriate join order in the presence of lateral references -- explain (verbose, costs off) select * from text_tbl t1 left join int8_tbl i8 on i8.q2 = 123, lateral (select i8.q1, t2.f1 from text_tbl t2 limit 1) as ss where t1.f1 = ss.f1; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- ^ select * from text_tbl t1 left join int8_tbl i8 on i8.q2 = 123, lateral (select i8.q1, t2.f1 from text_tbl t2 limit 1) as ss where t1.f1 = ss.f1; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RangeSubselect: unsupported lateral select * from ^ -stdin-: