Changeset: 641cbcf493e7 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=641cbcf493e7
Modified Files:
sql/test/SQLancer/Tests/sqlancer02.sql
Branch: default
Log Message:
New SQLancer bug: BATproject2: does not match always
diffs (18 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer02.sql
b/sql/test/SQLancer/Tests/sqlancer02.sql
--- a/sql/test/SQLancer/Tests/sqlancer02.sql
+++ b/sql/test/SQLancer/Tests/sqlancer02.sql
@@ -165,3 +165,14 @@ UNION ALL
SELECT sum(- (((((abs(2))*("quarter"(DATE '1970-01-25'))))<<("minute"(INTERVAL
'1279040638' SECOND))))) as agg0 FROM t0 FULL OUTER JOIN (SELECT
greatest(least(INTERVAL '-33334168' SECOND, INTERVAL '41947202' SECOND),
greatest(INTERVAL '1134741726' SECOND, INTERVAL '1713690410' SECOND)), t0.c0
FROM t0 WHERE t0.c0) AS sub0 ON t0.c0 WHERE (t0.c0) IS NULL
) as asdf;
ROLLBACK;
+
+START TRANSACTION;
+CREATE TABLE "sys"."t0" ("c0" BOOLEAN NOT NULL,CONSTRAINT "t0_c0_pkey" PRIMARY
KEY ("c0"));
+COPY 2 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+true
+false
+
+SELECT sum(CASE 0.84864913922764240172824656838201917707920074462890625 WHEN
0.26932793764126483626597519105416722595691680908203125 THEN INTERVAL '6' MONTH
+WHEN 0.82674200362462446634026491665281355381011962890625 THEN INTERVAL '1'
MONTH WHEN 0.16258430860651318372589457794674672186374664306640625 THEN
INTERVAL '5' MONTH
+WHEN 0.94891882487575707205706976310466416180133819580078125 THEN INTERVAL '8'
MONTH WHEN 0.74703252230588967908175845877849496901035308837890625 THEN
INTERVAL '1' MONTH END) FROM t0;
+ROLLBACK;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
