Changeset: 5510198b9f68 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5510198b9f68
Added Files:
sql/test/SQLancer/Tests/sqlancer05.stable.err
sql/test/SQLancer/Tests/sqlancer05.stable.out
Branch: Oct2020
Log Message:
Approved output
diffs (54 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer05.stable.err
b/sql/test/SQLancer/Tests/sqlancer05.stable.err
new file mode 100644
--- /dev/null
+++ b/sql/test/SQLancer/Tests/sqlancer05.stable.err
@@ -0,0 +1,16 @@
+stderr of test 'sqlancer05` in directory 'sql/test/SQLancer` itself:
+
+
+# 12:00:38 >
+# 12:00:38 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-282348" "--port=38779"
+# 12:00:38 >
+
+MAPI = (monetdb) /var/tmp/mtest-282348/.s.monetdb.38779
+QUERY = INSERT INTO t1(c0) VALUES(INTERVAL '1474617942' SECOND), (NULL);
+ERROR = !INSERT INTO: NOT NULL constraint violated for column t1.c0
+CODE = 40002
+
+# 12:00:38 >
+# 12:00:38 > "Done."
+# 12:00:38 >
+
diff --git a/sql/test/SQLancer/Tests/sqlancer05.stable.out
b/sql/test/SQLancer/Tests/sqlancer05.stable.out
new file mode 100644
--- /dev/null
+++ b/sql/test/SQLancer/Tests/sqlancer05.stable.out
@@ -0,0 +1,28 @@
+stdout of test 'sqlancer05` in directory 'sql/test/SQLancer` itself:
+
+
+# 12:00:38 >
+# 12:00:38 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-282348" "--port=38779"
+# 12:00:38 >
+
+#CREATE TABLE "sys"."t1" (
+# "c0" INTERVAL SECOND NOT NULL,
+# CONSTRAINT "t1_c0_pkey" PRIMARY KEY ("c0"),
+# CONSTRAINT "t1_c0_unique" UNIQUE ("c0")
+#);
+#INSERT INTO t1(c0) VALUES(INTERVAL '1427502482' SECOND), (INTERVAL
'-1598854979' SECOND);
+[ 2 ]
+#DELETE FROM t1 WHERE CASE r'FALSE' WHEN r'879628043' THEN TRUE ELSE
((((t1.c0)>=(t1.c0)))OR(((TRUE)OR(TRUE)))) END;
+[ 2 ]
+#INSERT INTO t1(c0) VALUES(INTERVAL '236620278' SECOND);
+[ 1 ]
+#INSERT INTO t1(c0) VALUES(INTERVAL '1448897349' SECOND);
+[ 1 ]
+#DELETE FROM t1 WHERE CAST(TRUE AS BOOLEAN);
+[ 2 ]
+#DROP TABLE sys.t1;
+
+# 12:00:38 >
+# 12:00:38 > "Done."
+# 12:00:38 >
+
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
