Changeset: 36737af01678 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=36737af01678
Modified Files:
sql/test/SQLancer/Tests/sqlancer04.stable.err
sql/test/SQLancer/Tests/sqlancer04.stable.out
sql/test/SQLancer/Tests/sqlancer11.sql
sql/test/SQLancer/Tests/sqlancer11.stable.err
sql/test/SQLancer/Tests/sqlancer11.stable.out
Branch: Oct2020
Log Message:
Approved output
diffs (81 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer04.stable.err
b/sql/test/SQLancer/Tests/sqlancer04.stable.err
--- a/sql/test/SQLancer/Tests/sqlancer04.stable.err
+++ b/sql/test/SQLancer/Tests/sqlancer04.stable.err
@@ -59,6 +59,10 @@ MAPI = (monetdb) /var/tmp/mtest-150622/
QUERY = select cast(count(1) as interval second) from (values (false)) as
v6(vc0); --error
ERROR = !types bigint(64,0) and sec_interval(13,0) are not equal
CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-363537/.s.monetdb.32129
+QUERY = UPDATE t1 SET c1 = 0 WHERE t1.c1 > 3;
+ERROR = !UPDATE: PRIMARY KEY constraint 't1.t1_c0_c1_pkey' violated
+CODE = 40002
# 09:44:50 >
# 09:44:50 > "Done."
diff --git a/sql/test/SQLancer/Tests/sqlancer04.stable.out
b/sql/test/SQLancer/Tests/sqlancer04.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer04.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer04.stable.out
@@ -534,6 +534,13 @@ stdout of test 'sqlancer04` in directory
% 1 # length
[ 2 ]
#ROLLBACK;
+#CREATE TABLE t1(c0 BOOLEAN, c1 DOUBLE);
+#ALTER TABLE t1 ADD PRIMARY KEY(c0, c1);
+#INSERT INTO t1(c1, c0) VALUES(0.3, FALSE), (0.5, true), (0.0, true), (4,
false), (1, true), (4, true);
+[ 6 ]
+#DELETE FROM t1 WHERE NOT t1.c0;
+[ 2 ]
+#DROP TABLE t1;
# 09:44:50 >
# 09:44:50 > "Done."
diff --git a/sql/test/SQLancer/Tests/sqlancer11.sql
b/sql/test/SQLancer/Tests/sqlancer11.sql
--- a/sql/test/SQLancer/Tests/sqlancer11.sql
+++ b/sql/test/SQLancer/Tests/sqlancer11.sql
@@ -4,7 +4,6 @@ INSERT INTO t1(c0) VALUES(2), (+ ((VALUE
SELECT * from t1;
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','"';
@@ -20,4 +19,5 @@ CREATE TABLE "sys"."t1" ("c0" CHAR(375)
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;
+DROP TABLE t1;
+DROP TABLE t0;
diff --git a/sql/test/SQLancer/Tests/sqlancer11.stable.err
b/sql/test/SQLancer/Tests/sqlancer11.stable.err
--- a/sql/test/SQLancer/Tests/sqlancer11.stable.err
+++ b/sql/test/SQLancer/Tests/sqlancer11.stable.err
@@ -1,10 +1,18 @@
-stderr of test 'sqlancer10` in directory 'sql/test/SQLancer` itself:
+stderr of test 'sqlancer11` 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 >
+MAPI = (monetdb) /var/tmp/mtest-364410/.s.monetdb.32318
+QUERY = insert into t1(c0) values ((select 'a')), ('b');
+ERROR = !INSERT INTO: FOREIGN KEY constraint 't1.t1_c0_fkey' violated
+CODE = 40002
+MAPI = (monetdb) /var/tmp/mtest-364410/.s.monetdb.32318
+QUERY = insert into t1(c0) values(r']BW扗}FUp'), (cast((values (greatest(r'Aᨐ',
r'_'))) as string(616))), (r'');
+ERROR = !INSERT INTO: PRIMARY KEY constraint 't1.t1_c0_pkey' violated
+CODE = 40002
# 13:59:46 >
# 13:59:46 > "Done."
diff --git a/sql/test/SQLancer/Tests/sqlancer11.stable.out
b/sql/test/SQLancer/Tests/sqlancer11.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer11.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer11.stable.out
@@ -1,4 +1,4 @@
-stdout of test 'sqlancer10` in directory 'sql/test/SQLancer` itself:
+stdout of test 'sqlancer11` in directory 'sql/test/SQLancer` itself:
# 13:59:46 >
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
