Changeset: 9db3e9eef416 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9db3e9eef416
Modified Files:
sql/test/SQLancer/Tests/sqlancer05.stable.out
Branch: Oct2020
Log Message:
Approved output
diffs (95 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer05.stable.out
b/sql/test/SQLancer/Tests/sqlancer05.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer05.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer05.stable.out
@@ -21,6 +21,91 @@ stdout of test 'sqlancer05` in directory
#DELETE FROM t1 WHERE CAST(TRUE AS BOOLEAN);
[ 2 ]
#DROP TABLE sys.t1;
+#START TRANSACTION;
+#CREATE TABLE "sys"."t0" ("c0" TIMESTAMP,"c1" INTERVAL MONTH,CONSTRAINT
"t0_c1_unique" UNIQUE ("c1"));
+#CREATE TABLE "sys"."t1" ("c0" BOOLEAN, "c1" DECIMAL(18,3) NOT NULL);
+#COPY 9 RECORDS INTO "sys"."t1" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+#NULL 0.526
+#true 0.259
+#true 0.382
+#NULL 0.994
+#NULL 0.101
+#NULL 0.713
+#NULL 0.433
+#NULL 0.899
+#NULL 0.239
+[ 9 ]
+#CREATE TABLE "sys"."t2" ("c0" BOOLEAN, "c1" DECIMAL(18,3));
+#COPY 3 RECORDS INTO "sys"."t2" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+#NULL 0.692
+#NULL 0.860
+#NULL 0.230
+[ 3 ]
+#SELECT max(t2.c1) FROM t1 LEFT OUTER JOIN t2 ON CASE WHEN t2.c0 < t1.c0 OR
t1.c0 THEN t1.c0 WHEN t1.c0 THEN t1.c0 END;
+% .%3 # table_name
+% %3 # name
+% decimal # type
+% 20 # length
+[ 0.860 ]
+#create view v0(c0) as (select all 7.948668E7 from t1) with check option;
+#SELECT max(t2.c1) FROM t0, t1 CROSS JOIN v0 LEFT OUTER JOIN t2
+#ON CASE WHEN
((((((((v0.c0)=(v0.c0)))OR(((t1.c0)>=(t1.c0)))))AND(((t2.c0)<(t1.c0)))))OR(((((t1.c0)AND(t1.c0)))AND(t1.c0))))
+#THEN t1.c0 WHEN COALESCE(COALESCE(TRUE, t2.c0, t1.c0), CASE t1.c1 WHEN t2.c1
THEN t2.c0 WHEN t1.c1 THEN t2.c0 ELSE t1.c0 END)
+#THEN t2.c0 WHEN t1.c0 THEN t1.c0 END;
+% .%5 # table_name
+% %5 # name
+% decimal # type
+% 20 # length
+[ NULL ]
+#rollback;
+#START TRANSACTION;
+#CREATE TABLE t0("c1" INTEGER NOT NULL,CONSTRAINT "t0_c1_pkey" PRIMARY KEY
("c1"),CONSTRAINT "t0_c1_unique" UNIQUE ("c1"));
+#COPY 8 RECORDS INTO t0 FROM stdin USING DELIMITERS E'\t',E'\n','"';
+#262015489
+#-1667887296
+#1410307212
+#1073218199
+#-167204307
+#1394786866
+#1112194034
+#2140251980
+[ 8 ]
+#SELECT 1 FROM (select time '12:43:09' from t0) as v0(c0) RIGHT OUTER JOIN
(SELECT INTERVAL '2' SECOND FROM t0) AS sub0 ON
+#TIME '07:04:19' BETWEEN CASE 'b' WHEN 'a' THEN v0.c0 ELSE v0.c0 END AND v0.c0;
+% .%7 # table_name
+% %7 # name
+% tinyint # type
+% 1 # length
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+#create view v0(c0, c1) as (select all time '12:43:09', interval '1251003346'
second from t0) with check option;
+#SELECT count(ALL - (CAST(NULL AS INT))) FROM v0 RIGHT OUTER JOIN (SELECT
INTERVAL '1380374779' SECOND FROM t0) AS sub0 ON
+#COALESCE(TRUE, (TIME '07:04:19') BETWEEN SYMMETRIC (CASE r'漈' WHEN r'T㊆ßwU.H'
THEN v0.c0 ELSE v0.c0 END) AND (v0.c0));
+% .%4 # table_name
+% %4 # name
+% bigint # type
+% 1 # length
+[ 0 ]
+#rollback;
+#START TRANSACTION;
+#CREATE TABLE "sys"."t2" (
+# "c0" BOOLEAN,
+# "c1" DOUBLE NOT NULL,
+# CONSTRAINT "t2_c1_pkey" PRIMARY KEY ("c1"),
+# CONSTRAINT "t2_c0_c1_unique" UNIQUE ("c0", "c1")
+#);
+#COPY 3 RECORDS INTO "sys"."t2" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+#NULL 0.385788843525793
+#true 0.6696036757274413
+#false 0.3589261452091549
+[ 3 ]
+#ROLLBACK;
# 12:00:38 >
# 12:00:38 > "Done."
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
