: Error: Parse Sql -stdin-:

:6:27: Error: sortby_dir unsupported value: 3 ORDER BY unique1 using >; ^ -- -- awk '{if($1>980){print $1,$14;}else{next;}}' onek.data | sort +1d -2 -- SELECT onek.unique1, onek.stringu1 FROM onek WHERE onek.unique1 > 980 ORDER BY stringu1 using <; -stdin-:

: Error: Parse Sql -stdin-:

:6:28: Error: sortby_dir unsupported value: 3 ORDER BY stringu1 using <; ^ -- -- awk '{if($1>980){print $1,$16;}else{next;}}' onek.data | -- sort +1d -2 +0nr -1 -- SELECT onek.unique1, onek.string4 FROM onek WHERE onek.unique1 > 980 ORDER BY string4 using <, unique1 using >; -stdin-:

: Error: Parse Sql -stdin-:

:7:27: Error: sortby_dir unsupported value: 3 ORDER BY string4 using <, unique1 using >; ^ -- -- awk '{if($1>980){print $1,$16;}else{next;}}' onek.data | -- sort +1dr -2 +0n -1 -- SELECT onek.unique1, onek.string4 FROM onek WHERE onek.unique1 > 980 ORDER BY string4 using >, unique1 using <; -stdin-:

: Error: Parse Sql -stdin-:

:7:27: Error: sortby_dir unsupported value: 3 ORDER BY string4 using >, unique1 using <; ^ -- -- awk '{if($1<20){print $1,$16;}else{next;}}' onek.data | -- sort +0nr -1 +1d -2 -- SELECT onek.unique1, onek.string4 FROM onek WHERE onek.unique1 < 20 ORDER BY unique1 using >, string4 using <; -stdin-:

: Error: Parse Sql -stdin-:

:7:27: Error: sortby_dir unsupported value: 3 ORDER BY unique1 using >, string4 using <; ^ -- -- awk '{if($1<20){print $1,$16;}else{next;}}' onek.data | -- sort +0n -1 +1dr -2 -- SELECT onek.unique1, onek.string4 FROM onek WHERE onek.unique1 < 20 ORDER BY unique1 using <, string4 using >; -stdin-:

: Error: Parse Sql -stdin-:

:7:27: Error: sortby_dir unsupported value: 3 ORDER BY unique1 using <, string4 using >; ^ -- -- test partial btree indexes -- -- As of 7.2, planner probably won't pick an indexscan without stats, -- so ANALYZE first. Also, we want to prevent it from picking a bitmapscan -- followed by sort, because that could hide index ordering problems. -- ANALYZE onek2; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 275 -- ^ SET enable_seqscan TO off; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: VariableSetStmt, not supported name: enable_seqscan SET enable_seqscan TO off; ^ SET enable_bitmapscan TO off; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: VariableSetStmt, not supported name: enable_bitmapscan SET enable_bitmapscan TO off; ^ SET enable_sort TO off; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: VariableSetStmt, not supported name: enable_sort SET enable_sort TO off; ^ -- -- awk '{if($1<10){print $0;}else{next;}}' onek.data | sort +0n -1 -- SELECT onek2.* FROM onek2 WHERE onek2.unique1 < 10; -- -- awk '{if($1<20){print $1,$14;}else{next;}}' onek.data | sort +0nr -1 -- SELECT onek2.unique1, onek2.stringu1 FROM onek2 WHERE onek2.unique1 < 20 ORDER BY unique1 using >; -stdin-:

: Error: Parse Sql -stdin-:

:6:28: Error: sortby_dir unsupported value: 3 ORDER BY unique1 using >; ^ -- -- awk '{if($1>980){print $1,$14;}else{next;}}' onek.data | sort +1d -2 -- SELECT onek2.unique1, onek2.stringu1 FROM onek2 WHERE onek2.unique1 > 980; RESET enable_seqscan; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: VariableSetStmt, not supported kind: 4 RESET enable_seqscan; ^ RESET enable_bitmapscan; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: VariableSetStmt, not supported kind: 4 RESET enable_bitmapscan; ^ RESET enable_sort; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: VariableSetStmt, not supported kind: 4 RESET enable_sort; ^ SELECT two, stringu1, ten, string4 INTO TABLE tmp FROM onek; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: SelectStmt: not supported intoClause SELECT two, stringu1, ten, string4 ^ -- -- awk '{print $1,$2;}' person.data | -- awk '{if(NF!=2){print $3,$2;}else{print;}}' - emp.data | -- awk '{if(NF!=2){print $3,$2;}else{print;}}' - student.data | -- awk 'BEGIN{FS=" ";}{if(NF!=2){print $4,$5;}else{print;}}' - stud_emp.data -- -- SELECT name, age FROM person*; ??? check if different SELECT p.name, p.age FROM person* p; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.person -- -- awk '{print $1,$2;}' person.data | -- awk '{if(NF!=2){print $3,$2;}else{print;}}' - emp.data | -- awk '{if(NF!=2){print $3,$2;}else{print;}}' - student.data | -- awk 'BEGIN{FS=" ";}{if(NF!=1){print $4,$5;}else{print;}}' - stud_emp.data | -- sort +1nr -2 -- SELECT p.name, p.age FROM person* p ORDER BY age using >, name; -stdin-:

: Error: Parse Sql -stdin-:

:8:56: Error: sortby_dir unsupported value: 3 SELECT p.name, p.age FROM person* p ORDER BY age using >, name; ^ -- -- Test some cases involving whole-row Var referencing a subquery -- select foo from (select 1 offset 0) as foo;

select foo from (select null offset 0) as foo;

select foo from (select 'xyzzy',1,null offset 0) as foo;

-- -- Test VALUES lists -- select * from onek, (values(147, 'RFAAAA'), (931, 'VJAAAA')) as v (i, j) WHERE onek.unique1 = v.i and onek.stringu1 = v.j; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: OrderedMap, At function: EquiJoin -- ^ -stdin-:

:1:1: Error: Cannot compare key columns (0.stringu1 has type: pgname, 1._alias_v.j has type: pgtext) -- ^ -- a more complex case -- looks like we're coding lisp :-) select * from onek, (values ((select i from (values(10000), (2), (389), (1000), (2000), ((select 10029))) as foo(i) order by i asc limit 1))) bar (i) where onek.unique1 = bar.i; -stdin-:

: Error: Parse Sql -stdin-:

:4:12: Error: SubLinks are not allowed in: VALUES (values ((select i from ^ -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect -- a more complex case ^ -stdin-:

:1:1: Error: Recursive query does not have the form non-recursive-term UNION [ALL] recursive-term -- a more complex case ^ -- try VALUES in a subquery select * from onek where (unique1,ten) in (values (1,1), (20,0), (99,9), (17,99)) order by unique1; -stdin-:

: Error: Parse Sql -stdin-:

:3:25: Error: alternative is not implemented yet : 138 where (unique1,ten) in (values (1,1), (20,0), (99,9), (17,99)) ^ -- VALUES is also legal as a standalone query or a set-operation member VALUES (1,2), (3,4+4), (7,77.7);

VALUES (1,2), (3,4+4), (7,77.7) UNION ALL SELECT 2+2, 57 UNION ALL TABLE int8_tbl;

-- corner case: VALUES with no columns CREATE TEMP TABLE nocols();

INSERT INTO nocols DEFAULT VALUES; -stdin-:

: 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'. SELECT * FROM nocols n, LATERAL (VALUES(n.*)) v; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RangeSubselect: unsupported lateral SELECT * FROM nocols n, LATERAL (VALUES(n.*)) v; ^ -- -- Test ORDER BY options -- CREATE TEMP TABLE foo (f1 int);

INSERT INTO foo VALUES (42),(3),(10),(7),(null),(null),(1);

SELECT * FROM foo ORDER BY f1;

SELECT * FROM foo ORDER BY f1 ASC; -- same thing

SELECT * FROM foo ORDER BY f1 NULLS FIRST;

SELECT * FROM foo ORDER BY f1 DESC;

SELECT * FROM foo ORDER BY f1 DESC NULLS LAST;

-- check if indexscans do the right things CREATE INDEX fooi ON foo (f1);

SET enable_sort = false; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: VariableSetStmt, not supported name: enable_sort SET enable_sort = false; ^ SELECT * FROM foo ORDER BY f1;

SELECT * FROM foo ORDER BY f1 NULLS FIRST;

SELECT * FROM foo ORDER BY f1 DESC;

SELECT * FROM foo ORDER BY f1 DESC NULLS LAST;

DROP INDEX fooi; -stdin-:

: Error: Pre type annotation -stdin-:

:1:1: Error: Unexpected tag: pgObject DROP INDEX fooi; ^ CREATE INDEX fooi ON foo (f1 DESC);

SELECT * FROM foo ORDER BY f1;

SELECT * FROM foo ORDER BY f1 NULLS FIRST;

SELECT * FROM foo ORDER BY f1 DESC;

SELECT * FROM foo ORDER BY f1 DESC NULLS LAST;

DROP INDEX fooi; -stdin-:

: Error: Pre type annotation -stdin-:

:1:1: Error: Unexpected tag: pgObject DROP INDEX fooi; ^ CREATE INDEX fooi ON foo (f1 DESC NULLS LAST);

SELECT * FROM foo ORDER BY f1;

SELECT * FROM foo ORDER BY f1 NULLS FIRST;

SELECT * FROM foo ORDER BY f1 DESC;

SELECT * FROM foo ORDER BY f1 DESC NULLS LAST;

-- -- Test planning of some cases with partial indexes -- -- partial index is usable explain (costs off) select * from onek2 where unique2 = 11 and stringu1 = 'ATAAAA'; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- ^ select * from onek2 where unique2 = 11 and stringu1 = 'ATAAAA'; -- actually run the query with an analyze to use the partial index explain (costs off, analyze on, timing off, summary off) select * from onek2 where unique2 = 11 and stringu1 = 'ATAAAA'; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- actually run the query with an analyze to use the partial index ^ explain (costs off) select unique2 from onek2 where unique2 = 11 and stringu1 = 'ATAAAA'; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) ^ select unique2 from onek2 where unique2 = 11 and stringu1 = 'ATAAAA'; -- partial index predicate implies clause, so no need for retest explain (costs off) select * from onek2 where unique2 = 11 and stringu1 < 'B'; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- partial index predicate implies clause, so no need for retest ^ select * from onek2 where unique2 = 11 and stringu1 < 'B'; explain (costs off) select unique2 from onek2 where unique2 = 11 and stringu1 < 'B'; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) ^ select unique2 from onek2 where unique2 = 11 and stringu1 < 'B'; -- but if it's an update target, must retest anyway explain (costs off) select unique2 from onek2 where unique2 = 11 and stringu1 < 'B' for update; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- but if it's an update target, must retest anyway ^ select unique2 from onek2 where unique2 = 11 and stringu1 < 'B' for update; -- partial index is not applicable explain (costs off) select unique2 from onek2 where unique2 = 11 and stringu1 < 'C'; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- partial index is not applicable ^ select unique2 from onek2 where unique2 = 11 and stringu1 < 'C'; -- partial index implies clause, but bitmap scan must recheck predicate anyway SET enable_indexscan TO off; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: VariableSetStmt, not supported name: enable_indexscan -- partial index implies clause, but bitmap scan must recheck predicate anyway ^ explain (costs off) select unique2 from onek2 where unique2 = 11 and stringu1 < 'B'; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) ^ select unique2 from onek2 where unique2 = 11 and stringu1 < 'B'; RESET enable_indexscan; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: VariableSetStmt, not supported kind: 4 RESET enable_indexscan; ^ -- check multi-index cases too explain (costs off) select unique1, unique2 from onek2 where (unique2 = 11 or unique1 = 0) and stringu1 < 'B'; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 -- check multi-index cases too ^ select unique1, unique2 from onek2 where (unique2 = 11 or unique1 = 0) and stringu1 < 'B'; explain (costs off) select unique1, unique2 from onek2 where (unique2 = 11 and stringu1 < 'B') or unique1 = 0; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) ^ select unique1, unique2 from onek2 where (unique2 = 11 and stringu1 < 'B') or unique1 = 0; -- -- Test some corner cases that have been known to confuse the planner -- -- ORDER BY on a constant doesn't really need any sorting SELECT 1 AS x ORDER BY x; -stdin-:

: Error: Type annotation -stdin-:

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

:5:24: Error: Column reference can't be used without FROM SELECT 1 AS x ORDER BY x; ^ -- But ORDER BY on a set-valued expression does create function sillysrf(int) returns setof int as 'values (1),(10),(2),($1)' language sql immutable; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 261 -- But ORDER BY on a set-valued expression does ^ select sillysrf(42); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem select sillysrf(42); ^ -stdin-:

:1:8: Error: At function: PgCall select sillysrf(42); ^ -stdin-:

:1:8: Error: No such proc: sillysrf select sillysrf(42); ^ select sillysrf(-1) order by 1; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem select sillysrf(-1) order by 1; ^ -stdin-:

:1:8: Error: At function: PgCall select sillysrf(-1) order by 1; ^ -stdin-:

:1:8: Error: No such proc: sillysrf select sillysrf(-1) order by 1; ^ drop function sillysrf(int); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: DropStmt: alternative is not implemented yet : 386 drop function sillysrf(int); ^ -- X = X isn't a no-op, it's effectively X IS NOT NULL assuming = is strict -- (see bug #5084) select * from (values (2),(null),(1)) v(k) where k = k order by k;

select * from (values (2),(null),(1)) v(k) where k = k;

-- Test partitioned tables with no partitions, which should be handled the -- same as the non-inheritance case when expanding its RTE. create table list_parted_tbl (a int,b int) partition by list (a); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: PARTITION BY clause not supported -- Test partitioned tables with no partitions, which should be handled the ^ create table list_parted_tbl1 partition of list_parted_tbl for values in (1) partition by list(b); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: table inheritance not supported create table list_parted_tbl1 partition of list_parted_tbl ^ explain (costs off) select * from list_parted_tbl; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) select * from list_parted_tbl; ^ drop table list_parted_tbl;