Registering pre-existing tables onek tenk1 stud_emp -- -- ALTER_TABLE -- -- Clean up in case a prior regression run failed SET client_min_messages TO 'warning'; DROP ROLE IF EXISTS regress_alter_table_user1; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 287 DROP ROLE IF EXISTS regress_alter_table_user1; ^ RESET client_min_messages; CREATE USER regress_alter_table_user1; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 285 CREATE USER regress_alter_table_user1; ^ -- -- add attribute -- CREATE TABLE attmp (initial int4); COMMENT ON TABLE attmp_wrong IS 'table comment'; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 258 COMMENT ON TABLE attmp_wrong IS 'table comment'; ^ COMMENT ON TABLE attmp IS 'table comment'; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 258 COMMENT ON TABLE attmp IS 'table comment'; ^ COMMENT ON TABLE attmp IS NULL; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 258 COMMENT ON TABLE attmp IS NULL; ^ ALTER TABLE attmp ADD COLUMN xmin integer; -- fails -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN xmin integer; -- fails ^ ALTER TABLE attmp ADD COLUMN a int4 default 3; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN a int4 default 3; ^ ALTER TABLE attmp ADD COLUMN b name; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN b name; ^ ALTER TABLE attmp ADD COLUMN c text; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN c text; ^ ALTER TABLE attmp ADD COLUMN d float8; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN d float8; ^ ALTER TABLE attmp ADD COLUMN e float4; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN e float4; ^ ALTER TABLE attmp ADD COLUMN f int2; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN f int2; ^ ALTER TABLE attmp ADD COLUMN g polygon; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN g polygon; ^ ALTER TABLE attmp ADD COLUMN i char; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN i char; ^ ALTER TABLE attmp ADD COLUMN k int4; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN k int4; ^ ALTER TABLE attmp ADD COLUMN l tid; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN l tid; ^ ALTER TABLE attmp ADD COLUMN m xid; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN m xid; ^ ALTER TABLE attmp ADD COLUMN n oidvector; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN n oidvector; ^ --ALTER TABLE attmp ADD COLUMN o lock; ALTER TABLE attmp ADD COLUMN p boolean; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 --ALTER TABLE attmp ADD COLUMN o lock; ^ ALTER TABLE attmp ADD COLUMN q point; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN q point; ^ ALTER TABLE attmp ADD COLUMN r lseg; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN r lseg; ^ ALTER TABLE attmp ADD COLUMN s path; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN s path; ^ ALTER TABLE attmp ADD COLUMN t box; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN t box; ^ ALTER TABLE attmp ADD COLUMN v timestamp; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN v timestamp; ^ ALTER TABLE attmp ADD COLUMN w interval; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN w interval; ^ ALTER TABLE attmp ADD COLUMN x float8[]; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN x float8[]; ^ ALTER TABLE attmp ADD COLUMN y float4[]; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN y float4[]; ^ ALTER TABLE attmp ADD COLUMN z int2[]; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN z int2[]; ^ INSERT INTO attmp (a, b, c, d, e, f, g, i, k, l, m, n, p, q, r, s, t, v, w, x, y, z) VALUES (4, 'name', 'text', 4.1, 4.1, 2, '(4.1,4.1,3.1,3.1)', 'c', 314159, '(1,1)', '512', '1 2 3 4 5 6 7 8', true, '(1.1,1.1)', '(4.1,4.1,3.1,3.1)', '(0,2,4.1,4.1,3.1,3.1)', '(4.1,4.1,3.1,3.1)', 'epoch', '01:00:10', '{1.0,2.0,3.0,4.0}', '{1.0,2.0,3.0,4.0}', '{1,2,3,4}'); SELECT * FROM attmp; DROP TABLE attmp; -- the wolf bug - schema mods caused inconsistent row descriptors CREATE TABLE attmp ( initial int4 ); ALTER TABLE attmp ADD COLUMN a int4; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN a int4; ^ ALTER TABLE attmp ADD COLUMN b name; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN b name; ^ ALTER TABLE attmp ADD COLUMN c text; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN c text; ^ ALTER TABLE attmp ADD COLUMN d float8; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN d float8; ^ ALTER TABLE attmp ADD COLUMN e float4; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN e float4; ^ ALTER TABLE attmp ADD COLUMN f int2; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN f int2; ^ ALTER TABLE attmp ADD COLUMN g polygon; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN g polygon; ^ ALTER TABLE attmp ADD COLUMN i char; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN i char; ^ ALTER TABLE attmp ADD COLUMN k int4; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN k int4; ^ ALTER TABLE attmp ADD COLUMN l tid; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN l tid; ^ ALTER TABLE attmp ADD COLUMN m xid; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN m xid; ^ ALTER TABLE attmp ADD COLUMN n oidvector; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN n oidvector; ^ --ALTER TABLE attmp ADD COLUMN o lock; ALTER TABLE attmp ADD COLUMN p boolean; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 --ALTER TABLE attmp ADD COLUMN o lock; ^ ALTER TABLE attmp ADD COLUMN q point; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN q point; ^ ALTER TABLE attmp ADD COLUMN r lseg; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN r lseg; ^ ALTER TABLE attmp ADD COLUMN s path; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN s path; ^ ALTER TABLE attmp ADD COLUMN t box; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN t box; ^ ALTER TABLE attmp ADD COLUMN v timestamp; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN v timestamp; ^ ALTER TABLE attmp ADD COLUMN w interval; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN w interval; ^ ALTER TABLE attmp ADD COLUMN x float8[]; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN x float8[]; ^ ALTER TABLE attmp ADD COLUMN y float4[]; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN y float4[]; ^ ALTER TABLE attmp ADD COLUMN z int2[]; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp ADD COLUMN z int2[]; ^ INSERT INTO attmp (a, b, c, d, e, f, g, i, k, l, m, n, p, q, r, s, t, v, w, x, y, z) VALUES (4, 'name', 'text', 4.1, 4.1, 2, '(4.1,4.1,3.1,3.1)', 'c', 314159, '(1,1)', '512', '1 2 3 4 5 6 7 8', true, '(1.1,1.1)', '(4.1,4.1,3.1,3.1)', '(0,2,4.1,4.1,3.1,3.1)', '(4.1,4.1,3.1,3.1)', 'epoch', '01:00:10', '{1.0,2.0,3.0,4.0}', '{1.0,2.0,3.0,4.0}', '{1,2,3,4}'); SELECT * FROM attmp; CREATE INDEX attmp_idx ON attmp (a, (d + e), b); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: index expression is not supported yet CREATE INDEX attmp_idx ON attmp (a, (d + e), b); ^ ALTER INDEX attmp_idx ALTER COLUMN 0 SET STATISTICS 1000; -stdin-:
: Error: Parse Sql -stdin-:
:1:37: Error: ERROR: column number must be in range from 1 to 32767 ALTER INDEX attmp_idx ALTER COLUMN 0 SET STATISTICS 1000; ^ ALTER INDEX attmp_idx ALTER COLUMN 1 SET STATISTICS 1000; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER INDEX attmp_idx ALTER COLUMN 1 SET STATISTICS 1000; ^ ALTER INDEX attmp_idx ALTER COLUMN 2 SET STATISTICS 1000; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER INDEX attmp_idx ALTER COLUMN 2 SET STATISTICS 1000; ^ \d+ attmp_idx Metacommand \d+ attmp_idx is not supported ALTER INDEX attmp_idx ALTER COLUMN 3 SET STATISTICS 1000; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER INDEX attmp_idx ALTER COLUMN 3 SET STATISTICS 1000; ^ ALTER INDEX attmp_idx ALTER COLUMN 4 SET STATISTICS 1000; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER INDEX attmp_idx ALTER COLUMN 4 SET STATISTICS 1000; ^ ALTER INDEX attmp_idx ALTER COLUMN 2 SET STATISTICS -1; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER INDEX attmp_idx ALTER COLUMN 2 SET STATISTICS -1; ^ DROP TABLE attmp; -- fails with incorrect object type CREATE VIEW at_v1 AS SELECT 1 as a; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: expected at least one target column -- fails with incorrect object type ^ ALTER TABLE at_v1 ALTER COLUMN a SET STATISTICS 0; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE at_v1 ALTER COLUMN a SET STATISTICS 0; ^ DROP VIEW at_v1; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: View not found: 'at_v1' DROP VIEW at_v1; ^ -- -- rename - check on both non-temp and temp tables -- CREATE TABLE attmp (regtable int); CREATE TEMP TABLE attmp (attmptable int); ALTER TABLE attmp RENAME TO attmp_new; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER TABLE attmp RENAME TO attmp_new; ^ SELECT * FROM attmp; SELECT * FROM attmp_new; -stdin-:
: Fatal: Table metadata loading -stdin-:
: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.attmp_new ALTER TABLE attmp RENAME TO attmp_new2; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER TABLE attmp RENAME TO attmp_new2; ^ SELECT * FROM attmp; -- should fail SELECT * FROM attmp_new; -stdin-:
: Fatal: Table metadata loading -stdin-:
: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.attmp_new SELECT * FROM attmp_new2; -stdin-:
: Fatal: Table metadata loading -stdin-:
: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.attmp_new2 DROP TABLE attmp_new; DROP TABLE attmp_new2; -- check rename of partitioned tables and indexes also CREATE TABLE part_attmp (a int primary key) partition by range (a); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: PARTITION BY clause not supported -- check rename of partitioned tables and indexes also ^ CREATE TABLE part_attmp1 PARTITION OF part_attmp FOR VALUES FROM (0) TO (100); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: table inheritance not supported CREATE TABLE part_attmp1 PARTITION OF part_attmp FOR VALUES FROM (0) TO (100); ^ ALTER INDEX part_attmp_pkey RENAME TO part_attmp_index; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER INDEX part_attmp_pkey RENAME TO part_attmp_index; ^ ALTER INDEX part_attmp1_pkey RENAME TO part_attmp1_index; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER INDEX part_attmp1_pkey RENAME TO part_attmp1_index; ^ ALTER TABLE part_attmp RENAME TO part_at2tmp; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER TABLE part_attmp RENAME TO part_at2tmp; ^ ALTER TABLE part_attmp1 RENAME TO part_at2tmp1; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER TABLE part_attmp1 RENAME TO part_at2tmp1; ^ SET ROLE regress_alter_table_user1; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: VariableSetStmt, not supported name: role SET ROLE regress_alter_table_user1; ^ ALTER INDEX part_attmp_index RENAME TO fail; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER INDEX part_attmp_index RENAME TO fail; ^ ALTER INDEX part_attmp1_index RENAME TO fail; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER INDEX part_attmp1_index RENAME TO fail; ^ ALTER TABLE part_at2tmp RENAME TO fail; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER TABLE part_at2tmp RENAME TO fail; ^ ALTER TABLE part_at2tmp1 RENAME TO fail; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER TABLE part_at2tmp1 RENAME TO fail; ^ RESET ROLE; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: VariableSetStmt, not supported kind: 4 RESET ROLE; ^ DROP TABLE part_at2tmp; -- -- check renaming to a table's array type's autogenerated name -- (the array type's name should get out of the way) -- CREATE TABLE attmp_array (id int); CREATE TABLE attmp_array2 (id int); SELECT typname FROM pg_type WHERE oid = 'attmp_array[]'::regtype; -stdin-:
: Fatal: Execution -stdin-:
:1:1: Fatal: Execution of node: Result SELECT typname FROM pg_type WHERE oid = 'attmp_array[]'::regtype; ^ -stdin-:
:1:1: Fatal: ERROR: type "attmp_array[]" does not exist SELECT typname FROM pg_type WHERE oid = 'attmp_array[]'::regtype; ^ SELECT typname FROM pg_type WHERE oid = 'attmp_array2[]'::regtype; -stdin-:
: Fatal: Execution -stdin-:
:1:1: Fatal: Execution of node: Result SELECT typname FROM pg_type WHERE oid = 'attmp_array2[]'::regtype; ^ -stdin-:
:1:1: Fatal: ERROR: type "attmp_array2[]" does not exist SELECT typname FROM pg_type WHERE oid = 'attmp_array2[]'::regtype; ^ ALTER TABLE attmp_array2 RENAME TO _attmp_array; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER TABLE attmp_array2 RENAME TO _attmp_array; ^ SELECT typname FROM pg_type WHERE oid = 'attmp_array[]'::regtype; -stdin-:
: Fatal: Execution -stdin-:
:1:1: Fatal: Execution of node: Result SELECT typname FROM pg_type WHERE oid = 'attmp_array[]'::regtype; ^ -stdin-:
:1:1: Fatal: ERROR: type "attmp_array[]" does not exist SELECT typname FROM pg_type WHERE oid = 'attmp_array[]'::regtype; ^ SELECT typname FROM pg_type WHERE oid = '_attmp_array[]'::regtype; -stdin-:
: Fatal: Execution -stdin-:
:1:1: Fatal: Execution of node: Result SELECT typname FROM pg_type WHERE oid = '_attmp_array[]'::regtype; ^ -stdin-:
:1:1: Fatal: ERROR: type "_attmp_array[]" does not exist SELECT typname FROM pg_type WHERE oid = '_attmp_array[]'::regtype; ^ DROP TABLE _attmp_array; DROP TABLE attmp_array; -- renaming to table's own array type's name is an interesting corner case CREATE TABLE attmp_array (id int); SELECT typname FROM pg_type WHERE oid = 'attmp_array[]'::regtype; -stdin-:
: Fatal: Execution -stdin-:
:1:1: Fatal: Execution of node: Result SELECT typname FROM pg_type WHERE oid = 'attmp_array[]'::regtype; ^ -stdin-:
:1:1: Fatal: ERROR: type "attmp_array[]" does not exist SELECT typname FROM pg_type WHERE oid = 'attmp_array[]'::regtype; ^ ALTER TABLE attmp_array RENAME TO _attmp_array; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER TABLE attmp_array RENAME TO _attmp_array; ^ SELECT typname FROM pg_type WHERE oid = '_attmp_array[]'::regtype; -stdin-:
: Fatal: Execution -stdin-:
:1:1: Fatal: Execution of node: Result SELECT typname FROM pg_type WHERE oid = '_attmp_array[]'::regtype; ^ -stdin-:
:1:1: Fatal: ERROR: type "_attmp_array[]" does not exist SELECT typname FROM pg_type WHERE oid = '_attmp_array[]'::regtype; ^ DROP TABLE _attmp_array; -- ALTER TABLE ... RENAME on non-table relations -- renaming indexes (FIXME: this should probably test the index's functionality) ALTER INDEX IF EXISTS __onek_unique1 RENAME TO attmp_onek_unique1; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 -- ALTER TABLE ... RENAME on non-table relations ^ ALTER INDEX IF EXISTS __attmp_onek_unique1 RENAME TO onek_unique1; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER INDEX IF EXISTS __attmp_onek_unique1 RENAME TO onek_unique1; ^ ALTER INDEX onek_unique1 RENAME TO attmp_onek_unique1; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER INDEX onek_unique1 RENAME TO attmp_onek_unique1; ^ ALTER INDEX attmp_onek_unique1 RENAME TO onek_unique1; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER INDEX attmp_onek_unique1 RENAME TO onek_unique1; ^ SET ROLE regress_alter_table_user1; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: VariableSetStmt, not supported name: role SET ROLE regress_alter_table_user1; ^ ALTER INDEX onek_unique1 RENAME TO fail; -- permission denied -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER INDEX onek_unique1 RENAME TO fail; -- permission denied ^ RESET ROLE; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: VariableSetStmt, not supported kind: 4 RESET ROLE; ^ -- rename statements with mismatching statement and object types CREATE TABLE alter_idx_rename_test (a INT); CREATE INDEX alter_idx_rename_test_idx ON alter_idx_rename_test (a); CREATE TABLE alter_idx_rename_test_parted (a INT) PARTITION BY LIST (a); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: PARTITION BY clause not supported CREATE TABLE alter_idx_rename_test_parted (a INT) PARTITION BY LIST (a); ^ CREATE INDEX alter_idx_rename_test_parted_idx ON alter_idx_rename_test_parted (a); BEGIN; ALTER INDEX alter_idx_rename_test RENAME TO alter_idx_rename_test_2; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER INDEX alter_idx_rename_test RENAME TO alter_idx_rename_test_2; ^ ALTER INDEX alter_idx_rename_test_parted RENAME TO alter_idx_rename_test_parted_2; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER INDEX alter_idx_rename_test_parted RENAME TO alter_idx_rename_test_parted_2; ^ SELECT relation::regclass, mode FROM pg_locks WHERE pid = pg_backend_pid() AND locktype = 'relation' AND relation::regclass::text LIKE 'alter\_idx%' ORDER BY relation::regclass::text COLLATE "C"; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 365 SELECT relation::regclass, mode FROM pg_locks ^ COMMIT; BEGIN; ALTER INDEX alter_idx_rename_test_idx RENAME TO alter_idx_rename_test_idx_2; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER INDEX alter_idx_rename_test_idx RENAME TO alter_idx_rename_test_idx_2; ^ ALTER INDEX alter_idx_rename_test_parted_idx RENAME TO alter_idx_rename_test_parted_idx_2; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER INDEX alter_idx_rename_test_parted_idx RENAME TO alter_idx_rename_test_parted_idx_2; ^ SELECT relation::regclass, mode FROM pg_locks WHERE pid = pg_backend_pid() AND locktype = 'relation' AND relation::regclass::text LIKE 'alter\_idx%' ORDER BY relation::regclass::text COLLATE "C"; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 365 SELECT relation::regclass, mode FROM pg_locks ^ COMMIT; BEGIN; ALTER TABLE alter_idx_rename_test_idx_2 RENAME TO alter_idx_rename_test_idx_3; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER TABLE alter_idx_rename_test_idx_2 RENAME TO alter_idx_rename_test_idx_3; ^ ALTER TABLE alter_idx_rename_test_parted_idx_2 RENAME TO alter_idx_rename_test_parted_idx_3; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER TABLE alter_idx_rename_test_parted_idx_2 RENAME TO alter_idx_rename_test_parted_idx_3; ^ SELECT relation::regclass, mode FROM pg_locks WHERE pid = pg_backend_pid() AND locktype = 'relation' AND relation::regclass::text LIKE 'alter\_idx%' ORDER BY relation::regclass::text COLLATE "C"; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 365 SELECT relation::regclass, mode FROM pg_locks ^ COMMIT; DROP TABLE alter_idx_rename_test_2; -- renaming views CREATE VIEW attmp_view (unique1) AS SELECT unique1 FROM tenk1; -stdin-:
: Error: Parse Sql -stdin-:
: Error: Not all views have been dropped ALTER TABLE attmp_view RENAME TO attmp_view_new; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER TABLE attmp_view RENAME TO attmp_view_new; ^ SET ROLE regress_alter_table_user1; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: VariableSetStmt, not supported name: role SET ROLE regress_alter_table_user1; ^ ALTER VIEW attmp_view_new RENAME TO fail; -- permission denied -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER VIEW attmp_view_new RENAME TO fail; -- permission denied ^ RESET ROLE; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: VariableSetStmt, not supported kind: 4 RESET ROLE; ^ -- hack to ensure we get an indexscan here set enable_seqscan to off; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: VariableSetStmt, not supported name: enable_seqscan -- hack to ensure we get an indexscan here ^ set enable_bitmapscan to off; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: VariableSetStmt, not supported name: enable_bitmapscan set enable_bitmapscan to off; ^ -- 5 values, sorted SELECT unique1 FROM tenk1 WHERE unique1 < 5; 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; ^ DROP VIEW attmp_view_new; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: View not found: 'attmp_view_new' DROP VIEW attmp_view_new; ^ -- toast-like relation name alter table stud_emp rename to pg_toast_stud_emp; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 -- toast-like relation name ^ alter table pg_toast_stud_emp rename to stud_emp; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 alter table pg_toast_stud_emp rename to stud_emp; ^ -- renaming index should rename constraint as well ALTER TABLE onek ADD CONSTRAINT onek_unique1_constraint UNIQUE (unique1); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- renaming index should rename constraint as well ^ ALTER INDEX onek_unique1_constraint RENAME TO onek_unique1_constraint_foo; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER INDEX onek_unique1_constraint RENAME TO onek_unique1_constraint_foo; ^ ALTER TABLE onek DROP CONSTRAINT onek_unique1_constraint_foo; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE onek DROP CONSTRAINT onek_unique1_constraint_foo; ^ -- renaming constraint ALTER TABLE onek ADD CONSTRAINT onek_check_constraint CHECK (unique1 >= 0); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- renaming constraint ^ ALTER TABLE onek RENAME CONSTRAINT onek_check_constraint TO onek_check_constraint_foo; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER TABLE onek RENAME CONSTRAINT onek_check_constraint TO onek_check_constraint_foo; ^ ALTER TABLE onek DROP CONSTRAINT onek_check_constraint_foo; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE onek DROP CONSTRAINT onek_check_constraint_foo; ^ -- renaming constraint should rename index as well ALTER TABLE onek ADD CONSTRAINT onek_unique1_constraint UNIQUE (unique1); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- renaming constraint should rename index as well ^ DROP INDEX onek_unique1_constraint; -- to see whether it's there -stdin-:
: Error: Pre type annotation -stdin-:
:1:1: Error: Unexpected tag: pgObject DROP INDEX onek_unique1_constraint; -- to see whether it's there ^ ALTER TABLE onek RENAME CONSTRAINT onek_unique1_constraint TO onek_unique1_constraint_foo; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER TABLE onek RENAME CONSTRAINT onek_unique1_constraint TO onek_unique1_constraint_foo; ^ DROP INDEX onek_unique1_constraint_foo; -- to see whether it's there -stdin-:
: Error: Pre type annotation -stdin-:
:1:1: Error: Unexpected tag: pgObject DROP INDEX onek_unique1_constraint_foo; -- to see whether it's there ^ ALTER TABLE onek DROP CONSTRAINT onek_unique1_constraint_foo; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE onek DROP CONSTRAINT onek_unique1_constraint_foo; ^ -- renaming constraints vs. inheritance CREATE TABLE constraint_rename_test (a int CONSTRAINT con1 CHECK (a > 0), b int, c int); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: column constraint not supported -- renaming constraints vs. inheritance ^ \d constraint_rename_test Metacommand \d constraint_rename_test is not supported CREATE TABLE constraint_rename_test2 (a int CONSTRAINT con1 CHECK (a > 0), d int) INHERITS (constraint_rename_test); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: table inheritance not supported CREATE TABLE constraint_rename_test2 (a int CONSTRAINT con1 CHECK (a > 0), d int) INHERITS (constraint_rename_test); ^ \d constraint_rename_test2 Metacommand \d constraint_rename_test2 is not supported ALTER TABLE constraint_rename_test2 RENAME CONSTRAINT con1 TO con1foo; -- fail -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER TABLE constraint_rename_test2 RENAME CONSTRAINT con1 TO con1foo; -- fail ^ ALTER TABLE ONLY constraint_rename_test RENAME CONSTRAINT con1 TO con1foo; -- fail -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER TABLE ONLY constraint_rename_test RENAME CONSTRAINT con1 TO con1foo; -- fail ^ ALTER TABLE constraint_rename_test RENAME CONSTRAINT con1 TO con1foo; -- ok -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER TABLE constraint_rename_test RENAME CONSTRAINT con1 TO con1foo; -- ok ^ \d constraint_rename_test Metacommand \d constraint_rename_test is not supported \d constraint_rename_test2 Metacommand \d constraint_rename_test2 is not supported ALTER TABLE constraint_rename_test ADD CONSTRAINT con2 CHECK (b > 0) NO INHERIT; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE constraint_rename_test ADD CONSTRAINT con2 CHECK (b > 0) NO INHERIT; ^ ALTER TABLE ONLY constraint_rename_test RENAME CONSTRAINT con2 TO con2foo; -- ok -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER TABLE ONLY constraint_rename_test RENAME CONSTRAINT con2 TO con2foo; -- ok ^ ALTER TABLE constraint_rename_test RENAME CONSTRAINT con2foo TO con2bar; -- ok -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER TABLE constraint_rename_test RENAME CONSTRAINT con2foo TO con2bar; -- ok ^ \d constraint_rename_test Metacommand \d constraint_rename_test is not supported \d constraint_rename_test2 Metacommand \d constraint_rename_test2 is not supported ALTER TABLE constraint_rename_test ADD CONSTRAINT con3 PRIMARY KEY (a); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE constraint_rename_test ADD CONSTRAINT con3 PRIMARY KEY (a); ^ ALTER TABLE constraint_rename_test RENAME CONSTRAINT con3 TO con3foo; -- ok -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER TABLE constraint_rename_test RENAME CONSTRAINT con3 TO con3foo; -- ok ^ \d constraint_rename_test Metacommand \d constraint_rename_test is not supported \d constraint_rename_test2 Metacommand \d constraint_rename_test2 is not supported DROP TABLE constraint_rename_test2; DROP TABLE constraint_rename_test; ALTER TABLE IF EXISTS constraint_not_exist RENAME CONSTRAINT con3 TO con3foo; -- ok -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER TABLE IF EXISTS constraint_not_exist RENAME CONSTRAINT con3 TO con3foo; -- ok ^ ALTER TABLE IF EXISTS constraint_rename_test ADD CONSTRAINT con4 UNIQUE (a); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE IF EXISTS constraint_rename_test ADD CONSTRAINT con4 UNIQUE (a); ^ -- renaming constraints with cache reset of target relation CREATE TABLE constraint_rename_cache (a int, CONSTRAINT chk_a CHECK (a > 0), PRIMARY KEY (a)); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: table constraint not supported -- renaming constraints with cache reset of target relation ^ ALTER TABLE constraint_rename_cache RENAME CONSTRAINT chk_a TO chk_a_new; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER TABLE constraint_rename_cache ^ ALTER TABLE constraint_rename_cache RENAME CONSTRAINT constraint_rename_cache_pkey TO constraint_rename_pkey_new; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 ALTER TABLE constraint_rename_cache ^ CREATE TABLE like_constraint_rename_cache (LIKE constraint_rename_cache INCLUDING ALL); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: CreateStmt: alternative is not implemented yet : 389 CREATE TABLE like_constraint_rename_cache ^ \d like_constraint_rename_cache Metacommand \d like_constraint_rename_cache is not supported DROP TABLE constraint_rename_cache; DROP TABLE like_constraint_rename_cache; -- FOREIGN KEY CONSTRAINT adding TEST CREATE TABLE attmp2 (a int primary key); CREATE TABLE attmp3 (a int, b int); CREATE TABLE attmp4 (a int, b int, unique(a,b)); CREATE TABLE attmp5 (a int, b int); -- Insert rows into attmp2 (pktable) INSERT INTO attmp2 values (1); INSERT INTO attmp2 values (2); INSERT INTO attmp2 values (3); INSERT INTO attmp2 values (4); -- Insert rows into attmp3 INSERT INTO attmp3 values (1,10); INSERT INTO attmp3 values (1,20); INSERT INTO attmp3 values (5,50); -- Try (and fail) to add constraint due to invalid source columns ALTER TABLE attmp3 add constraint attmpconstr foreign key(c) references attmp2 match full; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- Try (and fail) to add constraint due to invalid source columns ^ -- Try (and fail) to add constraint due to invalid destination columns explicitly given ALTER TABLE attmp3 add constraint attmpconstr foreign key(a) references attmp2(b) match full; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- Try (and fail) to add constraint due to invalid destination columns explicitly given ^ -- Try (and fail) to add constraint due to invalid data ALTER TABLE attmp3 add constraint attmpconstr foreign key (a) references attmp2 match full; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- Try (and fail) to add constraint due to invalid data ^ -- Delete failing row DELETE FROM attmp3 where a=5; -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'. -- Try (and succeed) ALTER TABLE attmp3 add constraint attmpconstr foreign key (a) references attmp2 match full; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- Try (and succeed) ^ ALTER TABLE attmp3 drop constraint attmpconstr; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp3 drop constraint attmpconstr; ^ INSERT INTO attmp3 values (5,50); -- Try NOT VALID and then VALIDATE CONSTRAINT, but fails. Delete failure then re-validate ALTER TABLE attmp3 add constraint attmpconstr foreign key (a) references attmp2 match full NOT VALID; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- Try NOT VALID and then VALIDATE CONSTRAINT, but fails. Delete failure then re-validate ^ ALTER TABLE attmp3 validate constraint attmpconstr; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp3 validate constraint attmpconstr; ^ -- Delete failing row DELETE FROM attmp3 where a=5; -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'. -- Try (and succeed) and repeat to show it works on already valid constraint ALTER TABLE attmp3 validate constraint attmpconstr; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- Try (and succeed) and repeat to show it works on already valid constraint ^ ALTER TABLE attmp3 validate constraint attmpconstr; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp3 validate constraint attmpconstr; ^ -- Try a non-verified CHECK constraint ALTER TABLE attmp3 ADD CONSTRAINT b_greater_than_ten CHECK (b > 10); -- fail -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- Try a non-verified CHECK constraint ^ ALTER TABLE attmp3 ADD CONSTRAINT b_greater_than_ten CHECK (b > 10) NOT VALID; -- succeeds -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp3 ADD CONSTRAINT b_greater_than_ten CHECK (b > 10) NOT VALID; -- succeeds ^ ALTER TABLE attmp3 VALIDATE CONSTRAINT b_greater_than_ten; -- fails -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp3 VALIDATE CONSTRAINT b_greater_than_ten; -- fails ^ DELETE FROM attmp3 WHERE NOT b > 10; -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'. ALTER TABLE attmp3 VALIDATE CONSTRAINT b_greater_than_ten; -- succeeds -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp3 VALIDATE CONSTRAINT b_greater_than_ten; -- succeeds ^ ALTER TABLE attmp3 VALIDATE CONSTRAINT b_greater_than_ten; -- succeeds -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp3 VALIDATE CONSTRAINT b_greater_than_ten; -- succeeds ^ -- Test inherited NOT VALID CHECK constraints select * from attmp3; CREATE TABLE attmp6 () INHERITS (attmp3); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: table inheritance not supported CREATE TABLE attmp6 () INHERITS (attmp3); ^ CREATE TABLE attmp7 () INHERITS (attmp3); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: table inheritance not supported CREATE TABLE attmp7 () INHERITS (attmp3); ^ INSERT INTO attmp6 VALUES (6, 30), (7, 16); -stdin-:
: Fatal: Table metadata loading -stdin-:
: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.attmp6 ALTER TABLE attmp3 ADD CONSTRAINT b_le_20 CHECK (b <= 20) NOT VALID; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp3 ADD CONSTRAINT b_le_20 CHECK (b <= 20) NOT VALID; ^ ALTER TABLE attmp3 VALIDATE CONSTRAINT b_le_20; -- fails -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp3 VALIDATE CONSTRAINT b_le_20; -- fails ^ DELETE FROM attmp6 WHERE b > 20; -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'. ALTER TABLE attmp3 VALIDATE CONSTRAINT b_le_20; -- succeeds -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp3 VALIDATE CONSTRAINT b_le_20; -- succeeds ^ -- An already validated constraint must not be revalidated CREATE FUNCTION boo(int) RETURNS int IMMUTABLE STRICT LANGUAGE plpgsql AS $$ BEGIN RAISE NOTICE 'boo: %', $1; RETURN $1; END; $$; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 261 -- An already validated constraint must not be revalidated ^ INSERT INTO attmp7 VALUES (8, 18); -stdin-:
: Fatal: Table metadata loading -stdin-:
: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.attmp7 ALTER TABLE attmp7 ADD CONSTRAINT identity CHECK (b = boo(b)); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp7 ADD CONSTRAINT identity CHECK (b = boo(b)); ^ ALTER TABLE attmp3 ADD CONSTRAINT IDENTITY check (b = boo(b)) NOT VALID; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp3 ADD CONSTRAINT IDENTITY check (b = boo(b)) NOT VALID; ^ ALTER TABLE attmp3 VALIDATE CONSTRAINT identity; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE attmp3 VALIDATE CONSTRAINT identity; ^ -- A NO INHERIT constraint should not be looked for in children during VALIDATE CONSTRAINT create table parent_noinh_convalid (a int); create table child_noinh_convalid () inherits (parent_noinh_convalid); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: table inheritance not supported create table child_noinh_convalid () inherits (parent_noinh_convalid); ^ insert into parent_noinh_convalid values (1); insert into child_noinh_convalid values (1); -stdin-:
: Fatal: Table metadata loading -stdin-:
: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.child_noinh_convalid alter table parent_noinh_convalid add constraint check_a_is_2 check (a = 2) no inherit not valid; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table parent_noinh_convalid add constraint check_a_is_2 check (a = 2) no inherit not valid; ^ -- fail, because of the row in parent alter table parent_noinh_convalid validate constraint check_a_is_2; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- fail, because of the row in parent ^ delete from only parent_noinh_convalid; -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'. -- ok (parent itself contains no violating rows) alter table parent_noinh_convalid validate constraint check_a_is_2; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- ok (parent itself contains no violating rows) ^ select convalidated from pg_constraint where conrelid = 'parent_noinh_convalid'::regclass and conname = 'check_a_is_2'; -- cleanup drop table parent_noinh_convalid, child_noinh_convalid; -- Try (and fail) to create constraint from attmp5(a) to attmp4(a) - unique constraint on -- attmp4 is a,b ALTER TABLE attmp5 add constraint attmpconstr foreign key(a) references attmp4(a) match full; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- Try (and fail) to create constraint from attmp5(a) to attmp4(a) - unique constraint on ^ DROP TABLE attmp7; DROP TABLE attmp6; DROP TABLE attmp5; DROP TABLE attmp4; DROP TABLE attmp3; DROP TABLE attmp2; -- NOT VALID with plan invalidation -- ensure we don't use a constraint for -- exclusion until validated set constraint_exclusion TO 'partition'; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: VariableSetStmt, not supported name: constraint_exclusion -- NOT VALID with plan invalidation -- ensure we don't use a constraint for ^ create table nv_parent (d date, check (false) no inherit not valid); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: table constraint not supported create table nv_parent (d date, check (false) no inherit not valid); ^ -- not valid constraint added at creation time should automatically become valid \d nv_parent Metacommand \d nv_parent is not supported create table nv_child_2010 () inherits (nv_parent); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: table inheritance not supported create table nv_child_2010 () inherits (nv_parent); ^ create table nv_child_2011 () inherits (nv_parent); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: table inheritance not supported create table nv_child_2011 () inherits (nv_parent); ^ alter table nv_child_2010 add check (d between '2010-01-01'::date and '2010-12-31'::date) not valid; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table nv_child_2010 add check (d between '2010-01-01'::date and '2010-12-31'::date) not valid; ^ alter table nv_child_2011 add check (d between '2011-01-01'::date and '2011-12-31'::date) not valid; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table nv_child_2011 add check (d between '2011-01-01'::date and '2011-12-31'::date) not valid; ^ explain (costs off) select * from nv_parent where d between '2011-08-01' and '2011-08-31'; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) select * from nv_parent where d between '2011-08-01' and '2011-08-31'; ^ create table nv_child_2009 (check (d between '2009-01-01'::date and '2009-12-31'::date)) inherits (nv_parent); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: table inheritance not supported create table nv_child_2009 (check (d between '2009-01-01'::date and '2009-12-31'::date)) inherits (nv_parent); ^ explain (costs off) select * from nv_parent where d between '2011-08-01'::date and '2011-08-31'::date; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) select * from nv_parent where d between '2011-08-01'::date and '2011-08-31'::date; ^ explain (costs off) select * from nv_parent where d between '2009-08-01'::date and '2009-08-31'::date; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) select * from nv_parent where d between '2009-08-01'::date and '2009-08-31'::date; ^ -- after validation, the constraint should be used alter table nv_child_2011 VALIDATE CONSTRAINT nv_child_2011_d_check; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- after validation, the constraint should be used ^ explain (costs off) select * from nv_parent where d between '2009-08-01'::date and '2009-08-31'::date; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 276 explain (costs off) select * from nv_parent where d between '2009-08-01'::date and '2009-08-31'::date; ^ -- add an inherited NOT VALID constraint alter table nv_parent add check (d between '2001-01-01'::date and '2099-12-31'::date) not valid; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- add an inherited NOT VALID constraint ^ \d nv_child_2009 Metacommand \d nv_child_2009 is not supported -- we leave nv_parent and children around to help test pg_dump logic -- Foreign key adding test with mixed types -- Note: these tables are TEMP to avoid name conflicts when this test -- is run in parallel with foreign_key.sql. CREATE TEMP TABLE PKTABLE (ptest1 int PRIMARY KEY); INSERT INTO PKTABLE VALUES(42); CREATE TEMP TABLE FKTABLE (ftest1 inet); -- This next should fail, because int=inet does not exist ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1) references pktable; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- This next should fail, because int=inet does not exist ^ -- This should also fail for the same reason, but here we -- give the column name ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1) references pktable(ptest1); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- This should also fail for the same reason, but here we ^ DROP TABLE FKTABLE; -- This should succeed, even though they are different types, -- because int=int8 exists and is a member of the integer opfamily CREATE TEMP TABLE FKTABLE (ftest1 int8); ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1) references pktable; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1) references pktable; ^ -- Check it actually works INSERT INTO FKTABLE VALUES(42); -- should succeed INSERT INTO FKTABLE VALUES(43); -- should fail DROP TABLE FKTABLE; -- This should fail, because we'd have to cast numeric to int which is -- not an implicit coercion (or use numeric=numeric, but that's not part -- of the integer opfamily) CREATE TEMP TABLE FKTABLE (ftest1 numeric); ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1) references pktable; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1) references pktable; ^ DROP TABLE FKTABLE; DROP TABLE PKTABLE; -- On the other hand, this should work because int implicitly promotes to -- numeric, and we allow promotion on the FK side CREATE TEMP TABLE PKTABLE (ptest1 numeric PRIMARY KEY); INSERT INTO PKTABLE VALUES(42); CREATE TEMP TABLE FKTABLE (ftest1 int); ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1) references pktable; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1) references pktable; ^ -- Check it actually works INSERT INTO FKTABLE VALUES(42); -- should succeed INSERT INTO FKTABLE VALUES(43); -- should fail DROP TABLE FKTABLE; DROP TABLE PKTABLE; CREATE TEMP TABLE PKTABLE (ptest1 int, ptest2 inet, PRIMARY KEY(ptest1, ptest2)); -- This should fail, because we just chose really odd types CREATE TEMP TABLE FKTABLE (ftest1 cidr, ftest2 timestamp); ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1, ftest2) references pktable; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1, ftest2) references pktable; ^ DROP TABLE FKTABLE; -- Again, so should this... CREATE TEMP TABLE FKTABLE (ftest1 cidr, ftest2 timestamp); ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1, ftest2) references pktable(ptest1, ptest2); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1, ftest2) ^ DROP TABLE FKTABLE; -- This fails because we mixed up the column ordering CREATE TEMP TABLE FKTABLE (ftest1 int, ftest2 inet); ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1, ftest2) references pktable(ptest2, ptest1); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1, ftest2) ^ -- As does this... ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest2, ftest1) references pktable(ptest1, ptest2); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- As does this... ^ DROP TABLE FKTABLE; DROP TABLE PKTABLE; -- Test that ALTER CONSTRAINT updates trigger deferrability properly CREATE TEMP TABLE PKTABLE (ptest1 int primary key); CREATE TEMP TABLE FKTABLE (ftest1 int); ALTER TABLE FKTABLE ADD CONSTRAINT fknd FOREIGN KEY(ftest1) REFERENCES pktable ON DELETE CASCADE ON UPDATE NO ACTION NOT DEFERRABLE; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE FKTABLE ADD CONSTRAINT fknd FOREIGN KEY(ftest1) REFERENCES pktable ^ ALTER TABLE FKTABLE ADD CONSTRAINT fkdd FOREIGN KEY(ftest1) REFERENCES pktable ON DELETE CASCADE ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE FKTABLE ADD CONSTRAINT fkdd FOREIGN KEY(ftest1) REFERENCES pktable ^ ALTER TABLE FKTABLE ADD CONSTRAINT fkdi FOREIGN KEY(ftest1) REFERENCES pktable ON DELETE CASCADE ON UPDATE NO ACTION DEFERRABLE INITIALLY IMMEDIATE; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE FKTABLE ADD CONSTRAINT fkdi FOREIGN KEY(ftest1) REFERENCES pktable ^ ALTER TABLE FKTABLE ADD CONSTRAINT fknd2 FOREIGN KEY(ftest1) REFERENCES pktable ON DELETE CASCADE ON UPDATE NO ACTION DEFERRABLE INITIALLY DEFERRED; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE FKTABLE ADD CONSTRAINT fknd2 FOREIGN KEY(ftest1) REFERENCES pktable ^ ALTER TABLE FKTABLE ALTER CONSTRAINT fknd2 NOT DEFERRABLE; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE FKTABLE ALTER CONSTRAINT fknd2 NOT DEFERRABLE; ^ ALTER TABLE FKTABLE ADD CONSTRAINT fkdd2 FOREIGN KEY(ftest1) REFERENCES pktable ON DELETE CASCADE ON UPDATE NO ACTION NOT DEFERRABLE; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE FKTABLE ADD CONSTRAINT fkdd2 FOREIGN KEY(ftest1) REFERENCES pktable ^ ALTER TABLE FKTABLE ALTER CONSTRAINT fkdd2 DEFERRABLE INITIALLY DEFERRED; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE FKTABLE ALTER CONSTRAINT fkdd2 DEFERRABLE INITIALLY DEFERRED; ^ ALTER TABLE FKTABLE ADD CONSTRAINT fkdi2 FOREIGN KEY(ftest1) REFERENCES pktable ON DELETE CASCADE ON UPDATE NO ACTION NOT DEFERRABLE; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE FKTABLE ADD CONSTRAINT fkdi2 FOREIGN KEY(ftest1) REFERENCES pktable ^ ALTER TABLE FKTABLE ALTER CONSTRAINT fkdi2 DEFERRABLE INITIALLY IMMEDIATE; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 ALTER TABLE FKTABLE ALTER CONSTRAINT fkdi2 DEFERRABLE INITIALLY IMMEDIATE; ^ SELECT conname, tgfoid::regproc, tgtype, tgdeferrable, tginitdeferred FROM pg_trigger JOIN pg_constraint con ON con.oid = tgconstraint WHERE tgrelid = 'pktable'::regclass ORDER BY 1,2,3; -stdin-:
: Error: Type annotation -stdin-:
:1:1: Error: At function: AssumeColumnOrder, At function: Sort SELECT conname, tgfoid::regproc, tgtype, tgdeferrable, tginitdeferred ^ -stdin-:
:1:1: Error: Expected comparable type, but got: Tuple SELECT conname, tgfoid::regproc, tgtype, tgdeferrable, tginitdeferred ^ SELECT conname, tgfoid::regproc, tgtype, tgdeferrable, tginitdeferred FROM pg_trigger JOIN pg_constraint con ON con.oid = tgconstraint WHERE tgrelid = 'fktable'::regclass ORDER BY 1,2,3; -stdin-:
: Error: Type annotation -stdin-:
:1:1: Error: At function: AssumeColumnOrder, At function: Sort SELECT conname, tgfoid::regproc, tgtype, tgdeferrable, tginitdeferred ^ -stdin-:
:1:1: Error: Expected comparable type, but got: Tuple SELECT conname, tgfoid::regproc, tgtype, tgdeferrable, tginitdeferred ^ -- temp tables should go away by themselves, need not drop them. -- test check constraint adding create table atacc1 ( test int ); -- add a check constraint alter table atacc1 add constraint atacc_test1 check (test>3); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- add a check constraint ^ -- should fail insert into atacc1 (test) values (2); -- should succeed insert into atacc1 (test) values (4); drop table atacc1; -- let's do one where the check fails when added create table atacc1 ( test int ); -- insert a soon to be failing row insert into atacc1 (test) values (2); -- add a check constraint (fails) alter table atacc1 add constraint atacc_test1 check (test>3); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- add a check constraint (fails) ^ insert into atacc1 (test) values (4); drop table atacc1; -- let's do one where the check fails because the column doesn't exist create table atacc1 ( test int ); -- add a check constraint (fails) alter table atacc1 add constraint atacc_test1 check (test1>3); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- add a check constraint (fails) ^ drop table atacc1; -- something a little more complicated create table atacc1 ( test int, test2 int, test3 int); -- add a check constraint (fails) alter table atacc1 add constraint atacc_test1 check (test+test2 -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- add a check constraint (fails) ^ -- should fail insert into atacc1 (test,test2,test3) values (4,4,2); -- should succeed insert into atacc1 (test,test2,test3) values (4,4,5); drop table atacc1; -- lets do some naming tests create table atacc1 (test int check (test>3), test2 int); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: column constraint not supported -- lets do some naming tests ^ alter table atacc1 add check (test2>test); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc1 add check (test2>test); ^ -- should fail for $2 insert into atacc1 (test2, test) values (3, 4); -stdin-:
: Fatal: Table metadata loading -stdin-:
: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.atacc1 drop table atacc1; -- inheritance related tests create table atacc1 (test int); create table atacc2 (test2 int); create table atacc3 (test3 int) inherits (atacc1, atacc2); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: table inheritance not supported create table atacc3 (test3 int) inherits (atacc1, atacc2); ^ alter table atacc2 add constraint foo check (test2>0); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc2 add constraint foo check (test2>0); ^ -- fail and then succeed on atacc2 insert into atacc2 (test2) values (-3); insert into atacc2 (test2) values (3); -- fail and then succeed on atacc3 insert into atacc3 (test2) values (-3); -stdin-:
: Fatal: Table metadata loading -stdin-:
: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.atacc3 insert into atacc3 (test2) values (3); -stdin-:
: Fatal: Table metadata loading -stdin-:
: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.atacc3 drop table atacc3; drop table atacc2; drop table atacc1; -- same things with one created with INHERIT create table atacc1 (test int); create table atacc2 (test2 int); create table atacc3 (test3 int) inherits (atacc1, atacc2); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: table inheritance not supported create table atacc3 (test3 int) inherits (atacc1, atacc2); ^ alter table atacc3 no inherit atacc2; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc3 no inherit atacc2; ^ -- fail alter table atacc3 no inherit atacc2; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- fail ^ -- make sure it really isn't a child insert into atacc3 (test2) values (3); -stdin-:
: Fatal: Table metadata loading -stdin-:
: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.atacc3 select test2 from atacc2; -- fail due to missing constraint alter table atacc2 add constraint foo check (test2>0); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- fail due to missing constraint ^ alter table atacc3 inherit atacc2; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc3 inherit atacc2; ^ -- fail due to missing column alter table atacc3 rename test2 to testx; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: RawStmt: alternative is not implemented yet : 264 -- fail due to missing column ^ alter table atacc3 inherit atacc2; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc3 inherit atacc2; ^ -- fail due to mismatched data type alter table atacc3 add test2 bool; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- fail due to mismatched data type ^ alter table atacc3 inherit atacc2; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc3 inherit atacc2; ^ alter table atacc3 drop test2; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc3 drop test2; ^ -- succeed alter table atacc3 add test2 int; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- succeed ^ update atacc3 set test2 = 4 where test2 is null; -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'. alter table atacc3 add constraint foo check (test2>0); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc3 add constraint foo check (test2>0); ^ alter table atacc3 inherit atacc2; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc3 inherit atacc2; ^ -- fail due to duplicates and circular inheritance alter table atacc3 inherit atacc2; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- fail due to duplicates and circular inheritance ^ alter table atacc2 inherit atacc3; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc2 inherit atacc3; ^ alter table atacc2 inherit atacc2; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc2 inherit atacc2; ^ -- test that we really are a child now (should see 4 not 3 and cascade should go through) select test2 from atacc2; drop table atacc2 cascade; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: CASCADE is not implemented drop table atacc2 cascade; ^ drop table atacc1; -- adding only to a parent is allowed as of 9.2 create table atacc1 (test int); create table atacc2 (test2 int) inherits (atacc1); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: table inheritance not supported create table atacc2 (test2 int) inherits (atacc1); ^ -- ok: alter table atacc1 add constraint foo check (test>0) no inherit; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- ok: ^ -- check constraint is not there on child insert into atacc2 (test) values (-3); -- check constraint is there on parent insert into atacc1 (test) values (-3); insert into atacc1 (test) values (3); -- fail, violating row: alter table atacc2 add constraint foo check (test>0) no inherit; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- fail, violating row: ^ drop table atacc2; drop table atacc1; -- test unique constraint adding create table atacc1 ( test int ) ; -- add a unique constraint alter table atacc1 add constraint atacc_test1 unique (test); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- add a unique constraint ^ -- insert first value insert into atacc1 (test) values (2); -- should fail insert into atacc1 (test) values (2); -- should succeed insert into atacc1 (test) values (4); -- try to create duplicates via alter table using - should fail alter table atacc1 alter column test type integer using 0; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- try to create duplicates via alter table using - should fail ^ drop table atacc1; -- let's do one where the unique constraint fails when added create table atacc1 ( test int ); -- insert soon to be failing rows insert into atacc1 (test) values (2); insert into atacc1 (test) values (2); -- add a unique constraint (fails) alter table atacc1 add constraint atacc_test1 unique (test); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- add a unique constraint (fails) ^ insert into atacc1 (test) values (3); drop table atacc1; -- let's do one where the unique constraint fails -- because the column doesn't exist create table atacc1 ( test int ); -- add a unique constraint (fails) alter table atacc1 add constraint atacc_test1 unique (test1); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- add a unique constraint (fails) ^ drop table atacc1; -- something a little more complicated create table atacc1 ( test int, test2 int); -- add a unique constraint alter table atacc1 add constraint atacc_test1 unique (test, test2); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- add a unique constraint ^ -- insert initial value insert into atacc1 (test,test2) values (4,4); -- should fail insert into atacc1 (test,test2) values (4,4); -- should all succeed insert into atacc1 (test,test2) values (4,5); insert into atacc1 (test,test2) values (5,4); insert into atacc1 (test,test2) values (5,5); drop table atacc1; -- lets do some naming tests create table atacc1 (test int, test2 int, unique(test)); alter table atacc1 add unique (test2); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc1 add unique (test2); ^ -- should fail for @@ second one @@ insert into atacc1 (test2, test) values (3, 3); insert into atacc1 (test2, test) values (2, 3); drop table atacc1; -- test primary key constraint adding create table atacc1 ( id serial, test int) ; -- add a primary key constraint alter table atacc1 add constraint atacc_test1 primary key (test); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- add a primary key constraint ^ -- insert first value insert into atacc1 (test) values (2); -- should fail insert into atacc1 (test) values (2); -- should succeed insert into atacc1 (test) values (4); -- inserting NULL should fail insert into atacc1 (test) values(NULL); -- try adding a second primary key (should fail) alter table atacc1 add constraint atacc_oid1 primary key(id); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- try adding a second primary key (should fail) ^ -- drop first primary key constraint alter table atacc1 drop constraint atacc_test1 restrict; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- drop first primary key constraint ^ -- try adding a primary key on oid (should succeed) alter table atacc1 add constraint atacc_oid1 primary key(id); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- try adding a primary key on oid (should succeed) ^ drop table atacc1; -- let's do one where the primary key constraint fails when added create table atacc1 ( test int ); -- insert soon to be failing rows insert into atacc1 (test) values (2); insert into atacc1 (test) values (2); -- add a primary key (fails) alter table atacc1 add constraint atacc_test1 primary key (test); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- add a primary key (fails) ^ insert into atacc1 (test) values (3); drop table atacc1; -- let's do another one where the primary key constraint fails when added create table atacc1 ( test int ); -- insert soon to be failing row insert into atacc1 (test) values (NULL); -- add a primary key (fails) alter table atacc1 add constraint atacc_test1 primary key (test); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- add a primary key (fails) ^ insert into atacc1 (test) values (3); drop table atacc1; -- let's do one where the primary key constraint fails -- because the column doesn't exist create table atacc1 ( test int ); -- add a primary key constraint (fails) alter table atacc1 add constraint atacc_test1 primary key (test1); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- add a primary key constraint (fails) ^ drop table atacc1; -- adding a new column as primary key to a non-empty table. -- should fail unless the column has a non-null default value. create table atacc1 ( test int ); insert into atacc1 (test) values (0); -- add a primary key column without a default (fails). alter table atacc1 add column test2 int primary key; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- add a primary key column without a default (fails). ^ -- now add a primary key column with a default (succeeds). alter table atacc1 add column test2 int default 0 primary key; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- now add a primary key column with a default (succeeds). ^ drop table atacc1; -- this combination used to have order-of-execution problems (bug #15580) create table atacc1 (a int); insert into atacc1 values(1); alter table atacc1 add column b float8 not null default random(), add primary key(a); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc1 ^ drop table atacc1; -- additionally, we've seen issues with foreign key validation not being -- properly delayed until after a table rewrite. Check that works ok. create table atacc1 (a int primary key); alter table atacc1 add constraint atacc1_fkey foreign key (a) references atacc1 (a) not valid; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc1 add constraint atacc1_fkey foreign key (a) references atacc1 (a) not valid; ^ alter table atacc1 validate constraint atacc1_fkey, alter a type bigint; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc1 validate constraint atacc1_fkey, alter a type bigint; ^ drop table atacc1; -- we've also seen issues with check constraints being validated at the wrong -- time when there's a pending table rewrite. create table atacc1 (a bigint, b int); insert into atacc1 values(1,1); alter table atacc1 add constraint atacc1_chk check(b = 1) not valid; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc1 add constraint atacc1_chk check(b = 1) not valid; ^ alter table atacc1 validate constraint atacc1_chk, alter a type int; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc1 validate constraint atacc1_chk, alter a type int; ^ drop table atacc1; -- same as above, but ensure the constraint violation is detected create table atacc1 (a bigint, b int); insert into atacc1 values(1,2); alter table atacc1 add constraint atacc1_chk check(b = 1) not valid; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc1 add constraint atacc1_chk check(b = 1) not valid; ^ alter table atacc1 validate constraint atacc1_chk, alter a type int; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc1 validate constraint atacc1_chk, alter a type int; ^ drop table atacc1; -- something a little more complicated create table atacc1 ( test int, test2 int); -- add a primary key constraint alter table atacc1 add constraint atacc_test1 primary key (test, test2); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- add a primary key constraint ^ -- try adding a second primary key - should fail alter table atacc1 add constraint atacc_test2 primary key (test); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- try adding a second primary key - should fail ^ -- insert initial value insert into atacc1 (test,test2) values (4,4); -- should fail insert into atacc1 (test,test2) values (4,4); insert into atacc1 (test,test2) values (NULL,3); insert into atacc1 (test,test2) values (3, NULL); insert into atacc1 (test,test2) values (NULL,NULL); -- should all succeed insert into atacc1 (test,test2) values (4,5); insert into atacc1 (test,test2) values (5,4); insert into atacc1 (test,test2) values (5,5); drop table atacc1; -- lets do some naming tests create table atacc1 (test int, test2 int, primary key(test)); -- only first should succeed insert into atacc1 (test2, test) values (3, 3); insert into atacc1 (test2, test) values (2, 3); insert into atacc1 (test2, test) values (1, NULL); drop table atacc1; -- alter table / alter column [set/drop] not null tests -- try altering system catalogs, should fail alter table pg_class alter column relname drop not null; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- alter table / alter column [set/drop] not null tests ^ alter table pg_class alter relname set not null; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table pg_class alter relname set not null; ^ -- try altering non-existent table, should fail alter table non_existent alter column bar set not null; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- try altering non-existent table, should fail ^ alter table non_existent alter column bar drop not null; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table non_existent alter column bar drop not null; ^ -- test setting columns to null and not null and vice versa -- test checking for null values and primary key create table atacc1 (test int not null); alter table atacc1 add constraint "atacc1_pkey" primary key (test); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc1 add constraint "atacc1_pkey" primary key (test); ^ alter table atacc1 alter column test drop not null; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc1 alter column test drop not null; ^ alter table atacc1 drop constraint "atacc1_pkey"; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc1 drop constraint "atacc1_pkey"; ^ alter table atacc1 alter column test drop not null; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc1 alter column test drop not null; ^ insert into atacc1 values (null); alter table atacc1 alter test set not null; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc1 alter test set not null; ^ delete from atacc1; -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'. alter table atacc1 alter test set not null; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc1 alter test set not null; ^ -- try altering a non-existent column, should fail alter table atacc1 alter bar set not null; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- try altering a non-existent column, should fail ^ alter table atacc1 alter bar drop not null; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc1 alter bar drop not null; ^ -- try creating a view and altering that, should fail create view myview as select * from atacc1; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: expected at least one target column -- try creating a view and altering that, should fail ^ alter table myview alter column test drop not null; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table myview alter column test drop not null; ^ alter table myview alter column test set not null; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table myview alter column test set not null; ^ drop view myview; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: View not found: 'myview' drop view myview; ^ drop table atacc1; -- set not null verified by constraints create table atacc1 (test_a int, test_b int); insert into atacc1 values (null, 1); -- constraint not cover all values, should fail alter table atacc1 add constraint atacc1_constr_or check(test_a is not null or test_b < 10); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- constraint not cover all values, should fail ^ alter table atacc1 alter test_a set not null; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc1 alter test_a set not null; ^ alter table atacc1 drop constraint atacc1_constr_or; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc1 drop constraint atacc1_constr_or; ^ -- not valid constraint, should fail alter table atacc1 add constraint atacc1_constr_invalid check(test_a is not null) not valid; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- not valid constraint, should fail ^ alter table atacc1 alter test_a set not null; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc1 alter test_a set not null; ^ alter table atacc1 drop constraint atacc1_constr_invalid; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc1 drop constraint atacc1_constr_invalid; ^ -- with valid constraint update atacc1 set test_a = 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'. alter table atacc1 add constraint atacc1_constr_a_valid check(test_a is not null); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc1 add constraint atacc1_constr_a_valid check(test_a is not null); ^ alter table atacc1 alter test_a set not null; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc1 alter test_a set not null; ^ delete from atacc1; -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 atacc1 values (2, null); alter table atacc1 alter test_a drop not null; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc1 alter test_a drop not null; ^ -- test multiple set not null at same time -- test_a checked by atacc1_constr_a_valid, test_b should fail by table scan alter table atacc1 alter test_a set not null, alter test_b set not null; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- test multiple set not null at same time ^ -- commands order has no importance alter table atacc1 alter test_b set not null, alter test_a set not null; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- commands order has no importance ^ -- valid one by table scan, one by check constraints update atacc1 set test_b = 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'. alter table atacc1 alter test_b set not null, alter test_a set not null; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc1 alter test_b set not null, alter test_a set not null; ^ alter table atacc1 alter test_a drop not null, alter test_b drop not null; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc1 alter test_a drop not null, alter test_b drop not null; ^ -- both column has check constraints alter table atacc1 add constraint atacc1_constr_b_valid check(test_b is not null); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 -- both column has check constraints ^ alter table atacc1 alter test_b set not null, alter test_a set not null; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table atacc1 alter test_b set not null, alter test_a set not null; ^ drop table atacc1; -- test inheritance create table parent (a int); create table child (b varchar(255)) inherits (parent); -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: table inheritance not supported create table child (b varchar(255)) inherits (parent); ^ alter table parent alter a set not null; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table parent alter a set not null; ^ insert into parent values (NULL); insert into child (a, b) values (NULL, 'foo'); -stdin-:
: Fatal: Table metadata loading -stdin-:
: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.child alter table parent alter a drop not null; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table parent alter a drop not null; ^ insert into parent values (NULL); insert into child (a, b) values (NULL, 'foo'); -stdin-:
: Fatal: Table metadata loading -stdin-:
: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.child alter table only parent alter a set not null; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table only parent alter a set not null; ^ alter table child alter a set not null; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table child alter a set not null; ^ delete from parent; -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'. alter table only parent alter a set not null; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table only parent alter a set not null; ^ insert into parent values (NULL); alter table child alter a set not null; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table child alter a set not null; ^ insert into child (a, b) values (NULL, 'foo'); -stdin-:
: Fatal: Table metadata loading -stdin-:
: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.child delete from child; -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'. alter table child alter a set not null; -stdin-:
: Error: Parse Sql -stdin-:
:1:1: Error: alternative is not implemented yet : 245 alter table child alter a set not null; ^ insert into child (a, b) values (NULL, 'foo'); -stdin-:
: Fatal: Table metadata loading -stdin-:
: Fatal: ydb/library/yql/providers/yt/gateway/file/yql_yt_file_services.cpp:44: Table not found: plato.child drop table child; drop table parent; -- test setting and removing default values create table def_test ( c1 int4 default 5, c2 text default 'initial_default' ); insert into def_test 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'. alter table def_test alter column c1 drop default; NSQLTranslationPG::TConverter::ParseAlterTableStmt(AlterTableStmt const*) at /-S/ydb/library/yql/sql/pg/pg_sql.cpp:2904:0 NSQLTranslationPG::TConverter::ParseRawStmt(RawStmt const*) at /-S/ydb/library/yql/sql/pg/pg_sql.cpp:510:0 NSQLTranslationPG::TConverter::ParseResult(List const*, TMaybe) at /-S/ydb/library/yql/sql/pg/pg_sql.cpp:393:0 NSQLTranslationPG::TConverter::OnResult(List const*) at /-S/ydb/library/yql/sql/pg/pg_sql.cpp:351:0 NYql::PGParse(TBasicString> const&, NYql::IPGParseEvents&) at /-S/ydb/library/yql/parser/pg_wrapper/parser.cpp:217:0 NSQLTranslationPG::PGToYql(TBasicString> const&, NSQLTranslation::TTranslationSettings const&, NYql::TStmtParseInfo*) at /-S/ydb/library/yql/sql/pg/pg_sql.cpp:5109:0 NSQLTranslation::SqlToYql(TBasicString> const&, NSQLTranslation::TTranslationSettings const&, TVector>*, NYql::TStmtParseInfo*) at /-S/ydb/library/yql/sql/sql.cpp:38:0 NYql::TProgram::ParseSql(NSQLTranslation::TTranslationSettings const&) at /-S/ydb/library/yql/core/facade/yql_facade.cpp:658:0 Main(int, char**) at /-S/ydb/library/yql/tools/pgrun/pgrun.cpp:1239:0 main at /-S/ydb/library/yql/tools/pgrun/pgrun.cpp:1341:0 __libc_start_call_main at ../sysdeps/nptl/libc_start_call_main.h:58:0 __libc_start_main_impl at ../csu/libc-start.c:392:0 ??? at ???:0:0