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

Approved output


diffs (34 lines):

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
@@ -194,6 +194,30 @@ stdout of test 'sqlancer04` in directory
 % month_interval # type
 % 1 # length
 #ROLLBACK;
+#START TRANSACTION;
+#CREATE TABLE "sys"."t0" ("c0" DOUBLE,"c1" INTERVAL MONTH);
+#COPY 4 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+#NULL  1876068957
+#NULL  1798321013
+#0.8609488658910056    496732801
+#0.6220338267946794    1689393833
+[ 4    ]
+#SELECT 1 FROM t0 WHERE 'b' = COALESCE('1', CASE WHEN 2 THEN 'a' END);
+% .%2 # table_name
+% %2 # name
+% tinyint # type
+% 1 # length
+#SELECT MAX(ALL 0.47279814) FROM t0 WHERE ((r'Vቕ*2DGj!K-?')NOT 
ILIKE(COALESCE(r'뷿', upper(r'1285890467'), r'R B+ ]%''?E}%<[cöjö媘թ丅MJV%r&伉', 
+#CASE WHEN -681304440 THEN r'+s' WHEN -2104930505 THEN r'M[' END))) GROUP BY 
t0.c0, t0.c1;
+% .%1 # table_name
+% %1 # name
+% decimal # type
+% 11 # length
+[ 0.47279814   ]
+[ 0.47279814   ]
+[ 0.47279814   ]
+[ 0.47279814   ]
+#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