Changeset: bb70473cf5b7 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=bb70473cf5b7
Modified Files:
sql/test/SQLancer/Tests/sqlancer06.sql
sql/test/SQLancer/Tests/sqlancer06.stable.err
sql/test/SQLancer/Tests/sqlancer06.stable.out
Branch: Oct2020
Log Message:
Updated test and approved output
diffs (87 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer06.sql
b/sql/test/SQLancer/Tests/sqlancer06.sql
--- a/sql/test/SQLancer/Tests/sqlancer06.sql
+++ b/sql/test/SQLancer/Tests/sqlancer06.sql
@@ -225,7 +225,7 @@ DROP TABLE t1;
DROP TABLE t2;
CREATE TABLE t0(c1 INTERVAL SECOND UNIQUE);
-DROP INDEX t0_c1_unique;
+DROP INDEX t0_c1_unique; --error, cannot drop index because of dependency to
unique key
INSERT INTO t0 VALUES (INTERVAL '2071616848' SECOND), (INTERVAL '2071616848'
SECOND); --error, unique constraint violated
DROP TABLE t0;
@@ -323,10 +323,8 @@ ROLLBACK;
START TRANSACTION;
CREATE TABLE "sys"."t0" ("c0" TIME,"c1" DECIMAL(18,3));
-COPY 3 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+COPY 1 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
05:09:43 0.122
-NULL 0.824
-NULL NULL
CREATE TABLE "sys"."t1" ("c1" DECIMAL(18,3));
COPY 2 RECORDS INTO "sys"."t1" FROM stdin USING DELIMITERS E'\t',E'\n','"';
@@ -342,5 +340,11 @@ 946154646
0.5253008674729628
select cast((t2.c0) not in ((select all 1.360204425E9 from t0), t2.c0) as int)
from t1 full outer join t2 on false;
+ --5 0s 2 NULLs
+COPY 2 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+NULL 0.824
+NULL NULL
+
+select cast((t2.c0) not in ((select all 1.360204425E9 from t0), t2.c0) as int)
from t1 full outer join t2 on false;
--error, more than one row returned by a subquery used as an expression
ROLLBACK;
diff --git a/sql/test/SQLancer/Tests/sqlancer06.stable.err
b/sql/test/SQLancer/Tests/sqlancer06.stable.err
--- a/sql/test/SQLancer/Tests/sqlancer06.stable.err
+++ b/sql/test/SQLancer/Tests/sqlancer06.stable.err
@@ -9,6 +9,14 @@ MAPI = (monetdb) /var/tmp/mtest-8009/.s
QUERY = INSERT INTO t2(c0) VALUES(CAST((CASE WHEN r'' THEN TIME '06:29:46'
WHEN r'b_P' THEN TIME '20:39:07' END) BETWEEN ASYMMETRIC (COALESCE(TIME
'11:09:56', TIME '12:05:55')) AND (COALESCE(TIME '18:59:07', TIME '04:20:04',
TIME '19:01:06')) AS STRING(638)));
ERROR = !conversion of string '' to type bit failed.
CODE = 22018
+MAPI = (monetdb) /var/tmp/mtest-304916/.s.monetdb.38271
+QUERY = DROP INDEX t0_c1_unique; --error, cannot drop index because of
dependency to unique key
+ERROR = !DROP INDEX: cannot drop index 't0_c1_unique', because the constraint
't0_c1_unique' depends on it
+CODE = 42S12
+MAPI = (monetdb) /var/tmp/mtest-304916/.s.monetdb.38271
+QUERY = INSERT INTO t0 VALUES (INTERVAL '2071616848' SECOND), (INTERVAL
'2071616848' SECOND); --error, unique constraint violated
+ERROR = !INSERT INTO: UNIQUE constraint 't0.t0_c1_unique' violated
+CODE = 40002
# 19:38:32 >
# 19:38:32 > "Done."
diff --git a/sql/test/SQLancer/Tests/sqlancer06.stable.out
b/sql/test/SQLancer/Tests/sqlancer06.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer06.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer06.stable.out
@@ -538,6 +538,29 @@ stdout of test 'sqlancer06` in directory
% 2 # length
[ 40 ]
#ROLLBACK;
+#START TRANSACTION;
+#CREATE TABLE "sys"."t0" ("c0" TIME,"c1" DECIMAL(18,3));
+#COPY 1 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+#05:09:43 0.122
+[ 1 ]
+#CREATE TABLE "sys"."t1" ("c1" DECIMAL(18,3));
+#COPY 2 RECORDS INTO "sys"."t1" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+#0.320
+#0.995
+[ 2 ]
+#CREATE TABLE "sys"."t2" ("c0" DOUBLE NOT NULL,CONSTRAINT "t2_c0_pkey" PRIMARY
KEY ("c0"),CONSTRAINT "t2_c0_unique" UNIQUE ("c0"));
+#COPY 5 RECORDS INTO "sys"."t2" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+#0.5352396631754883
+#0.4722686692942629
+#0.06898879964424565
+#946154646
+#0.5253008674729628
+[ 5 ]
+#COPY 2 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+#NULL 0.824
+#NULL NULL
+[ 2 ]
+#ROLLBACK;
# 19:38:32 >
# 19:38:32 > "Done."
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
