Changeset: dac1e48be23a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=dac1e48be23a
Modified Files:
sql/test/SQLancer/Tests/sqlancer06.sql
Branch: Oct2020
Log Message:
Simplified version of buggy query
diffs (12 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer06.sql
b/sql/test/SQLancer/Tests/sqlancer06.sql
--- a/sql/test/SQLancer/Tests/sqlancer06.sql
+++ b/sql/test/SQLancer/Tests/sqlancer06.sql
@@ -313,6 +313,8 @@ 0.713 1970-01-07
0.199 1970-01-07
0.109 1970-01-07
+SELECT count(*) FROM t1 WHERE t1.c0 <> ALL(SELECT '1' WHERE FALSE);
+ -- 40
SELECT t1.c0 FROM t1 WHERE t1.c0 <> ALL(SELECT DISTINCT
CAST(0.5646222839477373 AS INT) FROM t0, t1 WHERE (t0.c1) NOT BETWEEN
ASYMMETRIC (COALESCE(t0.c1, t0.c1)) AND (t0.c1));
-- 40 rows
SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT ALL CAST(t1.c0 <> ALL(SELECT
DISTINCT CAST(0.5646222839477373 AS INT) FROM t0, t1 WHERE (t0.c1) NOT BETWEEN
ASYMMETRIC (COALESCE(t0.c1, t0.c1)) AND (t0.c1)) AS INT) as count FROM t1) as
res;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
