Changeset: 1be2855f5d97 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1be2855f5d97
Added Files:
sql/test/SQLancer/Tests/sqlancer04.stable.err
sql/test/SQLancer/Tests/sqlancer04.stable.out
Branch: Jun2020
Log Message:
Approved output
diffs (58 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer04.stable.err
b/sql/test/SQLancer/Tests/sqlancer04.stable.err
new file mode 100644
--- /dev/null
+++ b/sql/test/SQLancer/Tests/sqlancer04.stable.err
@@ -0,0 +1,12 @@
+stderr of test 'sqlancer04` in directory 'sql/test/SQLancer` itself:
+
+
+# 09:44:50 >
+# 09:44:50 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-36890" "--port=30177"
+# 09:44:50 >
+
+
+# 09:44:50 >
+# 09:44:50 > "Done."
+# 09:44:50 >
+
diff --git a/sql/test/SQLancer/Tests/sqlancer04.stable.out
b/sql/test/SQLancer/Tests/sqlancer04.stable.out
new file mode 100644
--- /dev/null
+++ b/sql/test/SQLancer/Tests/sqlancer04.stable.out
@@ -0,0 +1,36 @@
+stdout of test 'sqlancer04` in directory 'sql/test/SQLancer` itself:
+
+
+# 09:44:50 >
+# 09:44:50 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-36890" "--port=30177"
+# 09:44:50 >
+
+#START TRANSACTION;
+#CREATE TABLE "sys"."t0" ("c0" INTERVAL MONTH NOT NULL);
+#COPY 3 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+#150184010
+#332127116
+#2136089006
+[ 3 ]
+#SELECT SUM(ALL 0.12830007105673624234754015560611151158) FROM t0 WHERE
((sql_min(t0.c0, t0.c0))<>(COALESCE (t0.c0, sql_min(abs(t0.c0), nullif(t0.c0,
t0.c0))))) GROUP BY 0.1
+#HAVING MIN(ALL ((r'946496923')LIKE(CAST(nullif(0.5, 0.03) AS STRING(538)))))
+#UNION ALL SELECT SUM(ALL 0.12830007105673624234754015560611151158) FROM t0
WHERE ((sql_min(t0.c0, t0.c0))<>(COALESCE (t0.c0, sql_min(abs(t0.c0),
nullif(t0.c0, t0.c0))))) GROUP BY 0.1
+#HAVING NOT (MIN(ALL ((r'946496923')LIKE(CAST(nullif(0.5, 0.03) AS
STRING(538))))))
+% .%26 # table_name
+% %2 # name
+% double # type
+% 24 # length
+#SELECT SUM(ALL 0.12830007105673624234754015560611151158) FROM t0 WHERE
((sql_min(t0.c0, t0.c0))<>(COALESCE (t0.c0, sql_min(abs(t0.c0), nullif(t0.c0,
t0.c0))))) GROUP BY 0.1
+#HAVING MIN(ALL ((r'946496923')LIKE(CAST(nullif(0.5, 0.03) AS STRING(538)))))
+#UNION ALL SELECT SUM(ALL 0.12830007105673624234754015560611151158) FROM t0
WHERE ((sql_min(t0.c0, t0.c0))<>(COALESCE (t0.c0, sql_min(abs(t0.c0),
nullif(t0.c0, t0.c0))))) GROUP BY 0.1
+#HAVING NOT (MIN(ALL ((r'946496923')LIKE(CAST(nullif(0.5, 0.03) AS
STRING(538))))))
+% .%26 # table_name
+% %2 # name
+% double # type
+% 24 # length
+#ROLLBACK;
+
+# 09:44:50 >
+# 09:44:50 > "Done."
+# 09:44:50 >
+
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
