MonetDB: Jun2020 - Updated buggy query. It only happens after in...

[Pedro Ferreira]

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큑LSGAM||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
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list