Changeset: 4fdcd768c440 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4fdcd768c440
Modified Files:
sql/test/SQLancer/Tests/sqlancer03.sql
sql/test/SQLancer/Tests/sqlancer03.stable.out
Branch: Jun2020
Log Message:
Updated buggy query. It only happens after individual insert into statements
diffs (104 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer03.sql
b/sql/test/SQLancer/Tests/sqlancer03.sql
--- a/sql/test/SQLancer/Tests/sqlancer03.sql
+++ b/sql/test/SQLancer/Tests/sqlancer03.sql
@@ -160,7 +160,7 @@ insert into t0 values (default, default,
select a,b,c from t0;
ROLLBACK;
-START TRANSACTION; -- Bug 6926
+START TRANSACTION;
CREATE TABLE "sys"."t0" (
"c0" TIME,
"c1" CHARACTER LARGE OBJECT NOT NULL,
@@ -192,6 +192,28 @@ SELECT t0.c0 FROM t0 WHERE (((t0.c0)<>(t
--NULL
ROLLBACK;
+START TRANSACTION; -- Bug 6926
+CREATE TABLE t0(c0 TIME, c1 VARCHAR(1000) DEFAULT (upper(CAST((('')||(DATE
'1970-01-19')) AS VARCHAR(152)))) PRIMARY KEY UNIQUE NULL);
+INSERT INTO t0(c0, c1) VALUES(TIME '19:29:38', '');
+INSERT INTO t0(c1, c0) VALUES(CAST(TIME '06:50:34' AS VARCHAR(256)), TIME
'01:39:55');
+INSERT INTO t0(c1, c0) VALUES(CAST(0.6 AS VARCHAR(411)), TIME '22:07:22'),
('#B', TIME '05:51:00'), (((((CAST('434' AS VARCHAR(849)))||(0.4)))||(TIME
'04:05:28')), TIME '06:50:34');
+INSERT INTO t0(c1) VALUES(CAST(INTERVAL '42' SECOND AS VARCHAR(102)));
+INSERT INTO t0(c0, c1) VALUES(TIME '16:29:13', 'J'), (TIME '05:57:44',
'49䄎y_}');
+INSERT INTO t0(c1, c0) VALUES('2', TIME '07:15:50'), (CAST(TIME '16:29:13' AS
VARCHAR(1000)), TIME '03:00:56');
+INSERT INTO t0(c1) VALUES('O큑LSGAM||Z赐'), ('.n');
+INSERT INTO t0(c1, c0) VALUES('c蠷웵', TIME '04:59:13');
+INSERT INTO t0(c1) VALUES('0.0');
+INSERT INTO t0(c0, c1) VALUES(TIME '20:29:28', '-343'), (TIME '01:19:51',
'j'), (TIME '11:37:23', ((((((((CAST(DATE '1970-01-23' AS
VARCHAR(849)))||(INTERVAL '23' MONTH)))||(INTERVAL '-535'
SECOND)))||(lower((('鮥*Qß4')||(DATE '1970-01-01'))))))||(0.4)));
+INSERT INTO t0(c0, c1) VALUES(TIME '02:38:14', lower(CAST(INTERVAL '342'
SECOND AS VARCHAR(1000)))), (TIME '23:43:33', '64');
+DELETE FROM t0 WHERE ((((1 IS NOT NULL)AND(FALSE)))OR(((CAST(0.3 AS
VARCHAR(836)))<(upper(t0.c1)))));
+INSERT INTO t0(c0, c1) VALUES(TIME '20:59:23', ')TD)Dnö'), (TIME '22:09:19',
'aaJ즳#B!sJNG㡩');
+INSERT INTO t0(c0, c1) VALUES(TIME '20:02:19', CAST(0.1 AS VARCHAR(927)));
+INSERT INTO t0(c0, c1) VALUES(TIME '00:17:15', '{'), (TIME '06:51:52',
CAST(4.1230238E7 AS VARCHAR(459)));
+SELECT ALL t0.c0 FROM t0 WHERE (((t0.c0)<>(t0.c0))) IS NULL;
+ --NULL
+ --NULL
+ROLLBACK;
+
START TRANSACTION; -- Bug 6924
CREATE TABLE "sys"."t0" ("a" INTEGER, "b" INTEGER NOT NULL, CONSTRAINT
"t0_a_b_unique" UNIQUE ("a","b"));
--This copy into must succeed
diff --git a/sql/test/SQLancer/Tests/sqlancer03.stable.out
b/sql/test/SQLancer/Tests/sqlancer03.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer03.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer03.stable.out
@@ -272,6 +272,59 @@ stdout of test 'sqlancer03` in directory
[ 10:15:32, 2010-01-31, 1980-11-04 08:49:25.000000 ]
[ 10:15:32, 2010-01-31, 1980-11-04 08:49:25.000000 ]
#ROLLBACK;
+#START TRANSACTION; -- Bug 6926
+#CREATE TABLE "sys"."t0" (
+# "c0" TIME,
+# "c1" CHARACTER LARGE OBJECT NOT NULL,
+# CONSTRAINT "t0_c1_pkey" PRIMARY KEY ("c1"),
+# CONSTRAINT "t0_c1_unique" UNIQUE ("c1")
+#);
+#COPY 14 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+#19:29:38 ""
+#05:51:00 "#B"
+#NULL ".n"
+#NULL "0.0"
+#20:29:28 "-601098762"
+#20:59:23 ")TD)Dnö"
+#22:09:19 "aaJ즳#B!sJNG㡩"
+#09:10:09 "W"
+#23:43:33 "k"
+#15:43:27 "-0.0"
+#20:02:19 "0.7126186870446843"
+#05:23:53 "1498390845"
+#00:17:15 "{"
+#06:51:52 "41230238"
+[ 14 ]
+#SELECT t0.c0 FROM t0 WHERE ((t0.c0)<>(t0.c0));
+% sys.t0 # table_name
+% c0 # name
+% time # type
+% 8 # length
+#SELECT t0.c0 FROM t0 WHERE NOT (((t0.c0)<>(t0.c0)));
+% sys.t0 # table_name
+% c0 # name
+% time # type
+% 8 # length
+[ 19:29:38 ]
+[ 05:51:00 ]
+[ 20:29:28 ]
+[ 20:59:23 ]
+[ 22:09:19 ]
+[ 09:10:09 ]
+[ 23:43:33 ]
+[ 15:43:27 ]
+[ 20:02:19 ]
+[ 05:23:53 ]
+[ 00:17:15 ]
+[ 06:51:52 ]
+#SELECT t0.c0 FROM t0 WHERE (((t0.c0)<>(t0.c0))) IS NULL;
+% sys.t0 # table_name
+% c0 # name
+% time # type
+% 8 # length
+[ NULL ]
+[ NULL ]
+#ROLLBACK;
#START TRANSACTION; -- Bug 6924
#CREATE TABLE "sys"."t0" ("a" INTEGER, "b" INTEGER NOT NULL, CONSTRAINT
"t0_a_b_unique" UNIQUE ("a","b"));
#COPY 39 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
