: Fatal: Execution -stdin-:

:1:1: Fatal: Execution of node: YtFill! -- ^ -stdin-:

:1:1: Fatal: ERROR: invalid input syntax for type smallint: "{1,2,3,4,5}" -- ^ UPDATE arrtest SET e[0] = '1.1'; -stdin-:

: Fatal: Pre type annotation -stdin-:

: Fatal: tools/enum_parser/enum_serialization_runtime/enum_runtime.cpp:70: Key 'pg_update' 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'. UPDATE arrtest SET e[1] = '2.2'; -stdin-:

: Fatal: Pre type annotation -stdin-:

: Fatal: Execution -stdin-:

:1:1: Fatal: Execution of node: YtFill! INSERT INTO arrtest (a, b[1:2][1:2], c, d, e, f, g) ^ -stdin-:

:1:1: Fatal: ERROR: invalid input syntax for type smallint: "{11,12,23}" INSERT INTO arrtest (a, b[1:2][1:2], c, d, e, f, g) ^ INSERT INTO arrtest (a, b[1:2], c, d[1:2]) VALUES ('{}', '{3,4}', '{foo,bar}', '{bar,foo}'); -stdin-:

: Fatal: Execution -stdin-:

:1:1: Fatal: Execution of node: YtFill! INSERT INTO arrtest (a, b[1:2], c, d[1:2]) ^ -stdin-:

:1:1: Fatal: ERROR: invalid input syntax for type smallint: "{}" INSERT INTO arrtest (a, b[1:2], c, d[1:2]) ^ INSERT INTO arrtest (b[2]) VALUES(now()); -- error, type mismatch -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: YtWriteTable! INSERT INTO arrtest (b[2]) VALUES(now()); -- error, type mismatch ^ -stdin-:

:1:1: Error: Failed to convert type: List> to List> INSERT INTO arrtest (b[2]) VALUES(now()); -- error, type mismatch ^ -stdin-:

:1:1: Error: Failed to convert 'b': pgtimestamptz to pgint4 INSERT INTO arrtest (b[2]) VALUES(now()); -- error, type mismatch ^ -stdin-:

:1:1: Error: Table "arrtest" row type differs from the written row type: Struct<-a:pgint2,b:pgint4!=pgtimestamptz,-c:pgname,-d:pgtext,-e:pgfloat8,-f:pgbpchar,-g:pgvarchar> INSERT INTO arrtest (b[2]) VALUES(now()); -- error, type mismatch ^ INSERT INTO arrtest (b[1:2]) VALUES(now()); -- error, type mismatch -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: YtWriteTable! INSERT INTO arrtest (b[1:2]) VALUES(now()); -- error, type mismatch ^ -stdin-:

:1:1: Error: Failed to convert type: List> to List> INSERT INTO arrtest (b[1:2]) VALUES(now()); -- error, type mismatch ^ -stdin-:

:1:1: Error: Failed to convert 'b': pgtimestamptz to pgint4 INSERT INTO arrtest (b[1:2]) VALUES(now()); -- error, type mismatch ^ -stdin-:

:1:1: Error: Table "arrtest" row type differs from the written row type: Struct<-a:pgint2,b:pgint4!=pgtimestamptz,-c:pgname,-d:pgtext,-e:pgfloat8,-f:pgbpchar,-g:pgvarchar> INSERT INTO arrtest (b[1:2]) VALUES(now()); -- error, type mismatch ^ SELECT * FROM arrtest; SELECT arrtest.a[1], arrtest.b[1][1][1], arrtest.c[1], arrtest.d[1][1], arrtest.e[0] FROM arrtest; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: alternative is not implemented yet : 360 SELECT arrtest.a[1], ^ SELECT a[1], b[1][1][1], c[1], d[1][1], e[0] FROM arrtest; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: alternative is not implemented yet : 360 SELECT a[1], b[1][1][1], c[1], d[1][1], e[0] ^ SELECT a[1:3], b[1:1][1:2][1:2], c[1:2], d[1:1][1:2] FROM arrtest; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: alternative is not implemented yet : 360 SELECT a[1:3], ^ SELECT array_ndims(a) AS a,array_ndims(b) AS b,array_ndims(c) AS c FROM arrtest; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem SELECT array_ndims(a) AS a,array_ndims(b) AS b,array_ndims(c) AS c ^ -stdin-:

:1:1: Error: At function: PgResultItem SELECT array_ndims(a) AS a,array_ndims(b) AS b,array_ndims(c) AS c ^ -stdin-:

:1:8: Error: At function: PgCall SELECT array_ndims(a) AS a,array_ndims(b) AS b,array_ndims(c) AS c ^ -stdin-:

:1:8: Error: Unable to find an overload for proc array_ndims with given argument types: (int2) SELECT array_ndims(a) AS a,array_ndims(b) AS b,array_ndims(c) AS c ^ -stdin-:

:1:1: Error: At function: PgResultItem SELECT array_ndims(a) AS a,array_ndims(b) AS b,array_ndims(c) AS c ^ -stdin-:

:1:28: Error: At function: PgCall SELECT array_ndims(a) AS a,array_ndims(b) AS b,array_ndims(c) AS c ^ -stdin-:

:1:28: Error: Unable to find an overload for proc array_ndims with given argument types: (int4) SELECT array_ndims(a) AS a,array_ndims(b) AS b,array_ndims(c) AS c ^ -stdin-:

:1:1: Error: At function: PgResultItem SELECT array_ndims(a) AS a,array_ndims(b) AS b,array_ndims(c) AS c ^ -stdin-:

:1:48: Error: At function: PgCall SELECT array_ndims(a) AS a,array_ndims(b) AS b,array_ndims(c) AS c ^ -stdin-:

:1:48: Error: Unable to find an overload for proc array_ndims with given argument types: (name) SELECT array_ndims(a) AS a,array_ndims(b) AS b,array_ndims(c) AS c ^ SELECT array_dims(a) AS a,array_dims(b) AS b,array_dims(c) AS c FROM arrtest; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem SELECT array_dims(a) AS a,array_dims(b) AS b,array_dims(c) AS c ^ -stdin-:

:1:1: Error: At function: PgResultItem SELECT array_dims(a) AS a,array_dims(b) AS b,array_dims(c) AS c ^ -stdin-:

:1:8: Error: At function: PgCall SELECT array_dims(a) AS a,array_dims(b) AS b,array_dims(c) AS c ^ -stdin-:

:1:8: Error: Unable to find an overload for proc array_dims with given argument types: (int2) SELECT array_dims(a) AS a,array_dims(b) AS b,array_dims(c) AS c ^ -stdin-:

:1:1: Error: At function: PgResultItem SELECT array_dims(a) AS a,array_dims(b) AS b,array_dims(c) AS c ^ -stdin-:

:1:27: Error: At function: PgCall SELECT array_dims(a) AS a,array_dims(b) AS b,array_dims(c) AS c ^ -stdin-:

:1:27: Error: Unable to find an overload for proc array_dims with given argument types: (int4) SELECT array_dims(a) AS a,array_dims(b) AS b,array_dims(c) AS c ^ -stdin-:

:1:1: Error: At function: PgResultItem SELECT array_dims(a) AS a,array_dims(b) AS b,array_dims(c) AS c ^ -stdin-:

:1:46: Error: At function: PgCall SELECT array_dims(a) AS a,array_dims(b) AS b,array_dims(c) AS c ^ -stdin-:

:1:46: Error: Unable to find an overload for proc array_dims with given argument types: (name) SELECT array_dims(a) AS a,array_dims(b) AS b,array_dims(c) AS c ^ -- returns nothing SELECT * FROM arrtest WHERE a[1] < 5 and c = '{"foobar"}'::_name; -stdin-:

: Error: Parse Sql -stdin-:

:4:15: Error: alternative is not implemented yet : 360 WHERE a[1] < 5 and ^ UPDATE arrtest SET a[1:2] = '{16,25}' WHERE NOT a = '{}'::_int2; -stdin-:

: Fatal: Pre type annotation -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: alternative is not implemented yet : 360 SELECT a[1:3], ^ SELECT b[1:1][2][2], d[1:1][2] FROM arrtest; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: alternative is not implemented yet : 360 SELECT b[1:1][2][2], ^ INSERT INTO arrtest(a) VALUES('{1,null,3}'); -stdin-:

: Fatal: Execution -stdin-:

:1:1: Fatal: Execution of node: YtFill! INSERT INTO arrtest(a) VALUES('{1,null,3}'); ^ -stdin-:

:1:1: Fatal: ERROR: invalid input syntax for type smallint: "{1,null,3}" INSERT INTO arrtest(a) VALUES('{1,null,3}'); ^ SELECT a FROM arrtest; UPDATE arrtest SET a[4] = NULL WHERE a[2] IS NULL; -stdin-:

: Error: Parse Sql -stdin-:

:1:43: Error: alternative is not implemented yet : 360 UPDATE arrtest SET a[4] = NULL WHERE a[2] IS NULL; ^ SELECT a FROM arrtest WHERE a[2] IS NULL; -stdin-:

: Error: Parse Sql -stdin-:

:1:34: Error: alternative is not implemented yet : 360 SELECT a FROM arrtest WHERE a[2] IS NULL; ^ DELETE FROM arrtest WHERE a[2] IS NULL AND b IS NULL; -stdin-:

: Error: Parse Sql -stdin-:

:1:32: Error: alternative is not implemented yet : 360 DELETE FROM arrtest WHERE a[2] IS NULL AND b IS NULL; ^ SELECT a,b,c FROM arrtest;

-- test mixed slice/scalar subscripting select '{{1,2,3},{4,5,6},{7,8,9}}'::int[];

select ('{{1,2,3},{4,5,6},{7,8,9}}'::int[])[1:2][2]; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: alternative is not implemented yet : 360 select ('{{1,2,3},{4,5,6},{7,8,9}}'::int[])[1:2][2]; ^ select '[0:2][0:2]={{1,2,3},{4,5,6},{7,8,9}}'::int[]; select ('[0:2][0:2]={{1,2,3},{4,5,6},{7,8,9}}'::int[])[1:2][2]; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: alternative is not implemented yet : 360 select ('[0:2][0:2]={{1,2,3},{4,5,6},{7,8,9}}'::int[])[1:2][2]; ^ -- -- check subscription corner cases -- -- More subscripts than MAXDIM (6) SELECT ('{}'::int[])[1][2][3][4][5][6][7]; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: alternative is not implemented yet : 360 -- ^ -- NULL index yields NULL when selecting SELECT ('{{{1},{2},{3}},{{4},{5},{6}}}'::int[])[1][NULL][1]; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: alternative is not implemented yet : 360 -- NULL index yields NULL when selecting ^ SELECT ('{{{1},{2},{3}},{{4},{5},{6}}}'::int[])[1][NULL:1][1]; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: alternative is not implemented yet : 360 SELECT ('{{{1},{2},{3}},{{4},{5},{6}}}'::int[])[1][NULL:1][1]; ^ SELECT ('{{{1},{2},{3}},{{4},{5},{6}}}'::int[])[1][1:NULL][1]; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: alternative is not implemented yet : 360 SELECT ('{{{1},{2},{3}},{{4},{5},{6}}}'::int[])[1][1:NULL][1]; ^ -- NULL index in assignment is an error UPDATE arrtest SET c[NULL] = '{"can''t assign"}' WHERE array_dims(c) is not null; -stdin-:

: Fatal: Pre type annotation -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: alternative is not implemented yet : 360 -- Un-subscriptable type ^ -- test slices with empty lower and/or upper index CREATE TEMP TABLE arrtest_s ( a int2[], b int2[][] ); INSERT INTO arrtest_s VALUES ('{1,2,3,4,5}', '{{1,2,3}, {4,5,6}, {7,8,9}}'); -stdin-:

: Fatal: Execution -stdin-:

:1:1: Fatal: Execution of node: YtFill! INSERT INTO arrtest_s VALUES ('{1,2,3,4,5}', '{{1,2,3}, {4,5,6}, {7,8,9}}'); ^ -stdin-:

:1:1: Fatal: ERROR: invalid input syntax for type smallint: "{1,2,3,4,5}" INSERT INTO arrtest_s VALUES ('{1,2,3,4,5}', '{{1,2,3}, {4,5,6}, {7,8,9}}'); ^ INSERT INTO arrtest_s VALUES ('[0:4]={1,2,3,4,5}', '[0:2][0:2]={{1,2,3}, {4,5,6}, {7,8,9}}'); -stdin-:

: Fatal: Execution -stdin-:

:1:1: Fatal: Execution of node: YtFill! INSERT INTO arrtest_s VALUES ('[0:4]={1,2,3,4,5}', '[0:2][0:2]={{1,2,3}, {4,5,6}, {7,8,9}}'); ^ -stdin-:

:1:1: Fatal: ERROR: invalid input syntax for type smallint: "[0:4]={1,2,3,4,5}" INSERT INTO arrtest_s VALUES ('[0:4]={1,2,3,4,5}', '[0:2][0:2]={{1,2,3}, {4,5,6}, {7,8,9}}'); ^ SELECT * FROM arrtest_s; SELECT a[:3], b[:2][:2] FROM arrtest_s; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: alternative is not implemented yet : 360 SELECT a[:3], b[:2][:2] FROM arrtest_s; ^ SELECT a[2:], b[2:][2:] FROM arrtest_s; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: alternative is not implemented yet : 360 SELECT a[2:], b[2:][2:] FROM arrtest_s; ^ SELECT a[:], b[:] FROM arrtest_s; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: alternative is not implemented yet : 360 SELECT a[:], b[:] FROM arrtest_s; ^ -- updates UPDATE arrtest_s SET a[:3] = '{11, 12, 13}', b[:2][:2] = '{{11,12}, {14,15}}' WHERE array_lower(a,1) = 1; -stdin-:

: Fatal: Pre type annotation -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: alternative is not implemented yet : 360 -- check with fixed-length-array type, such as point ^ SELECT f1[0:] FROM POINT_TBL; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: alternative is not implemented yet : 360 SELECT f1[0:] FROM POINT_TBL; ^ SELECT f1[:1] FROM POINT_TBL; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: alternative is not implemented yet : 360 SELECT f1[:1] FROM POINT_TBL; ^ SELECT f1[:] FROM POINT_TBL; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: alternative is not implemented yet : 360 SELECT f1[:] FROM POINT_TBL; ^ -- subscript assignments to fixed-width result in NULL if previous value is NULL UPDATE point_tbl SET f1[0] = 10 WHERE f1 IS NULL RETURNING *; -stdin-:

: Fatal: Pre type annotation -stdin-:

: Fatal: tools/enum_parser/enum_serialization_runtime/enum_runtime.cpp:70: Key 'returning' 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'. -- NULL assignments get ignored UPDATE point_tbl SET f1[0] = NULL WHERE f1::text = '(10,10)'::point::text RETURNING *; -stdin-:

: Fatal: Pre type annotation -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: YtWriteTable! insert into arrtest1 values(array[1,2,null,4], array['one','two',null,'four']); ^ -stdin-:

:1:1: Error: Failed to convert type: List> to List> insert into arrtest1 values(array[1,2,null,4], array['one','two',null,'four']); ^ -stdin-:

:1:1: Error: Failed to convert 'i': _pgint4 to pgint4 insert into arrtest1 values(array[1,2,null,4], array['one','two',null,'four']); ^ -stdin-:

:1:1: Error: Table "arrtest1" row type differs from the written row type: Struct insert into arrtest1 values(array[1,2,null,4], array['one','two',null,'four']); ^ select * from arrtest1; update arrtest1 set i[2] = 22, t[2] = 'twenty-two'; -stdin-:

: Fatal: Pre type annotation -stdin-:

: Fatal: tools/enum_parser/enum_serialization_runtime/enum_runtime.cpp:70: Key 'pg_delete' 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'. insert into arrtest1 values(array[1,2,null,4], array['one','two',null,'four']); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: YtWriteTable! insert into arrtest1 values(array[1,2,null,4], array['one','two',null,'four']); ^ -stdin-:

:1:1: Error: Failed to convert type: List> to List> insert into arrtest1 values(array[1,2,null,4], array['one','two',null,'four']); ^ -stdin-:

:1:1: Error: Failed to convert 'i': _pgint4 to pgint4 insert into arrtest1 values(array[1,2,null,4], array['one','two',null,'four']); ^ -stdin-:

: Fatal: Pre type annotation -stdin-:

-- -- array expressions and operators -- -- table creation and INSERTs CREATE TEMP TABLE arrtest2 (i integer ARRAY[4], f float8[], n numeric[], t text[], d timestamp[]);

INSERT INTO arrtest2 VALUES( ARRAY[[[113,142],[1,147]]], ARRAY[1.1,1.2,1.3]::float8[], ARRAY[1.1,1.2,1.3], ARRAY[[['aaa','aab'],['aba','abb'],['aca','acb']],[['baa','bab'],['bba','bbb'],['bca','bcb']]], ARRAY['19620326','19931223','19970117']::timestamp[] ); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: YtWriteTable! INSERT INTO arrtest2 VALUES( ^ -stdin-:

:1:1: Error: Failed to convert type: List> to List> INSERT INTO arrtest2 VALUES( ^ -stdin-:

:1:1: Error: Failed to convert 'd': _pgtimestamp to pgtimestamp INSERT INTO arrtest2 VALUES( ^ -stdin-:

:1:1: Error: Table "arrtest2" row type differs from the written row type: Struct INSERT INTO arrtest2 VALUES( ^ -- some more test data CREATE TEMP TABLE arrtest_f (f0 int, f1 text, f2 float8);

insert into arrtest_f values(1,'cat1',1.21);

insert into arrtest_f values(2,'cat1',1.24);

insert into arrtest_f values(3,'cat1',1.18);

insert into arrtest_f values(4,'cat1',1.26);

insert into arrtest_f values(5,'cat1',1.15);

insert into arrtest_f values(6,'cat2',1.15);

insert into arrtest_f values(7,'cat2',1.26);

insert into arrtest_f values(8,'cat2',1.32);

insert into arrtest_f values(9,'cat2',1.30);

CREATE TEMP TABLE arrtest_i (f0 int, f1 text, f2 int);

insert into arrtest_i values(1,'cat1',21);

insert into arrtest_i values(2,'cat1',24);

insert into arrtest_i values(3,'cat1',18);

insert into arrtest_i values(4,'cat1',26);

insert into arrtest_i values(5,'cat1',15);

insert into arrtest_i values(6,'cat2',15);

insert into arrtest_i values(7,'cat2',26);

insert into arrtest_i values(8,'cat2',32);

insert into arrtest_i values(9,'cat2',30);

-- expressions SELECT t.f[1][3][1] AS "131", t.f[2][2][1] AS "221" FROM ( SELECT ARRAY[[[111,112],[121,122],[131,132]],[[211,212],[221,122],[231,232]]] AS f ) AS t; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: alternative is not implemented yet : 360 -- expressions ^ SELECT ARRAY[[[[[['hello'],['world']]]]]];

SELECT ARRAY[ARRAY['hello'],ARRAY['world']];

SELECT ARRAY(select f2 from arrtest_f order by f2) AS "ARRAY";

-- with nulls SELECT '{1,null,3}'::int[];

SELECT ARRAY[1,NULL,3];

-- functions SELECT array_append(array[42], 6) AS "{42,6}"; -stdin-:

: Error: Type annotation -stdin-:

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

:2:8: Error: At function: PgCall SELECT array_append(array[42], 6) AS "{42,6}"; ^ -stdin-:

:2:8: Error: Unable to find an overload for proc array_append with given argument types: (_int4,int4) SELECT array_append(array[42], 6) AS "{42,6}"; ^ SELECT array_prepend(6, array[42]) AS "{6,42}"; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem SELECT array_prepend(6, array[42]) AS "{6,42}"; ^ -stdin-:

:1:8: Error: At function: PgCall SELECT array_prepend(6, array[42]) AS "{6,42}"; ^ -stdin-:

:1:8: Error: Unable to find an overload for proc array_prepend with given argument types: (int4,_int4) SELECT array_prepend(6, array[42]) AS "{6,42}"; ^ SELECT array_cat(ARRAY[1,2], ARRAY[3,4]) AS "{1,2,3,4}"; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem SELECT array_cat(ARRAY[1,2], ARRAY[3,4]) AS "{1,2,3,4}"; ^ -stdin-:

:1:8: Error: At function: PgCall SELECT array_cat(ARRAY[1,2], ARRAY[3,4]) AS "{1,2,3,4}"; ^ -stdin-:

:1:8: Error: Unable to find an overload for proc array_cat with given argument types: (_int4,_int4) SELECT array_cat(ARRAY[1,2], ARRAY[3,4]) AS "{1,2,3,4}"; ^ SELECT array_cat(ARRAY[1,2], ARRAY[[3,4],[5,6]]) AS "{{1,2},{3,4},{5,6}}"; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem SELECT array_cat(ARRAY[1,2], ARRAY[[3,4],[5,6]]) AS "{{1,2},{3,4},{5,6}}"; ^ -stdin-:

:1:8: Error: At function: PgCall SELECT array_cat(ARRAY[1,2], ARRAY[[3,4],[5,6]]) AS "{{1,2},{3,4},{5,6}}"; ^ -stdin-:

:1:8: Error: Unable to find an overload for proc array_cat with given argument types: (_int4,_int4) SELECT array_cat(ARRAY[1,2], ARRAY[[3,4],[5,6]]) AS "{{1,2},{3,4},{5,6}}"; ^ SELECT array_cat(ARRAY[[3,4],[5,6]], ARRAY[1,2]) AS "{{3,4},{5,6},{1,2}}"; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem SELECT array_cat(ARRAY[[3,4],[5,6]], ARRAY[1,2]) AS "{{3,4},{5,6},{1,2}}"; ^ -stdin-:

:1:8: Error: At function: PgCall SELECT array_cat(ARRAY[[3,4],[5,6]], ARRAY[1,2]) AS "{{3,4},{5,6},{1,2}}"; ^ -stdin-:

:1:8: Error: Unable to find an overload for proc array_cat with given argument types: (_int4,_int4) SELECT array_cat(ARRAY[[3,4],[5,6]], ARRAY[1,2]) AS "{{3,4},{5,6},{1,2}}"; ^ SELECT array_position(ARRAY[1,2,3,4,5], 4); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem SELECT array_position(ARRAY[1,2,3,4,5], 4); ^ -stdin-:

:1:8: Error: At function: PgCall SELECT array_position(ARRAY[1,2,3,4,5], 4); ^ -stdin-:

:1:8: Error: Unable to find an overload for proc array_position with given argument types: (_int4,int4) SELECT array_position(ARRAY[1,2,3,4,5], 4); ^ SELECT array_position(ARRAY[5,3,4,2,1], 4); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem SELECT array_position(ARRAY[5,3,4,2,1], 4); ^ -stdin-:

:1:8: Error: At function: PgCall SELECT array_position(ARRAY[5,3,4,2,1], 4); ^ -stdin-:

:1:8: Error: Unable to find an overload for proc array_position with given argument types: (_int4,int4) SELECT array_position(ARRAY[5,3,4,2,1], 4); ^ SELECT array_position(ARRAY[[1,2],[3,4]], 3); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem SELECT array_position(ARRAY[[1,2],[3,4]], 3); ^ -stdin-:

:1:8: Error: At function: PgCall SELECT array_position(ARRAY[[1,2],[3,4]], 3); ^ -stdin-:

:1:8: Error: Unable to find an overload for proc array_position with given argument types: (_int4,int4) SELECT array_position(ARRAY[[1,2],[3,4]], 3); ^ SELECT array_position(ARRAY['sun','mon','tue','wed','thu','fri','sat'], 'mon'); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem SELECT array_position(ARRAY['sun','mon','tue','wed','thu','fri','sat'], 'mon'); ^ -stdin-:

:1:8: Error: At function: PgCall SELECT array_position(ARRAY['sun','mon','tue','wed','thu','fri','sat'], 'mon'); ^ -stdin-:

:1:8: Error: Unable to find an overload for proc array_position with given argument types: (_text,unknown) SELECT array_position(ARRAY['sun','mon','tue','wed','thu','fri','sat'], 'mon'); ^ SELECT array_position(ARRAY['sun','mon','tue','wed','thu','fri','sat'], 'sat'); -stdin-:

: Error: Type annotation -stdin-:

:1:8: Error: At function: PgCall SELECT array_position(ARRAY['sun','mon','tue','wed','thu','fri','sat'], 'sat'); ^ -stdin-:

:1:8: Error: Unable to find an overload for proc array_position with given argument types: (_text,unknown) SELECT array_position(ARRAY['sun','mon','tue','wed','thu','fri','sat'], 'sat'); ^ SELECT array_position(ARRAY['sun','mon','tue','wed','thu','fri','sat'], NULL); -stdin-:

: Error: Type annotation -stdin-:

:1:8: Error: At function: PgCall SELECT array_position(ARRAY['sun','mon','tue','wed','thu','fri','sat'], NULL); ^ -stdin-:

:1:8: Error: Unable to find an overload for proc array_position with given argument types: (_text,unknown) SELECT array_position(ARRAY['sun','mon','tue','wed','thu','fri','sat'], NULL); ^ SELECT array_position(ARRAY['sun','mon','tue','wed','thu',NULL,'fri','sat'], NULL); -stdin-:

: Error: Type annotation -stdin-:

:1:8: Error: At function: PgCall SELECT array_position(ARRAY['sun','mon','tue','wed','thu',NULL,'fri','sat'], NULL); ^ -stdin-:

:1:8: Error: Unable to find an overload for proc array_position with given argument types: (_text,unknown) SELECT array_position(ARRAY['sun','mon','tue','wed','thu',NULL,'fri','sat'], NULL); ^ SELECT array_position(ARRAY['sun','mon','tue','wed','thu',NULL,'fri','sat'], 'sat'); -stdin-:

: Error: Type annotation -stdin-:

:1:8: Error: At function: PgCall SELECT array_position(ARRAY['sun','mon','tue','wed','thu',NULL,'fri','sat'], 'sat'); ^ -stdin-:

:1:8: Error: Unable to find an overload for proc array_position with given argument types: (_text,unknown) SELECT array_position(ARRAY['sun','mon','tue','wed','thu',NULL,'fri','sat'], 'sat'); ^ SELECT array_positions(NULL, 10); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem SELECT array_positions(NULL, 10); ^ -stdin-:

:1:8: Error: At function: PgCall SELECT array_positions(NULL, 10); ^ -stdin-:

:1:8: Error: Unable to find an overload for proc array_positions with given argument types: (unknown,int4) SELECT array_positions(NULL, 10); ^ SELECT array_positions(NULL, NULL::int); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem SELECT array_positions(NULL, NULL::int); ^ -stdin-:

:1:8: Error: At function: PgCall SELECT array_positions(NULL, NULL::int); ^ -stdin-:

:1:8: Error: Unable to find an overload for proc array_positions with given argument types: (unknown,int4) SELECT array_positions(NULL, NULL::int); ^ SELECT array_positions(ARRAY[1,2,3,4,5,6,1,2,3,4,5,6], 4); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem SELECT array_positions(ARRAY[1,2,3,4,5,6,1,2,3,4,5,6], 4); ^ -stdin-:

:1:8: Error: At function: PgCall SELECT array_positions(ARRAY[1,2,3,4,5,6,1,2,3,4,5,6], 4); ^ -stdin-:

:1:8: Error: Unable to find an overload for proc array_positions with given argument types: (_int4,int4) SELECT array_positions(ARRAY[1,2,3,4,5,6,1,2,3,4,5,6], 4); ^ SELECT array_positions(ARRAY[[1,2],[3,4]], 4); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem SELECT array_positions(ARRAY[[1,2],[3,4]], 4); ^ -stdin-:

:1:8: Error: At function: PgCall SELECT array_positions(ARRAY[[1,2],[3,4]], 4); ^ -stdin-:

:1:8: Error: Unable to find an overload for proc array_positions with given argument types: (_int4,int4) SELECT array_positions(ARRAY[[1,2],[3,4]], 4); ^ SELECT array_positions(ARRAY[1,2,3,4,5,6,1,2,3,4,5,6], NULL); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem SELECT array_positions(ARRAY[1,2,3,4,5,6,1,2,3,4,5,6], NULL); ^ -stdin-:

:1:8: Error: At function: PgCall SELECT array_positions(ARRAY[1,2,3,4,5,6,1,2,3,4,5,6], NULL); ^ -stdin-:

:1:8: Error: Unable to find an overload for proc array_positions with given argument types: (_int4,unknown) SELECT array_positions(ARRAY[1,2,3,4,5,6,1,2,3,4,5,6], NULL); ^ SELECT array_positions(ARRAY[1,2,3,NULL,5,6,1,2,3,NULL,5,6], NULL); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem SELECT array_positions(ARRAY[1,2,3,NULL,5,6,1,2,3,NULL,5,6], NULL); ^ -stdin-:

:1:8: Error: At function: PgCall SELECT array_positions(ARRAY[1,2,3,NULL,5,6,1,2,3,NULL,5,6], NULL); ^ -stdin-:

:1:8: Error: Unable to find an overload for proc array_positions with given argument types: (_int4,unknown) SELECT array_positions(ARRAY[1,2,3,NULL,5,6,1,2,3,NULL,5,6], NULL); ^ SELECT array_length(array_positions(ARRAY(SELECT 'AAAAAAAAAAAAAAAAAAAAAAAAA'::text || i % 10 FROM generate_series(1,100) g(i)), 'AAAAAAAAAAAAAAAAAAAAAAAAA5'), 1); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem SELECT array_length(array_positions(ARRAY(SELECT 'AAAAAAAAAAAAAAAAAAAAAAAAA'::text || i % 10 ^ -stdin-:

:1:8: Error: At function: PgCall SELECT array_length(array_positions(ARRAY(SELECT 'AAAAAAAAAAAAAAAAAAAAAAAAA'::text || i % 10 ^ -stdin-:

:1:21: Error: At function: PgCall SELECT array_length(array_positions(ARRAY(SELECT 'AAAAAAAAAAAAAAAAAAAAAAAAA'::text || i % 10 ^ -stdin-:

:1:37: Error: At function: PgSubLink, At function: PgSelect, At function: PgSetItem, At function: PgResultItem SELECT array_length(array_positions(ARRAY(SELECT 'AAAAAAAAAAAAAAAAAAAAAAAAA'::text || i % 10 ^ -stdin-:

:1:84: Error: At function: PgOp SELECT array_length(array_positions(ARRAY(SELECT 'AAAAAAAAAAAAAAAAAAAAAAAAA'::text || i % 10 ^ -stdin-:

:1:84: Error: Unable to find an overload for operator || with given argument type(s): (text,int4) SELECT array_length(array_positions(ARRAY(SELECT 'AAAAAAAAAAAAAAAAAAAAAAAAA'::text || i % 10 ^ DO $$ DECLARE o int; a int[] := ARRAY[1,2,3,2,3,1,2]; BEGIN o := array_position(a, 2); WHILE o IS NOT NULL LOOP RAISE NOTICE '%', o; o := array_position(a, 2, o + 1); END LOOP; END $$ LANGUAGE plpgsql; -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: RawStmt: alternative is not implemented yet : 263 DO $$ ^ SELECT array_position('[2:4]={1,2,3}'::int[], 1); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem SELECT array_position('[2:4]={1,2,3}'::int[], 1); ^ -stdin-:

:1:8: Error: At function: PgCall SELECT array_position('[2:4]={1,2,3}'::int[], 1); ^ -stdin-:

:1:8: Error: Unable to find an overload for proc array_position with given argument types: (_int4,int4) SELECT array_position('[2:4]={1,2,3}'::int[], 1); ^ SELECT array_positions('[2:4]={1,2,3}'::int[], 1); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem SELECT array_positions('[2:4]={1,2,3}'::int[], 1); ^ -stdin-:

:1:8: Error: At function: PgCall SELECT array_positions('[2:4]={1,2,3}'::int[], 1); ^ -stdin-:

:1:8: Error: Unable to find an overload for proc array_positions with given argument types: (_int4,int4) SELECT array_positions('[2:4]={1,2,3}'::int[], 1); ^ SELECT array_position(ids, (1, 1)), array_positions(ids, (1, 1)) FROM (VALUES (ARRAY[(0, 0), (1, 1)]), (ARRAY[(1, 1)]) ) AS f (ids); -stdin-:

: Error: Parse Sql -stdin-:

:6:6: Error: alternative is not implemented yet : 138 (ARRAY[(0, 0), (1, 1)]), ^ -stdin-:

:2:5: Error: alternative is not implemented yet : 138 array_position(ids, (1, 1)), ^ -- operators SELECT a FROM arrtest WHERE b = ARRAY[[[113,142],[1,147]]]; -stdin-:

: Error: Type annotation -stdin-:

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

: Error: At function: PgSetItem -stdin-:

:1:1: Error: At function: PgWhere -- operators ^ -stdin-:

:2:31: Error: At function: PgOp SELECT a FROM arrtest WHERE b = ARRAY[[[113,142],[1,147]]]; ^ -stdin-:

:2:31: Error: Unable to find an overload for operator = with given argument type(s): (int4,_int4) SELECT a FROM arrtest WHERE b = ARRAY[[[113,142],[1,147]]]; ^ SELECT NOT ARRAY[1.1,1.2,1.3] = ARRAY[1.1,1.2,1.3] AS "FALSE"; SELECT ARRAY[1,2] || 3 AS "{1,2,3}"; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem SELECT ARRAY[1,2] || 3 AS "{1,2,3}"; ^ -stdin-:

:1:19: Error: At function: PgOp SELECT ARRAY[1,2] || 3 AS "{1,2,3}"; ^ -stdin-:

:1:19: Error: Unable to find an overload for operator || with given argument type(s): (_int4,int4) SELECT ARRAY[1,2] || 3 AS "{1,2,3}"; ^ SELECT 0 || ARRAY[1,2] AS "{0,1,2}"; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem SELECT 0 || ARRAY[1,2] AS "{0,1,2}"; ^ -stdin-:

:1:10: Error: At function: PgOp SELECT 0 || ARRAY[1,2] AS "{0,1,2}"; ^ -stdin-:

:1:10: Error: Unable to find an overload for operator || with given argument type(s): (int4,_int4) SELECT 0 || ARRAY[1,2] AS "{0,1,2}"; ^ SELECT ARRAY[1,2] || ARRAY[3,4] AS "{1,2,3,4}"; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem SELECT ARRAY[1,2] || ARRAY[3,4] AS "{1,2,3,4}"; ^ -stdin-:

:1:19: Error: At function: PgOp SELECT ARRAY[1,2] || ARRAY[3,4] AS "{1,2,3,4}"; ^ -stdin-:

:1:19: Error: Unable to find an overload for operator || with given argument type(s): (_int4,_int4) SELECT ARRAY[1,2] || ARRAY[3,4] AS "{1,2,3,4}"; ^ SELECT ARRAY[[['hello','world']]] || ARRAY[[['happy','birthday']]] AS "ARRAY"; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem SELECT ARRAY[[['hello','world']]] || ARRAY[[['happy','birthday']]] AS "ARRAY"; ^ -stdin-:

:1:35: Error: At function: PgOp SELECT ARRAY[[['hello','world']]] || ARRAY[[['happy','birthday']]] AS "ARRAY"; ^ -stdin-:

:1:35: Error: Unable to find an overload for operator || with given argument type(s): (_text,_text) SELECT ARRAY[[['hello','world']]] || ARRAY[[['happy','birthday']]] AS "ARRAY"; ^ SELECT ARRAY[[1,2],[3,4]] || ARRAY[5,6] AS "{{1,2},{3,4},{5,6}}"; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem SELECT ARRAY[[1,2],[3,4]] || ARRAY[5,6] AS "{{1,2},{3,4},{5,6}}"; ^ -stdin-:

:1:27: Error: At function: PgOp SELECT ARRAY[[1,2],[3,4]] || ARRAY[5,6] AS "{{1,2},{3,4},{5,6}}"; ^ -stdin-:

:1:27: Error: Unable to find an overload for operator || with given argument type(s): (_int4,_int4) SELECT ARRAY[[1,2],[3,4]] || ARRAY[5,6] AS "{{1,2},{3,4},{5,6}}"; ^ SELECT ARRAY[0,0] || ARRAY[1,1] || ARRAY[2,2] AS "{0,0,1,1,2,2}"; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem SELECT ARRAY[0,0] || ARRAY[1,1] || ARRAY[2,2] AS "{0,0,1,1,2,2}"; ^ -stdin-:

:1:33: Error: At function: PgOp SELECT ARRAY[0,0] || ARRAY[1,1] || ARRAY[2,2] AS "{0,0,1,1,2,2}"; ^ -stdin-:

:1:19: Error: At function: PgOp SELECT ARRAY[0,0] || ARRAY[1,1] || ARRAY[2,2] AS "{0,0,1,1,2,2}"; ^ -stdin-:

:1:19: Error: Unable to find an overload for operator || with given argument type(s): (_int4,_int4) SELECT ARRAY[0,0] || ARRAY[1,1] || ARRAY[2,2] AS "{0,0,1,1,2,2}"; ^ SELECT 0 || ARRAY[1,2] || 3 AS "{0,1,2,3}"; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem SELECT 0 || ARRAY[1,2] || 3 AS "{0,1,2,3}"; ^ -stdin-:

:1:24: Error: At function: PgOp SELECT 0 || ARRAY[1,2] || 3 AS "{0,1,2,3}"; ^ -stdin-:

:1:10: Error: At function: PgOp SELECT 0 || ARRAY[1,2] || 3 AS "{0,1,2,3}"; ^ -stdin-:

:1:10: Error: Unable to find an overload for operator || with given argument type(s): (int4,_int4) SELECT 0 || ARRAY[1,2] || 3 AS "{0,1,2,3}"; ^ SELECT ARRAY[1.1] || ARRAY[2,3,4]; -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem SELECT ARRAY[1.1] || ARRAY[2,3,4]; ^ -stdin-:

:1:19: Error: At function: PgOp SELECT ARRAY[1.1] || ARRAY[2,3,4]; ^ -stdin-:

:1:19: Error: Unable to find an overload for operator || with given argument type(s): (_numeric,_int4) SELECT ARRAY[1.1] || ARRAY[2,3,4]; ^ SELECT array_agg(x) || array_agg(x) FROM (VALUES (ROW(1,2)), (ROW(3,4))) v(x); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: alternative is not implemented yet : 138 SELECT array_agg(x) || array_agg(x) FROM (VALUES (ROW(1,2)), (ROW(3,4))) v(x); ^ -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect SELECT array_agg(x) || array_agg(x) FROM (VALUES (ROW(1,2)), (ROW(3,4))) v(x); ^ -stdin-:

:1:1: Error: Recursive query does not have the form non-recursive-term UNION [ALL] recursive-term SELECT array_agg(x) || array_agg(x) FROM (VALUES (ROW(1,2)), (ROW(3,4))) v(x); ^ SELECT ROW(1,2) || array_agg(x) FROM (VALUES (ROW(3,4)), (ROW(5,6))) v(x); -stdin-:

: Error: Parse Sql -stdin-:

:1:1: Error: alternative is not implemented yet : 138 SELECT ROW(1,2) || array_agg(x) FROM (VALUES (ROW(3,4)), (ROW(5,6))) v(x); ^ -stdin-:

:1:17: Error: alternative is not implemented yet : 138 SELECT ROW(1,2) || array_agg(x) FROM (VALUES (ROW(3,4)), (ROW(5,6))) v(x); ^ SELECT * FROM array_op_test WHERE i @> '{32}' ORDER BY seqno; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.array_op_test SELECT * FROM array_op_test WHERE i && '{32}' ORDER BY seqno; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.array_op_test SELECT * FROM array_op_test WHERE i @> '{17}' ORDER BY seqno; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.array_op_test SELECT * FROM array_op_test WHERE i && '{17}' ORDER BY seqno; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.array_op_test SELECT * FROM array_op_test WHERE i @> '{32,17}' ORDER BY seqno; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.array_op_test SELECT * FROM array_op_test WHERE i && '{32,17}' ORDER BY seqno; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.array_op_test SELECT * FROM array_op_test WHERE i <@ '{38,34,32,89}' ORDER BY seqno; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.array_op_test SELECT * FROM array_op_test WHERE i = '{}' ORDER BY seqno; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.array_op_test SELECT * FROM array_op_test WHERE i @> '{}' ORDER BY seqno; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.array_op_test SELECT * FROM array_op_test WHERE i && '{}' ORDER BY seqno; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.array_op_test SELECT * FROM array_op_test WHERE i <@ '{}' ORDER BY seqno; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.array_op_test SELECT * FROM array_op_test WHERE i = '{NULL}' ORDER BY seqno; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.array_op_test SELECT * FROM array_op_test WHERE i @> '{NULL}' ORDER BY seqno; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.array_op_test SELECT * FROM array_op_test WHERE i && '{NULL}' ORDER BY seqno; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.array_op_test SELECT * FROM array_op_test WHERE i <@ '{NULL}' ORDER BY seqno; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.array_op_test SELECT * FROM array_op_test WHERE t @> '{AAAAAAAA72908}' ORDER BY seqno; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.array_op_test SELECT * FROM array_op_test WHERE t && '{AAAAAAAA72908}' ORDER BY seqno; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.array_op_test SELECT * FROM array_op_test WHERE t @> '{AAAAAAAAAA646}' ORDER BY seqno; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.array_op_test SELECT * FROM array_op_test WHERE t && '{AAAAAAAAAA646}' ORDER BY seqno; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.array_op_test SELECT * FROM array_op_test WHERE t @> '{AAAAAAAA72908,AAAAAAAAAA646}' ORDER BY seqno; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.array_op_test SELECT * FROM array_op_test WHERE t && '{AAAAAAAA72908,AAAAAAAAAA646}' ORDER BY seqno; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.array_op_test SELECT * FROM array_op_test WHERE t <@ '{AAAAAAAA72908,AAAAAAAAAAAAAAAAAAA17075,AA88409,AAAAAAAAAAAAAAAAAA36842,AAAAAAA48038,AAAAAAAAAAAAAA10611}' ORDER BY seqno; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.array_op_test SELECT * FROM array_op_test WHERE t = '{}' ORDER BY seqno; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.array_op_test SELECT * FROM array_op_test WHERE t @> '{}' ORDER BY seqno; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.array_op_test SELECT * FROM array_op_test WHERE t && '{}' ORDER BY seqno; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.array_op_test SELECT * FROM array_op_test WHERE t <@ '{}' ORDER BY seqno; -stdin-:

: Fatal: Table metadata loading -stdin-:

: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.array_op_test -- array casts SELECT ARRAY[1,2,3]::text[]::int[]::float8[] AS "{1,2,3}";

SELECT pg_typeof(ARRAY[1,2,3]::text[]::int[]::float8[]) AS "double precision[]";

SELECT ARRAY[['a','bc'],['def','hijk']]::text[]::varchar[] AS "{{a,bc},{def,hijk}}";

SELECT pg_typeof(ARRAY[['a','bc'],['def','hijk']]::text[]::varchar[]) AS "character varying[]";

SELECT CAST(ARRAY[[[[[['a','bb','ccc']]]]]] as text[]) as "{{{{{{a,bb,ccc}}}}}}";

SELECT NULL::text[]::int[] AS "NULL";

-- scalar op any/all (array) select 33 = any ('{1,2,3}');

select 33 = any ('{1,2,33}');

select 33 = all ('{1,2,33}');

select 33 >= all ('{1,2,33}');

-- boundary cases select null::int >= all ('{1,2,33}');

select null::int >= all ('{}');

select null::int >= any ('{}');

-- cross-datatype select 33.4 = any (array[1,2,3]);

select 33.4 > all (array[1,2,3]);

-- errors select 33 * any ('{1,2,3}'); -stdin-:

: Error: Type annotation -stdin-:

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

:2:11: Error: At function: PgAnyResolvedOp select 33 * any ('{1,2,3}'); ^ -stdin-:

:2:11: Error: Expected boolean operator result, but got: int4 select 33 * any ('{1,2,3}'); ^ select 33 * any (44); -stdin-:

: Error: Type annotation -stdin-:

:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem select 33 * any (44); ^ -stdin-:

:1:11: Error: At function: PgAnyOp select 33 * any (44); ^ -stdin-:

:1:11: Error: ydb/library/yql/parser/pg_catalog/catalog.cpp:2143: Condition violated: `fromTypePtr' select 33 * any (44); ^ -- nulls select 33 = any (null::int[]);

select null::int = any ('{1,2,3}');

select 33 = any ('{1,null,3}');

select 33 = any ('{1,null,33}');

select 33 = all (null::int[]);

select null::int = all ('{1,2,3}');

select 33 = all ('{1,null,3}');

select 33 = all ('{33,null,33}');

-- nulls later in the bitmap SELECT -1 != ALL(ARRAY(SELECT NULLIF(g.i, 900) FROM generate_series(1,1000) g(i)));

-- test indexes on arrays create temp table arr_tbl (f1 int[] unique);

insert into arr_tbl values ('{1,2,3}'); -stdin-:

: Fatal: Execution -stdin-:

:1:1: Fatal: Execution of node: YtFill! insert into arr_tbl values ('{1,2,3}'); ^ -stdin-:

:1:1: Fatal: ERROR: invalid input syntax for type integer: "{1,2,3}" insert into arr_tbl values ('{1,2,3}'); ^ insert into arr_tbl values ('{1,2}'); -stdin-:

: Fatal: Execution -stdin-:

:1:1: Fatal: Execution of node: YtFill! insert into arr_tbl values ('{1,2}'); ^ -stdin-:

:1:1: Fatal: ERROR: invalid input syntax for type integer: "{1,2}" insert into arr_tbl values ('{1,2}'); ^ -- failure expected: insert into arr_tbl values ('{1,2,3}'); -stdin-:

: Fatal: Execution -stdin-:

:1:1: Fatal: Execution of node: YtFill! -- failure expected: ^ -stdin-: