Changeset: cfc3e94c5961 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=cfc3e94c5961
Added Files:
sql/test/SQLancer/Tests/sqlancer10.sql
sql/test/SQLancer/Tests/sqlancer10.stable.err
sql/test/SQLancer/Tests/sqlancer10.stable.out
Modified Files:
sql/test/SQLancer/Tests/All
sql/test/SQLancer/Tests/sqlancer09.sql
Branch: Oct2020
Log Message:
Move crashing subquery into a new test
diffs (108 lines):
diff --git a/sql/test/SQLancer/Tests/All b/sql/test/SQLancer/Tests/All
--- a/sql/test/SQLancer/Tests/All
+++ b/sql/test/SQLancer/Tests/All
@@ -7,3 +7,4 @@ sqlancer06
sqlancer07
sqlancer08
sqlancer09
+sqlancer10
diff --git a/sql/test/SQLancer/Tests/sqlancer09.sql
b/sql/test/SQLancer/Tests/sqlancer09.sql
--- a/sql/test/SQLancer/Tests/sqlancer09.sql
+++ b/sql/test/SQLancer/Tests/sqlancer09.sql
@@ -56,24 +56,6 @@ nullif(timestamp '1970-01-20 08:57:27',
ROLLBACK;
START TRANSACTION;
-CREATE TABLE "sys"."t0" ("c0" TIME NOT NULL, "c1" VARCHAR(143),
- CONSTRAINT "t0_c0_pkey" PRIMARY KEY ("c0"), CONSTRAINT "t0_c0_unique"
UNIQUE ("c0"), CONSTRAINT "t0_c1_unique" UNIQUE ("c1"));
-COPY 7 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
-21:19:08 ""
-13:02:49 NULL
-01:02:11 NULL
-16:34:25 NULL
-12:11:43 NULL
-10:35:38 NULL
-04:26:50 NULL
-
-CREATE TABLE "sys"."t1" ("c0" CHAR(375) NOT NULL, CONSTRAINT "t1_c0_pkey"
PRIMARY KEY ("c0"), CONSTRAINT "t1_c0_fkey" FOREIGN KEY ("c0") REFERENCES
"sys"."t0" ("c1"));
---insert into t1 values ('');
---insert into t1(c0) values ((select 'a')), ('b');
---insert into t1(c0) values(r']BW扗}FUp'), (cast((values (greatest(r'Aᨐ',
r'_'))) as string(616))), (r'');
-ROLLBACK;
-
-START TRANSACTION;
CREATE TABLE "sys"."t1" ("c0" BIGINT);
COPY 4 RECORDS INTO "sys"."t1" FROM stdin USING DELIMITERS E'\t',E'\n','"';
1096730569
diff --git a/sql/test/SQLancer/Tests/sqlancer10.sql
b/sql/test/SQLancer/Tests/sqlancer10.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/SQLancer/Tests/sqlancer10.sql
@@ -0,0 +1,17 @@
+START TRANSACTION;
+CREATE TABLE "sys"."t0" ("c0" TIME NOT NULL, "c1" VARCHAR(143),
+ CONSTRAINT "t0_c0_pkey" PRIMARY KEY ("c0"), CONSTRAINT "t0_c0_unique"
UNIQUE ("c0"), CONSTRAINT "t0_c1_unique" UNIQUE ("c1"));
+COPY 7 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+21:19:08 ""
+13:02:49 NULL
+01:02:11 NULL
+16:34:25 NULL
+12:11:43 NULL
+10:35:38 NULL
+04:26:50 NULL
+
+CREATE TABLE "sys"."t1" ("c0" CHAR(375) NOT NULL, CONSTRAINT "t1_c0_pkey"
PRIMARY KEY ("c0"), CONSTRAINT "t1_c0_fkey" FOREIGN KEY ("c0") REFERENCES
"sys"."t0" ("c1"));
+insert into t1 values ('');
+insert into t1(c0) values ((select 'a')), ('b');
+insert into t1(c0) values(r']BW扗}FUp'), (cast((values (greatest(r'Aᨐ', r'_')))
as string(616))), (r'');
+ROLLBACK;
diff --git a/sql/test/SQLancer/Tests/sqlancer10.stable.err
b/sql/test/SQLancer/Tests/sqlancer10.stable.err
new file mode 100644
--- /dev/null
+++ b/sql/test/SQLancer/Tests/sqlancer10.stable.err
@@ -0,0 +1,12 @@
+stderr of test 'sqlancer10` in directory 'sql/test/SQLancer` itself:
+
+
+# 13:59:46 >
+# 13:59:46 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-215607" "--port=30526"
+# 13:59:46 >
+
+
+# 13:59:46 >
+# 13:59:46 > "Done."
+# 13:59:46 >
+
diff --git a/sql/test/SQLancer/Tests/sqlancer10.stable.out
b/sql/test/SQLancer/Tests/sqlancer10.stable.out
new file mode 100644
--- /dev/null
+++ b/sql/test/SQLancer/Tests/sqlancer10.stable.out
@@ -0,0 +1,28 @@
+stdout of test 'sqlancer10` in directory 'sql/test/SQLancer` itself:
+
+
+# 13:59:46 >
+# 13:59:46 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-215607" "--port=30526"
+# 13:59:46 >
+
+#START TRANSACTION;
+#CREATE TABLE "sys"."t0" ("c0" TIME NOT NULL, "c1" VARCHAR(143),
+# CONSTRAINT "t0_c0_pkey" PRIMARY KEY ("c0"), CONSTRAINT "t0_c0_unique"
UNIQUE ("c0"), CONSTRAINT "t0_c1_unique" UNIQUE ("c1"));
+#COPY 7 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+#21:19:08 ""
+#13:02:49 NULL
+#01:02:11 NULL
+#16:34:25 NULL
+#12:11:43 NULL
+#10:35:38 NULL
+#04:26:50 NULL
+[ 7 ]
+#CREATE TABLE "sys"."t1" ("c0" CHAR(375) NOT NULL, CONSTRAINT "t1_c0_pkey"
PRIMARY KEY ("c0"), CONSTRAINT "t1_c0_fkey" FOREIGN KEY ("c0") REFERENCES
"sys"."t0" ("c1"));
+#insert into t1 values ('');
+[ 1 ]
+#ROLLBACK;
+
+# 13:59:46 >
+# 13:59:46 > "Done."
+# 13:59:46 >
+
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
