Changeset: b3ae02453428 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b3ae02453428
Modified Files:
sql/test/SQLancer/Tests/sqlancer01.sql
Branch: Jun2020
Log Message:
SQLancer distinct aggregate with GDK error on group by constant
diffs (30 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer01.sql
b/sql/test/SQLancer/Tests/sqlancer01.sql
--- a/sql/test/SQLancer/Tests/sqlancer01.sql
+++ b/sql/test/SQLancer/Tests/sqlancer01.sql
@@ -94,6 +94,26 @@ select 1 from t0 where (3 in (1, 2)) is
-- empty
ROLLBACK;
+START TRANSACTION; --Bug 6897
+CREATE TABLE "t0"("c0" DECIMAL(18,3), "c1" BIGINT);
+COPY 12 RECORDS INTO "t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+0.244 NULL
+0.578 NULL
+0.119 NULL
+0.773 495026350
+0.329 2108706088
+0.483 1298757529
+0.880 39
+0.084 1
+0.332 859611948
+0.607 NULL
+0.835 0
+0.455 -1239303309
+
+SELECT MIN(DISTINCT t0.c1) FROM t0 WHERE 1 >= t0.c0 GROUP BY true;
+ -- -1239303309
+ROLLBACK;
+
DROP TABLE tbl_ProductSales;
DROP TABLE another_T;
DROP TABLE integers;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
