Changeset: d20a9b684627 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/d20a9b684627
Modified Files:
sql/test/dict/Tests/dict04.test
Branch: default
Log Message:
DICTthetaselect is still broken for <=
diffs (38 lines):
diff --git a/sql/test/dict/Tests/dict04.test b/sql/test/dict/Tests/dict04.test
--- a/sql/test/dict/Tests/dict04.test
+++ b/sql/test/dict/Tests/dict04.test
@@ -233,6 +233,34 @@ statement ok
START TRANSACTION
statement ok
+CREATE TABLE t0 (c0 INT NOT NULL)
+
+statement ok rowcount 2
+INSERT INTO t0 VALUES (1), (3)
+
+statement ok
+COMMIT
+
+statement ok
+CALL "sys"."dict_compress"('sys','t0','c0')
+
+query I nosort
+SELECT t0.c0 FROM t0 WHERE t0.c0 <= 2
+----
+1
+
+query I nosort
+SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST(t0.c0 <= 2 AS INT) as
count FROM t0) as res
+----
+1
+
+statement ok
+DROP TABLE t0
+
+statement ok
+START TRANSACTION
+
+statement ok
DROP ALL PROCEDURE "sys"."dict_compress"
statement ok
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
