Changeset: 35a598a9e320 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=35a598a9e320
Modified Files:
sql/test/SQLancer/Tests/sqlancer05.stable.out
Branch: Oct2020
Log Message:
Approved output
diffs (96 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
@@ -358,6 +358,92 @@ stdout of test 'sqlancer05` in directory
#DELETE FROM t1 WHERE t1.c1;
[ 6 ]
#DROP TABLE "sys"."t1";
+#START TRANSACTION;
+#CREATE TABLE "sys"."t0" ("c0" DATE NOT NULL,CONSTRAINT "t0_c0_pkey" PRIMARY
KEY ("c0"),CONSTRAINT "t0_c0_unique" UNIQUE ("c0"));
+#COPY 4 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+#1970-01-10
+#1970-01-08
+#1970-01-11
+#1970-01-04
+[ 4 ]
+#CREATE TABLE "sys"."t1" ("c0" BIGINT NOT NULL,"c1" BOOLEAN,CONSTRAINT
"t1_c0_pkey" PRIMARY KEY ("c0"));
+#COPY 36 RECORDS INTO "sys"."t1" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+#23 false
+#24 false
+#25 false
+#229738198 NULL
+#1819118647 NULL
+#26 false
+#2058744872 NULL
+#-168288931 NULL
+#166463833 NULL
+#-255018368 NULL
+#27 false
+#-233859923 false
+#77211519 NULL
+#28 false
+#159399657 NULL
+#29 false
+#2026785942 NULL
+#-418264598 NULL
+#1594290070 NULL
+#2030525887 NULL
+#-841582890 NULL
+#1837616768 NULL
+#-6844300 NULL
+#-950410411 false
+#30 false
+#-487156028 false
+#2127505141 NULL
+#-3355985 false
+#31 false
+#32 false
+#-20002400 NULL
+#658423972 NULL
+[ 36 ]
+#CREATE TABLE "sys"."t2" ("c0" DATE NOT NULL);
+#COPY 26 RECORDS INTO "sys"."t2" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+#1970-01-25
+#1970-01-04
+#1970-01-07
+#1970-01-02
+#1970-01-21
+#1970-01-22
+#1970-01-01
+#1970-01-12
+#1970-01-21
+#1970-01-04
+#1970-01-12
+#1970-01-21
+#1970-01-10
+#1970-01-18
+#1970-01-24
+#1970-01-03
+#1970-01-10
+#1970-01-11
+#1970-01-01
+#1970-01-08
+#1970-01-01
+#1970-01-11
+#1970-01-23
+#1970-01-07
+#1970-01-02
+#1970-01-23
+[ 26 ]
+#SELECT t1.c1 FROM t1, t2 NATURAL JOIN t0 WHERE (CAST((TIME '15:03:17') NOT IN
(TIME '11:36:59', TIME '21:14:10',
+#TIME '01:03:49') AS INT)) BETWEEN ASYMMETRIC (t1.c0) AND (t1.c0);
+% sys.t1 # table_name
+% c1 # name
+% boolean # type
+% 5 # length
+#SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST((CAST((TIME '15:03:17')
NOT IN (TIME '11:36:59', TIME '21:14:10',
+#TIME '01:03:49') AS INT)) BETWEEN ASYMMETRIC (t1.c0) AND (t1.c0) AS INT) as
count FROM t1, t2 NATURAL JOIN t0) as res;
+% .%12 # table_name
+% %12 # name
+% bigint # type
+% 1 # length
+[ 0 ]
+#ROLLBACK;
# 12:00:38 >
# 12:00:38 > "Done."
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
