MonetDB: default - Approved output

Fri, 31 Jul 2020 00:19:14 -0700 

Changeset: eac9d0e8c199 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=eac9d0e8c199
Modified Files:
        sql/test/SQLancer/Tests/sqlancer04.sql
        sql/test/SQLancer/Tests/sqlancer04.stable.out
Branch: default
Log Message:

Approved output


diffs (96 lines):

diff --git a/sql/test/SQLancer/Tests/sqlancer04.sql 
b/sql/test/SQLancer/Tests/sqlancer04.sql
--- a/sql/test/SQLancer/Tests/sqlancer04.sql
+++ b/sql/test/SQLancer/Tests/sqlancer04.sql
@@ -115,6 +115,8 @@ 0.6820837154477003  "8C7_7\015\015(wntWql
 NULL   "]"
 NULL   "0.48396026646393187"
 
+SELECT CAST(SUM(ALL 0.14) AS DECIMAL(10,2)) FROM sys.t0 JOIN sys.t1 ON 
CAST(CASE t0.c1 WHEN t1.c1 THEN NOT (FALSE) WHEN t1.c1 THEN (t0.c0) NOT  
BETWEEN ASYMMETRIC (t1.c0) AND (t0.c0) WHEN t0.c1 
+THEN (0.2) IN (0.3) END AS BOOLEAN) GROUP BY NOT (FALSE), 
COALESCE(((COALESCE(2, 4, 1))<<(COALESCE(5, -6))), ((COALESCE('-8', -4, 
6))|(COALESCE(-2, 3, 4, 5, -6))));
 SELECT PROD(ALL 0.14) FROM t0 JOIN t1 ON CAST(CASE t0.c1 WHEN t1.c1 THEN NOT 
(FALSE) WHEN t1.c1 THEN (t0.c0) NOT  BETWEEN ASYMMETRIC (t1.c0) AND (t0.c0) 
WHEN t0.c1 
 THEN (0.2) IN (0.3) END AS BOOLEAN) GROUP BY NOT (FALSE), 
COALESCE(((COALESCE(2, 4, 1))<<(COALESCE(5, -6))), ((COALESCE(r'-8', -4, 
6))|(COALESCE(-2, 3, 4, 5, -6))));
 ROLLBACK;
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
@@ -43,11 +43,80 @@ stdout of test 'sqlancer04` in directory
 #"-2044926527" NULL
 #NULL  1
 [ 3    ]
+#SELECT 1 FROM t1 LEFT OUTER JOIN t0 ON TRUE 
+#LEFT OUTER JOIN (SELECT 1 FROM t0) AS sub0 ON TRUE 
+#WHERE (TIME '00:25:07') IN (TIME '07:29:34', CASE 2 WHEN 2 THEN TIME 
'17:23:46' ELSE TIME '05:14:30' END);
+% .%21 # table_name
+% %21 # name
+% tinyint # type
+% 1 # length
+#SELECT 1 FROM t1 LEFT OUTER JOIN t0 ON TRUE 
+#LEFT OUTER JOIN (SELECT 1 FROM t0) AS sub0 ON TRUE 
+#WHERE t0.c0 <= t0.c0 AND (TIME '00:25:07') IN (TIME '07:29:34', CASE 2 WHEN 2 
THEN TIME '17:23:46' ELSE TIME '05:14:30' END);
+% .%21 # table_name
+% %21 # name
+% tinyint # type
+% 1 # length
+#SELECT ALL COUNT(TIME '06:32:50') FROM t1 LEFT OUTER JOIN t0 ON TRUE 
+#LEFT OUTER JOIN (SELECT t1.c1, t0.c1, 0.43 FROM t0, t1) AS sub0 ON TRUE 
+#WHERE ((NOT ((TIME '00:25:07') IN (TIME '07:29:34', TIME '05:21:58', CASE 
0.54 WHEN 0.65 THEN TIME '17:23:46' ELSE TIME '05:14:30' END)))) 
+#GROUP BY TIMESTAMP '1969-12-08 01:47:58';
+% .%13 # table_name
+% %13 # name
+% bigint # type
+% 1 # length
+[ 3    ]
 #ROLLBACK;
 #CREATE TABLE t0(c0 TIME, UNIQUE(c0));
 #DROP TABLE t0;
 #CREATE TABLE t0(c0 INTERVAL SECOND, UNIQUE(c0));
 #DROP TABLE t0;
+#START TRANSACTION;
+#CREATE TABLE "sys"."t0" ("c0" DOUBLE NOT NULL,CONSTRAINT "t0_c0_pkey" PRIMARY 
KEY ("c0"));
+#CREATE TABLE "sys"."t1" ("c0" DOUBLE);
+#create view v1(c0, c1) as (select distinct 
(((t0.c0)=(((1357695262)^(-922564194))))) = false, cast(coalesce(coalesce(0.3, 
0.4), "second"(timestamp '1970-01-10 11:54:13')) as double) from t0);
+#create view v2(c0) as (select distinct coalesce(abs(interval '-1976292283' 
month), cast(greatest(r'Dnwxjm4btQ9cp&\c''a_', r'(y7,{q?][NHU,') as interval 
month)) from t1, t0 where ((upper(r''))not ilike(lower(r'''wAg_ z 
''PPxXßgrd⍮G'))));
+#ROLLBACK;
+#START TRANSACTION;
+#CREATE TABLE "sys"."t0" ("c0" DOUBLE NOT NULL DEFAULT 0.7383512, "c1" 
VARCHAR(277),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','"';
+#0.1982342084128137    ""
+#0.0705861623402474    NULL
+#0.7383512     "0.7547346625402616"
+#0.1405589229429235    NULL
+#0.7259117208346431    NULL
+#0.9832712376311843    NULL
+#0.03311829699079161   "'X狆l[%Lt]ulp!9nR)"
+[ 7    ]
+#CREATE TABLE "sys"."t1" ("c0" DOUBLE,"c1" VARCHAR(277));
+#COPY 11 RECORDS INTO "sys"."t1" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+#1839750227    ""
+#0.4660818799383487    "l*+>⡪kF*bRp薓ßtP| P!-?54JIT"
+#0.98293459381004      "X웨e_灰u8y"
+#NULL  "2B_"
+#NULL  "9"
+#NULL  ""
+#NULL  ""
+#0.18404121429597398   NULL
+#0.6820837154477003    "8C7_7\015\015(wntWql j\n9"
+#NULL  "]"
+#NULL  "0.48396026646393187"
+[ 11   ]
+#SELECT CAST(SUM(ALL 0.14) AS DECIMAL(10,2)) FROM sys.t0 JOIN sys.t1 ON 
CAST(CASE t0.c1 WHEN t1.c1 THEN NOT (FALSE) WHEN t1.c1 THEN (t0.c0) NOT  
BETWEEN ASYMMETRIC (t1.c0) AND (t0.c0) WHEN t0.c1 
+#THEN (0.2) IN (0.3) END AS BOOLEAN) GROUP BY NOT (FALSE), 
COALESCE(((COALESCE(2, 4, 1))<<(COALESCE(5, -6))), ((COALESCE('-8', -4, 
6))|(COALESCE(-2, 3, 4, 5, -6))));
+% .%10 # table_name
+% %10 # name
+% decimal # type
+% 12 # length
+[ 0.42 ]
+#SELECT PROD(ALL 0.14) FROM t0 JOIN t1 ON CAST(CASE t0.c1 WHEN t1.c1 THEN NOT 
(FALSE) WHEN t1.c1 THEN (t0.c0) NOT  BETWEEN ASYMMETRIC (t1.c0) AND (t0.c0) 
WHEN t0.c1 
+#THEN (0.2) IN (0.3) END AS BOOLEAN) GROUP BY NOT (FALSE), 
COALESCE(((COALESCE(2, 4, 1))<<(COALESCE(5, -6))), ((COALESCE(r'-8', -4, 
6))|(COALESCE(-2, 3, 4, 5, -6))));
+% .%7 # table_name
+% %7 # name
+% double # type
+% 24 # length
+[ 0.002744     ]
+#ROLLBACK;
 
 # 09:44:50 >  
 # 09:44:50 >  "Done."
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to