Repository: incubator-hawq Updated Branches: refs/heads/master 9833d128c -> 76260cdf4
HAWQ-817. Remove deprecated test cases from checkinstall-good Project: http://git-wip-us.apache.org/repos/asf/incubator-hawq/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-hawq/commit/76260cdf Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq/tree/76260cdf Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq/diff/76260cdf Branch: refs/heads/master Commit: 76260cdf4b83bd29469dfb200a20cee496e8a173 Parents: 9833d12 Author: YI JIN <y...@pivotal.io> Authored: Thu Jun 16 12:47:35 2016 +1000 Committer: YI JIN <y...@pivotal.io> Committed: Thu Jun 16 12:47:35 2016 +1000 ---------------------------------------------------------------------- src/test/regress/expected/goh_alter_owner.out | 39 ---- src/test/regress/expected/insert.out | 90 -------- src/test/regress/expected/insert_optimizer.out | 92 -------- src/test/regress/expected/sequence.out | 214 ------------------ .../regress/expected/sequence_optimizer.out | 215 ------------------- src/test/regress/known_good_schedule | 4 - src/test/regress/sql/goh_alter_owner.sql | 16 -- src/test/regress/sql/insert.sql | 73 ------- src/test/regress/sql/sequence.sql | 110 ---------- 9 files changed, 853 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/76260cdf/src/test/regress/expected/goh_alter_owner.out ---------------------------------------------------------------------- diff --git a/src/test/regress/expected/goh_alter_owner.out b/src/test/regress/expected/goh_alter_owner.out deleted file mode 100644 index dc0f7e1..0000000 --- a/src/test/regress/expected/goh_alter_owner.out +++ /dev/null @@ -1,39 +0,0 @@ -CREATE ROLE super SUPERUSER; -SET SESSION AUTHORIZATION super; -CREATE ROLE u1; -NOTICE: resource queue required -- using default resource queue "pg_default" -CREATE DATABASE u1; -CREATE SCHEMA u1; -select nspname, rolname from pg_namespace n, pg_authid a where n.nspowner = a.oid and nspname = 'u1'; - nspname | rolname ----------+--------- - u1 | super -(1 row) - -select datname, rolname from pg_database d, pg_authid a where d.datdba = a.oid and datname = 'u1'; - datname | rolname ----------+--------- - u1 | super -(1 row) - -alter database u1 owner to u1; -ERROR: Cannot support alter database owner statement yet -alter schema u1 owner to u1; -ERROR: Cannot support alter schema owner statement yet -select nspname, rolname from pg_namespace n, pg_authid a where n.nspowner = a.oid and nspname = 'u1'; - nspname | rolname ----------+--------- - u1 | super -(1 row) - -select datname, rolname from pg_database d, pg_authid a where d.datdba = a.oid and datname = 'u1'; - datname | rolname ----------+--------- - u1 | super -(1 row) - -RESET SESSION AUTHORIZATION; -DROP DATABASE u1; -DROP SCHEMA u1; -DROP ROLE u1; -DROP ROLE super; http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/76260cdf/src/test/regress/expected/insert.out ---------------------------------------------------------------------- diff --git a/src/test/regress/expected/insert.out b/src/test/regress/expected/insert.out deleted file mode 100644 index d254596..0000000 --- a/src/test/regress/expected/insert.out +++ /dev/null @@ -1,90 +0,0 @@ --- --- insert with DEFAULT in the target_list --- -create table inserttest (col1 int4, col2 int4 NOT NULL, col3 text default 'testing'); -insert into inserttest (col1, col2, col3) values (DEFAULT, DEFAULT, DEFAULT); -ERROR: null value in column "col2" violates not-null constraint (seg0 localhost:40000 pid=88865) -insert into inserttest (col2, col3) values (3, DEFAULT); -insert into inserttest (col1, col2, col3) values (DEFAULT, 5, DEFAULT); -insert into inserttest values (DEFAULT, 5, 'test'); -insert into inserttest values (DEFAULT, 7); -select * from inserttest order by 1,2,3; - col1 | col2 | col3 -------+------+--------- - | 3 | testing - | 5 | test - | 5 | testing - | 7 | testing -(4 rows) - --- --- insert with similar expression / target_list values (all fail) --- -insert into inserttest (col1, col2, col3) values (DEFAULT, DEFAULT); -ERROR: INSERT has more target columns than expressions -insert into inserttest (col1, col2, col3) values (1, 2); -ERROR: INSERT has more target columns than expressions -insert into inserttest (col1) values (1, 2); -ERROR: INSERT has more expressions than target columns -insert into inserttest (col1) values (DEFAULT, DEFAULT); -ERROR: INSERT has more expressions than target columns -select * from inserttest order by 1,2,3; - col1 | col2 | col3 -------+------+--------- - | 3 | testing - | 5 | test - | 5 | testing - | 7 | testing -(4 rows) - --- --- VALUES test --- -insert into inserttest values(10, 20, '40'), (-1, 2, DEFAULT), - ((select 2), (select i from (values(3)) as foo (i)), 'values are fun!'); -select * from inserttest order by 1,2,3; - col1 | col2 | col3 -------+------+----------------- - -1 | 2 | testing - 2 | 3 | values are fun! - 10 | 20 | 40 - | 3 | testing - | 5 | test - | 5 | testing - | 7 | testing -(7 rows) - -drop table inserttest; --- MPP-6775 : Adding and dropping a column. Then perform an insert. - -create table bar(x int) distributed randomly; -create table foo(like bar) distributed randomly; -alter table foo add column y int; -ERROR: ADD COLUMN with no default value in append-only tables is not yet supported. -alter table foo drop column y; -ERROR: column "y" of relation "foo" does not exist -insert into bar values(1); -insert into bar values(2); -insert into foo(x) select t1.x from bar t1 join bar t2 on t1.x=t2.x; -insert into foo(x) select t1.x from bar t1; -insert into foo(x) select t1.x from bar t1 group by t1.x; -drop table if exists foo; -drop table if exists bar; --- MPP-6775 : Dropping a column. Then perform an insert. -create table bar(x int, y int) distributed randomly; -create table foo(like bar) distributed randomly; -alter table foo drop column y; -insert into bar values(1,1); -insert into bar values(2,2); -insert into foo(x) select t1.x from bar t1 join bar t2 on t1.x=t2.x; -insert into foo(x) select t1.x from bar t1; -insert into foo(x) select t1.x from bar t1 group by t1.x; -drop table if exists foo; -drop table if exists bar; --- GPSQL-221 -BEGIN; -CREATE TABLE mpp14758(a int) with (appendonly=true); -NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. -HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. -INSERT INTO mpp14758 select * from generate_series(1,10); -ABORT; http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/76260cdf/src/test/regress/expected/insert_optimizer.out ---------------------------------------------------------------------- diff --git a/src/test/regress/expected/insert_optimizer.out b/src/test/regress/expected/insert_optimizer.out deleted file mode 100755 index f5f263a..0000000 --- a/src/test/regress/expected/insert_optimizer.out +++ /dev/null @@ -1,92 +0,0 @@ --- --- insert with DEFAULT in the target_list --- -create table inserttest (col1 int4, col2 int4 NOT NULL, col3 text default 'testing'); -NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'col1' as the Greenplum Database data distribution key for this table. -HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. -insert into inserttest (col1, col2, col3) values (DEFAULT, DEFAULT, DEFAULT); -ERROR: null value in column "col2" violates not-null constraint (COptTasks.cpp:1756) -insert into inserttest (col2, col3) values (3, DEFAULT); -insert into inserttest (col1, col2, col3) values (DEFAULT, 5, DEFAULT); -insert into inserttest values (DEFAULT, 5, 'test'); -insert into inserttest values (DEFAULT, 7); -select * from inserttest order by 1,2,3; - col1 | col2 | col3 -------+------+--------- - | 3 | testing - | 5 | test - | 5 | testing - | 7 | testing -(4 rows) - --- --- insert with similar expression / target_list values (all fail) --- -insert into inserttest (col1, col2, col3) values (DEFAULT, DEFAULT); -ERROR: INSERT has more target columns than expressions -insert into inserttest (col1, col2, col3) values (1, 2); -ERROR: INSERT has more target columns than expressions -insert into inserttest (col1) values (1, 2); -ERROR: INSERT has more expressions than target columns -insert into inserttest (col1) values (DEFAULT, DEFAULT); -ERROR: INSERT has more expressions than target columns -select * from inserttest order by 1,2,3; - col1 | col2 | col3 -------+------+--------- - | 3 | testing - | 5 | test - | 5 | testing - | 7 | testing -(4 rows) - --- --- VALUES test --- -insert into inserttest values(10, 20, '40'), (-1, 2, DEFAULT), - ((select 2), (select i from (values(3)) as foo (i)), 'values are fun!'); -select * from inserttest order by 1,2,3; - col1 | col2 | col3 -------+------+----------------- - -1 | 2 | testing - 2 | 3 | values are fun! - 10 | 20 | 40 - | 3 | testing - | 5 | test - | 5 | testing - | 7 | testing -(7 rows) - -drop table inserttest; --- MPP-6775 : Adding and dropping a column. Then perform an insert. - -create table bar(x int) distributed randomly; -create table foo(like bar) distributed randomly; -alter table foo add column y int; -ERROR: ADD COLUMN with no default value in append-only tables is not yet supported. -alter table foo drop column y; -ERROR: column "y" of relation "foo" does not exist -insert into bar values(1); -insert into bar values(2); -insert into foo(x) select t1.x from bar t1 join bar t2 on t1.x=t2.x; -insert into foo(x) select t1.x from bar t1; -insert into foo(x) select t1.x from bar t1 group by t1.x; -drop table if exists foo; -drop table if exists bar; --- MPP-6775 : Dropping a column. Then perform an insert. -create table bar(x int, y int) distributed randomly; -create table foo(like bar) distributed randomly; -alter table foo drop column y; -insert into bar values(1,1); -insert into bar values(2,2); -insert into foo(x) select t1.x from bar t1 join bar t2 on t1.x=t2.x; -insert into foo(x) select t1.x from bar t1; -insert into foo(x) select t1.x from bar t1 group by t1.x; -drop table if exists foo; -drop table if exists bar; --- GPSQL-221 -BEGIN; -CREATE TABLE mpp14758(a int) with (appendonly=true); -NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. -HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. -INSERT INTO mpp14758 select * from generate_series(1,10); -ABORT; http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/76260cdf/src/test/regress/expected/sequence.out ---------------------------------------------------------------------- diff --git a/src/test/regress/expected/sequence.out b/src/test/regress/expected/sequence.out deleted file mode 100755 index 0ae4820..0000000 --- a/src/test/regress/expected/sequence.out +++ /dev/null @@ -1,214 +0,0 @@ ---- ---- test creation of SERIAL column ---- - -CREATE TABLE serialTest (f1 text, f2 serial); -NOTICE: CREATE TABLE will create implicit sequence "serialtest_f2_seq" for serial column "serialtest.f2" -NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'f1' as the Greenplum Database data distribution key for this table. -HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. - -INSERT INTO serialTest VALUES ('foo'); -INSERT INTO serialTest VALUES ('bar'); -INSERT INTO serialTest VALUES ('force', 100); -INSERT INTO serialTest VALUES ('wrong', NULL); -ERROR: null value in column "f2" violates not-null constraint (seg jianl-mbp:40000 pid=60071) - -SELECT * FROM serialTest ORDER BY 2; - f1 | f2 --------+----- - foo | 1 - bar | 2 - force | 100 -(3 rows) - --- basic sequence operations using both text and oid references -CREATE SEQUENCE sequence_test; - -SELECT nextval('sequence_test'::text); - nextval ---------- - 1 -(1 row) - -SELECT nextval('sequence_test'::regclass); - nextval ---------- - 2 -(1 row) - ---SELECT currval('sequence_test'::text); ---SELECT currval('sequence_test'::regclass); -SELECT setval('sequence_test'::text, 32); - setval --------- - 32 -(1 row) - -SELECT nextval('sequence_test'::regclass); - nextval ---------- - 33 -(1 row) - -SELECT setval('sequence_test'::text, 99, false); - setval --------- - 99 -(1 row) - -SELECT nextval('sequence_test'::regclass); - nextval ---------- - 99 -(1 row) - -SELECT setval('sequence_test'::regclass, 32); - setval --------- - 32 -(1 row) - -SELECT nextval('sequence_test'::text); - nextval ---------- - 33 -(1 row) - -SELECT setval('sequence_test'::regclass, 99, false); - setval --------- - 99 -(1 row) - -SELECT nextval('sequence_test'::text); - nextval ---------- - 99 -(1 row) - -DROP SEQUENCE sequence_test; --- renaming sequences -CREATE SEQUENCE foo_seq; -ALTER TABLE foo_seq RENAME TO foo_seq_new; -SELECT * FROM foo_seq_new; - sequence_name | last_value | increment_by | max_value | min_value | cache_value | log_cnt | is_cycled | is_called ----------------+------------+--------------+---------------------+-----------+-------------+---------+-----------+----------- - foo_seq | 1 | 1 | 9223372036854775807 | 1 | 1 | 1 | f | f -(1 row) - -DROP SEQUENCE foo_seq_new; --- renaming serial sequences -ALTER TABLE serialtest_f2_seq RENAME TO serialtest_f2_foo; -INSERT INTO serialTest VALUES ('more'); -SELECT * FROM serialTest ORDER BY 2; - f1 | f2 --------+----- - foo | 1 - bar | 2 - more | 3 - force | 100 -(4 rows) - --- --- Check dependencies of serial and ordinary sequences --- -CREATE TEMP SEQUENCE myseq2; -CREATE TEMP SEQUENCE myseq3; -CREATE TEMP TABLE t1 ( - f1 serial, - f2 int DEFAULT nextval('myseq2'), - f3 int DEFAULT nextval('myseq3'::text) -); -NOTICE: CREATE TABLE will create implicit sequence "t1_f1_seq" for serial column "t1.f1" -NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'f1' as the Greenplum Database data distribution key for this table. -HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. --- Both drops should fail, but with different error messages: -DROP SEQUENCE t1_f1_seq; -NOTICE: default for append only table t1 column f1 depends on sequence t1_f1_seq -ERROR: cannot drop sequence t1_f1_seq because other objects depend on it -HINT: Use DROP ... CASCADE to drop the dependent objects too. -DROP SEQUENCE myseq2; -NOTICE: default for append only table t1 column f2 depends on sequence myseq2 -ERROR: cannot drop sequence myseq2 because other objects depend on it -HINT: Use DROP ... CASCADE to drop the dependent objects too. --- This however will work: -DROP SEQUENCE myseq3; -DROP TABLE t1; --- Fails because no longer existent: -DROP SEQUENCE t1_f1_seq; -ERROR: sequence "t1_f1_seq" does not exist --- Now OK: -DROP SEQUENCE myseq2; --- --- Alter sequence --- -CREATE SEQUENCE sequence_test2 START WITH 32; -SELECT nextval('sequence_test2'); - nextval ---------- - 32 -(1 row) - -ALTER SEQUENCE sequence_test2 RESTART WITH 16 - INCREMENT BY 4 MAXVALUE 22 MINVALUE 5 CYCLE; -SELECT nextval('sequence_test2'); - nextval ---------- - 16 -(1 row) - -SELECT nextval('sequence_test2'); - nextval ---------- - 20 -(1 row) - -SELECT nextval('sequence_test2'); - nextval ---------- - 5 -(1 row) - -SELECT nextval(oid) FROM gp_dist_random('pg_class') WHERE relname = 'sequence_test2'; -ERROR: Non const argument in function "NEXTVAL" is not support yet. --- Test comments --- COMMENT ON SEQUENCE asdf IS 'won''t work'; --- COMMENT ON SEQUENCE sequence_test2 IS 'will work'; --- COMMENT ON SEQUENCE sequence_test2 IS NULL; --- Test lastval() -CREATE SEQUENCE seq; -SELECT nextval('seq'); - nextval ---------- - 1 -(1 row) - ---SELECT lastval(); -SELECT setval('seq', 99); - setval --------- - 99 -(1 row) - ---SELECT lastval(); -CREATE SEQUENCE seq2; -SELECT nextval('seq2'); - nextval ---------- - 1 -(1 row) - ---SELECT lastval(); -DROP SEQUENCE seq2; --- should fail ---SELECT lastval(); --- CREATE USER seq_user; --- BEGIN; --- SET LOCAL SESSION AUTHORIZATION seq_user; --- CREATE SEQUENCE seq3; --- SELECT nextval('seq3'); --- REVOKE ALL ON seq3 FROM seq_user; ---SELECT lastval(); --- ROLLBACK; --- DROP USER seq_user; -DROP SEQUENCE seq; http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/76260cdf/src/test/regress/expected/sequence_optimizer.out ---------------------------------------------------------------------- diff --git a/src/test/regress/expected/sequence_optimizer.out b/src/test/regress/expected/sequence_optimizer.out deleted file mode 100644 index 16bd6e0..0000000 --- a/src/test/regress/expected/sequence_optimizer.out +++ /dev/null @@ -1,215 +0,0 @@ ---- ---- test creation of SERIAL column ---- - -CREATE TABLE serialTest (f1 text, f2 serial); -NOTICE: CREATE TABLE will create implicit sequence "serialtest_f2_seq" for serial column "serialtest.f2" -NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'f1' as the Greenplum Database data distribution key for this table. -HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. - -INSERT INTO serialTest VALUES ('foo'); -INSERT INTO serialTest VALUES ('bar'); -INSERT INTO serialTest VALUES ('force', 100); -INSERT INTO serialTest VALUES ('wrong', NULL); -ERROR: One or more assertions failed (seg0 antova-mbp.local:40010 pid=33679) -DETAIL: Not null constraint for column f2 of table serialtest was violated - -SELECT * FROM serialTest ORDER BY 2; - f1 | f2 --------+----- - foo | 1 - bar | 2 - force | 100 -(3 rows) - --- basic sequence operations using both text and oid references -CREATE SEQUENCE sequence_test; - -SELECT nextval('sequence_test'::text); - nextval ---------- - 1 -(1 row) - -SELECT nextval('sequence_test'::regclass); - nextval ---------- - 2 -(1 row) - ---SELECT currval('sequence_test'::text); ---SELECT currval('sequence_test'::regclass); -SELECT setval('sequence_test'::text, 32); - setval --------- - 32 -(1 row) - -SELECT nextval('sequence_test'::regclass); - nextval ---------- - 33 -(1 row) - -SELECT setval('sequence_test'::text, 99, false); - setval --------- - 99 -(1 row) - -SELECT nextval('sequence_test'::regclass); - nextval ---------- - 99 -(1 row) - -SELECT setval('sequence_test'::regclass, 32); - setval --------- - 32 -(1 row) - -SELECT nextval('sequence_test'::text); - nextval ---------- - 33 -(1 row) - -SELECT setval('sequence_test'::regclass, 99, false); - setval --------- - 99 -(1 row) - -SELECT nextval('sequence_test'::text); - nextval ---------- - 99 -(1 row) - -DROP SEQUENCE sequence_test; --- renaming sequences -CREATE SEQUENCE foo_seq; -ALTER TABLE foo_seq RENAME TO foo_seq_new; -SELECT * FROM foo_seq_new; - sequence_name | last_value | increment_by | max_value | min_value | cache_value | log_cnt | is_cycled | is_called ----------------+------------+--------------+---------------------+-----------+-------------+---------+-----------+----------- - foo_seq | 1 | 1 | 9223372036854775807 | 1 | 1 | 1 | f | f -(1 row) - -DROP SEQUENCE foo_seq_new; --- renaming serial sequences -ALTER TABLE serialtest_f2_seq RENAME TO serialtest_f2_foo; -INSERT INTO serialTest VALUES ('more'); -SELECT * FROM serialTest ORDER BY 2; - f1 | f2 --------+----- - foo | 1 - bar | 2 - more | 3 - force | 100 -(4 rows) - --- --- Check dependencies of serial and ordinary sequences --- -CREATE TEMP SEQUENCE myseq2; -CREATE TEMP SEQUENCE myseq3; -CREATE TEMP TABLE t1 ( - f1 serial, - f2 int DEFAULT nextval('myseq2'), - f3 int DEFAULT nextval('myseq3'::text) -); -NOTICE: CREATE TABLE will create implicit sequence "t1_f1_seq" for serial column "t1.f1" -NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'f1' as the Greenplum Database data distribution key for this table. -HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. --- Both drops should fail, but with different error messages: -DROP SEQUENCE t1_f1_seq; -NOTICE: default for table t1 column f1 depends on sequence t1_f1_seq -ERROR: cannot drop sequence t1_f1_seq because other objects depend on it -HINT: Use DROP ... CASCADE to drop the dependent objects too. -DROP SEQUENCE myseq2; -NOTICE: default for table t1 column f2 depends on sequence myseq2 -ERROR: cannot drop sequence myseq2 because other objects depend on it -HINT: Use DROP ... CASCADE to drop the dependent objects too. --- This however will work: -DROP SEQUENCE myseq3; -DROP TABLE t1; --- Fails because no longer existent: -DROP SEQUENCE t1_f1_seq; -ERROR: sequence "t1_f1_seq" does not exist --- Now OK: -DROP SEQUENCE myseq2; --- --- Alter sequence --- -CREATE SEQUENCE sequence_test2 START WITH 32; -SELECT nextval('sequence_test2'); - nextval ---------- - 32 -(1 row) - -ALTER SEQUENCE sequence_test2 RESTART WITH 16 - INCREMENT BY 4 MAXVALUE 22 MINVALUE 5 CYCLE; -SELECT nextval('sequence_test2'); - nextval ---------- - 16 -(1 row) - -SELECT nextval('sequence_test2'); - nextval ---------- - 20 -(1 row) - -SELECT nextval('sequence_test2'); - nextval ---------- - 5 -(1 row) - -SELECT nextval(oid) FROM gp_dist_random('pg_class') WHERE relname = 'sequence_test2'; -ERROR: Non const argument in function "NEXTVAL" is not support yet. --- Test comments --- COMMENT ON SEQUENCE asdf IS 'won''t work'; --- COMMENT ON SEQUENCE sequence_test2 IS 'will work'; --- COMMENT ON SEQUENCE sequence_test2 IS NULL; --- Test lastval() -CREATE SEQUENCE seq; -SELECT nextval('seq'); - nextval ---------- - 1 -(1 row) - ---SELECT lastval(); -SELECT setval('seq', 99); - setval --------- - 99 -(1 row) - ---SELECT lastval(); -CREATE SEQUENCE seq2; -SELECT nextval('seq2'); - nextval ---------- - 1 -(1 row) - ---SELECT lastval(); -DROP SEQUENCE seq2; --- should fail ---SELECT lastval(); --- CREATE USER seq_user; --- BEGIN; --- SET LOCAL SESSION AUTHORIZATION seq_user; --- CREATE SEQUENCE seq3; --- SELECT nextval('seq3'); --- REVOKE ALL ON seq3 FROM seq_user; ---SELECT lastval(); --- ROLLBACK; --- DROP USER seq_user; -DROP SEQUENCE seq; http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/76260cdf/src/test/regress/known_good_schedule ---------------------------------------------------------------------- diff --git a/src/test/regress/known_good_schedule b/src/test/regress/known_good_schedule index b84e00f..bb14fa2 100755 --- a/src/test/regress/known_good_schedule +++ b/src/test/regress/known_good_schedule @@ -19,9 +19,7 @@ test: goh_database test: goh_gp_dist_random ignore: gpsql_fault_tolerance test: goh_portals -test: goh_prepare ignore: goh_set_schema -test: goh_alter_owner test: boolean test: char test: name @@ -59,7 +57,6 @@ ignore: oidjoins ignore: opr_sanity ignore: geometry ignore: horology -test: insert test: create_function_1 test: subplan ignore: create_type @@ -133,7 +130,6 @@ ignore: without_oid ignore: conversion ignore: truncate ignore: alter_table -test: sequence test: polymorphism test: rowtypes ignore: returning http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/76260cdf/src/test/regress/sql/goh_alter_owner.sql ---------------------------------------------------------------------- diff --git a/src/test/regress/sql/goh_alter_owner.sql b/src/test/regress/sql/goh_alter_owner.sql deleted file mode 100644 index 4871649..0000000 --- a/src/test/regress/sql/goh_alter_owner.sql +++ /dev/null @@ -1,16 +0,0 @@ -CREATE ROLE super SUPERUSER; -SET SESSION AUTHORIZATION super; -CREATE ROLE u1; -CREATE DATABASE u1; -CREATE SCHEMA u1; -select nspname, rolname from pg_namespace n, pg_authid a where n.nspowner = a.oid and nspname = 'u1'; -select datname, rolname from pg_database d, pg_authid a where d.datdba = a.oid and datname = 'u1'; -alter database u1 owner to u1; -alter schema u1 owner to u1; -select nspname, rolname from pg_namespace n, pg_authid a where n.nspowner = a.oid and nspname = 'u1'; -select datname, rolname from pg_database d, pg_authid a where d.datdba = a.oid and datname = 'u1'; -RESET SESSION AUTHORIZATION; -DROP DATABASE u1; -DROP SCHEMA u1; -DROP ROLE u1; -DROP ROLE super; http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/76260cdf/src/test/regress/sql/insert.sql ---------------------------------------------------------------------- diff --git a/src/test/regress/sql/insert.sql b/src/test/regress/sql/insert.sql deleted file mode 100644 index 7e40a20..0000000 --- a/src/test/regress/sql/insert.sql +++ /dev/null @@ -1,73 +0,0 @@ --- --- insert with DEFAULT in the target_list --- -create table inserttest (col1 int4, col2 int4 NOT NULL, col3 text default 'testing'); -insert into inserttest (col1, col2, col3) values (DEFAULT, DEFAULT, DEFAULT); -insert into inserttest (col2, col3) values (3, DEFAULT); -insert into inserttest (col1, col2, col3) values (DEFAULT, 5, DEFAULT); -insert into inserttest values (DEFAULT, 5, 'test'); -insert into inserttest values (DEFAULT, 7); - -select * from inserttest order by 1,2,3; - --- --- insert with similar expression / target_list values (all fail) --- -insert into inserttest (col1, col2, col3) values (DEFAULT, DEFAULT); -insert into inserttest (col1, col2, col3) values (1, 2); -insert into inserttest (col1) values (1, 2); -insert into inserttest (col1) values (DEFAULT, DEFAULT); - -select * from inserttest order by 1,2,3; - --- --- VALUES test --- -insert into inserttest values(10, 20, '40'), (-1, 2, DEFAULT), - ((select 2), (select i from (values(3)) as foo (i)), 'values are fun!'); - -select * from inserttest order by 1,2,3; - -drop table inserttest; - --- MPP-6775 : Adding and dropping a column. Then perform an insert. - -create table bar(x int) distributed randomly; -create table foo(like bar) distributed randomly; - -alter table foo add column y int; -alter table foo drop column y; - -insert into bar values(1); -insert into bar values(2); - -insert into foo(x) select t1.x from bar t1 join bar t2 on t1.x=t2.x; -insert into foo(x) select t1.x from bar t1; -insert into foo(x) select t1.x from bar t1 group by t1.x; - -drop table if exists foo; -drop table if exists bar; - --- MPP-6775 : Dropping a column. Then perform an insert. - -create table bar(x int, y int) distributed randomly; -create table foo(like bar) distributed randomly; - -alter table foo drop column y; - -insert into bar values(1,1); -insert into bar values(2,2); - -insert into foo(x) select t1.x from bar t1 join bar t2 on t1.x=t2.x; -insert into foo(x) select t1.x from bar t1; -insert into foo(x) select t1.x from bar t1 group by t1.x; - -drop table if exists foo; -drop table if exists bar; - --- GPSQL-221 - -BEGIN; -CREATE TABLE mpp14758(a int) with (appendonly=true); -INSERT INTO mpp14758 select * from generate_series(1,10); -ABORT; http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/76260cdf/src/test/regress/sql/sequence.sql ---------------------------------------------------------------------- diff --git a/src/test/regress/sql/sequence.sql b/src/test/regress/sql/sequence.sql deleted file mode 100644 index bf333f0..0000000 --- a/src/test/regress/sql/sequence.sql +++ /dev/null @@ -1,110 +0,0 @@ ---- ---- test creation of SERIAL column ---- - -CREATE TABLE serialTest (f1 text, f2 serial); - -INSERT INTO serialTest VALUES ('foo'); -INSERT INTO serialTest VALUES ('bar'); -INSERT INTO serialTest VALUES ('force', 100); -INSERT INTO serialTest VALUES ('wrong', NULL); - -SELECT * FROM serialTest ORDER BY 2; - --- basic sequence operations using both text and oid references -CREATE SEQUENCE sequence_test; - -SELECT nextval('sequence_test'::text); -SELECT nextval('sequence_test'::regclass); ---SELECT currval('sequence_test'::text); ---SELECT currval('sequence_test'::regclass); -SELECT setval('sequence_test'::text, 32); -SELECT nextval('sequence_test'::regclass); -SELECT setval('sequence_test'::text, 99, false); -SELECT nextval('sequence_test'::regclass); -SELECT setval('sequence_test'::regclass, 32); -SELECT nextval('sequence_test'::text); -SELECT setval('sequence_test'::regclass, 99, false); -SELECT nextval('sequence_test'::text); - -DROP SEQUENCE sequence_test; - --- renaming sequences -CREATE SEQUENCE foo_seq; -ALTER TABLE foo_seq RENAME TO foo_seq_new; -SELECT * FROM foo_seq_new; -DROP SEQUENCE foo_seq_new; - --- renaming serial sequences -ALTER TABLE serialtest_f2_seq RENAME TO serialtest_f2_foo; -INSERT INTO serialTest VALUES ('more'); -SELECT * FROM serialTest ORDER BY 2; - --- --- Check dependencies of serial and ordinary sequences --- -CREATE TEMP SEQUENCE myseq2; -CREATE TEMP SEQUENCE myseq3; -CREATE TEMP TABLE t1 ( - f1 serial, - f2 int DEFAULT nextval('myseq2'), - f3 int DEFAULT nextval('myseq3'::text) -); --- Both drops should fail, but with different error messages: -DROP SEQUENCE t1_f1_seq; -DROP SEQUENCE myseq2; --- This however will work: -DROP SEQUENCE myseq3; -DROP TABLE t1; --- Fails because no longer existent: -DROP SEQUENCE t1_f1_seq; --- Now OK: -DROP SEQUENCE myseq2; - --- --- Alter sequence --- -CREATE SEQUENCE sequence_test2 START WITH 32; - -SELECT nextval('sequence_test2'); - -ALTER SEQUENCE sequence_test2 RESTART WITH 16 - INCREMENT BY 4 MAXVALUE 22 MINVALUE 5 CYCLE; -SELECT nextval('sequence_test2'); -SELECT nextval('sequence_test2'); -SELECT nextval('sequence_test2'); - -SELECT nextval(oid) FROM gp_dist_random('pg_class') WHERE relname = 'sequence_test2'; - --- Test comments --- COMMENT ON SEQUENCE asdf IS 'won''t work'; --- COMMENT ON SEQUENCE sequence_test2 IS 'will work'; --- COMMENT ON SEQUENCE sequence_test2 IS NULL; - --- Test lastval() -CREATE SEQUENCE seq; -SELECT nextval('seq'); ---SELECT lastval(); -SELECT setval('seq', 99); ---SELECT lastval(); - -CREATE SEQUENCE seq2; -SELECT nextval('seq2'); ---SELECT lastval(); - -DROP SEQUENCE seq2; --- should fail ---SELECT lastval(); - --- CREATE USER seq_user; - --- BEGIN; --- SET LOCAL SESSION AUTHORIZATION seq_user; --- CREATE SEQUENCE seq3; --- SELECT nextval('seq3'); --- REVOKE ALL ON seq3 FROM seq_user; ---SELECT lastval(); --- ROLLBACK; - --- DROP USER seq_user; -DROP SEQUENCE seq;