Changeset: 551c00fc1950 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=551c00fc1950
Modified Files:
sql/test/BugTracker-2019/Tests/insert-into-select.Bug-6718.sql
sql/test/BugTracker-2019/Tests/insert-into-select.Bug-6718.stable.out
Branch: Apr2019
Log Message:
Entended test with showing table descriptions and using CREATE TABLE AS SELECT
... alternative.
diffs (127 lines):
diff --git a/sql/test/BugTracker-2019/Tests/insert-into-select.Bug-6718.sql
b/sql/test/BugTracker-2019/Tests/insert-into-select.Bug-6718.sql
--- a/sql/test/BugTracker-2019/Tests/insert-into-select.Bug-6718.sql
+++ b/sql/test/BugTracker-2019/Tests/insert-into-select.Bug-6718.sql
@@ -4,6 +4,8 @@ order_id INTEGER NOT NULL,
qnt INTEGER NOT NULL
);
+\d test2
+
COPY 5 RECORDS INTO test2 FROM stdin USING DELIMITERS '|','\n';
1|32|57
2|15|105
@@ -14,6 +16,7 @@ 5|67|134
SELECT * FROM test2;
+
CREATE TABLE test1 (
id INTEGER NOT NULL,
qnt INTEGER,
@@ -23,6 +26,8 @@ CONSTRAINT pk_order_number FOREIGN KEY (
test2("order_number")
);
+\d test1
+
SELECT test2.order_id,
test2.qnt, test2.order_number from test2;
@@ -31,6 +36,23 @@ test2.qnt, test2.order_number from test2
SELECT * FROM test1;
+
+CREATE TABLE test3 (id, qnt, order_number) AS SELECT test2.order_id,
+test2.qnt, test2.order_number from test2;
+
+\d test3
+
+SELECT * FROM test3;
+
+ALTER TABLE test3 ALTER id SET NOT NULL;
+ALTER TABLE test3 ALTER order_number SET NOT NULL;
+ALTER TABLE test3 ADD CONSTRAINT pk_test3_id PRIMARY KEY ("id", "qnt");
+ALTER TABLE test3 ADD CONSTRAINT fk_order_number FOREIGN KEY ("order_number")
REFERENCES
+test2("order_number");
+
+\d test3
+
+DROP TABLE test3;
DROP TABLE test1;
DROP TABLE test2;
diff --git
a/sql/test/BugTracker-2019/Tests/insert-into-select.Bug-6718.stable.out
b/sql/test/BugTracker-2019/Tests/insert-into-select.Bug-6718.stable.out
--- a/sql/test/BugTracker-2019/Tests/insert-into-select.Bug-6718.stable.out
+++ b/sql/test/BugTracker-2019/Tests/insert-into-select.Bug-6718.stable.out
@@ -29,6 +29,12 @@ Ready.
#order_id INTEGER NOT NULL,
#qnt INTEGER NOT NULL
#);
+CREATE TABLE "sys"."test2" (
+ "order_number" INTEGER NOT NULL DEFAULT next value for
"sys"."seq_8973",
+ "order_id" INTEGER NOT NULL,
+ "qnt" INTEGER NOT NULL,
+ CONSTRAINT "test2_order_number_pkey" PRIMARY KEY ("order_number")
+);
#COPY 5 RECORDS INTO test2 FROM stdin USING DELIMITERS '|','\n';
#1|32|57
#2|15|105
@@ -54,6 +60,13 @@ Ready.
#CONSTRAINT pk_order_number FOREIGN KEY ("order_number") REFERENCES
#test2("order_number")
#);
+CREATE TABLE "sys"."test1" (
+ "id" INTEGER NOT NULL,
+ "qnt" INTEGER NOT NULL,
+ "order_number" INTEGER NOT NULL,
+ CONSTRAINT "pk_test1_id" PRIMARY KEY ("id", "qnt"),
+ CONSTRAINT "pk_order_number" FOREIGN KEY ("order_number") REFERENCES
"sys"."test2" ("order_number")
+);
#SELECT test2.order_id,
#test2.qnt, test2.order_number from test2;
% sys.test2, sys.test2, sys.test2 # table_name
@@ -72,12 +85,42 @@ Ready.
% sys.test1, sys.test1, sys.test1 # table_name
% id, qnt, order_number # name
% int, int, int # type
-% 1, 1, 1 # length
+% 2, 3, 1 # length
[ 32, 57, 1 ]
[ 15, 105, 2 ]
[ 33, 0, 3 ]
[ 57, 20, 4 ]
[ 67, 134, 5 ]
+#CREATE TABLE test3 (id, qnt, order_number) AS SELECT test2.order_id,
+#test2.qnt, test2.order_number from test2;
+CREATE TABLE "sys"."test3" (
+ "id" INTEGER,
+ "qnt" INTEGER,
+ "order_number" INTEGER
+);
+#SELECT * FROM test3;
+% sys.test3, sys.test3, sys.test3 # table_name
+% id, qnt, order_number # name
+% int, int, int # type
+% 2, 3, 1 # length
+[ 32, 57, 1 ]
+[ 15, 105, 2 ]
+[ 33, 0, 3 ]
+[ 57, 20, 4 ]
+[ 67, 134, 5 ]
+#ALTER TABLE test3 ALTER id SET NOT NULL;
+#ALTER TABLE test3 ALTER order_number SET NOT NULL;
+#ALTER TABLE test3 ADD CONSTRAINT pk_test3_id PRIMARY KEY ("id", "qnt");
+#ALTER TABLE test3 ADD CONSTRAINT fk_order_number FOREIGN KEY ("order_number")
REFERENCES
+#test2("order_number");
+CREATE TABLE "sys"."test3" (
+ "id" INTEGER NOT NULL,
+ "qnt" INTEGER NOT NULL,
+ "order_number" INTEGER NOT NULL,
+ CONSTRAINT "pk_test3_id" PRIMARY KEY ("id", "qnt"),
+ CONSTRAINT "fk_order_number" FOREIGN KEY ("order_number") REFERENCES
"sys"."test2" ("order_number")
+);
+#DROP TABLE test3;
#DROP TABLE test1;
#DROP TABLE test2;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
