Changeset: ee2c89891435 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ee2c89891435
Modified Files:
sql/test/miscellaneous/Tests/groupby_error.sql
Branch: default
Log Message:
Sqlite query with wrong results
diffs (16 lines):
diff --git a/sql/test/miscellaneous/Tests/groupby_error.sql
b/sql/test/miscellaneous/Tests/groupby_error.sql
--- a/sql/test/miscellaneous/Tests/groupby_error.sql
+++ b/sql/test/miscellaneous/Tests/groupby_error.sql
@@ -173,3 +173,12 @@ SELECT DISTINCT CAST(+ - CASE + 66 WHEN
SELECT DISTINCT CAST(( + CASE WHEN NOT NULL BETWEEN NULL AND NULL THEN NULL
ELSE + COUNT ( * ) END ) AS BIGINT) AS col1;
-- 1
+
+START TRANSACTION;
+CREATE TABLE "tab0" ("col0" INTEGER,"col1" INTEGER,"col2" INTEGER);
+INSERT INTO "tab0" VALUES (83, 0, 38), (26, 0, 79), (43, 81, 24);
+SELECT CAST(COUNT ( DISTINCT + CAST ( NULL AS INTEGER ) ) + 93 as BIGINT) AS
col2 FROM tab0 GROUP BY col0 HAVING NOT ( COUNT ( * ) ) = 94 / COUNT ( * );
+ -- 93
+ -- 93
+ -- 93
+ROLLBACK;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
