[prev in list] [next in list] [prev in thread] [next in thread] 

List:       monetdb-checkins
Subject:    MonetDB: Dec2023 - Add tests for issues 7447 and 7448.
From:       Martin van Dinther via checkin-list <checkin-list () monetdb ! org>
Date:       2024-01-25 15:02:30
Message-ID: hg.2aeb8a1150cc.1706194950.5576048319855865965 () dev ! monetdb ! org
[Download RAW message or body]

Changeset: 2aeb8a1150cc for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/2aeb8a1150cc
Added Files:
	sql/test/BugTracker-2024/Tests/where-cond-issue-7447.test
	sql/test/BugTracker-2024/Tests/where-cond-issue-7448.test
Modified Files:
	sql/test/BugTracker-2024/Tests/All
Branch: Dec2023
Log Message:

Add tests for issues 7447 and 7448.


diffs (79 lines):

diff --git a/sql/test/BugTracker-2024/Tests/All b/sql/test/BugTracker-2024/Tests/All
--- a/sql/test/BugTracker-2024/Tests/All
+++ b/sql/test/BugTracker-2024/Tests/All
@@ -16,3 +16,5 @@ is-col-uniq-crash-7441
 unaligned_mats-7442
 recursive-merge-table-crash-7443
 greatest-as-colname-7444
+where-cond-issue-7447
+where-cond-issue-7448
diff --git a/sql/test/BugTracker-2024/Tests/where-cond-issue-7447.test \
b/sql/test/BugTracker-2024/Tests/where-cond-issue-7447.test new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2024/Tests/where-cond-issue-7447.test
@@ -0,0 +1,32 @@
+statement ok
+CREATE TABLE t0(c0 INTEGER, c1 BOOLEAN, PRIMARY KEY(c0))
+
+statement ok
+CREATE TABLE t1(c1 INTEGER)
+
+statement ok
+INSERT INTO t1 (c1) VALUES (null)
+
+statement ok
+INSERT INTO t0 (c0, c1) VALUES (-1, false)
+
+query I
+SELECT t0.c0             FROM t0 INNER  JOIN t1 ON (t0.c1 NOT BETWEEN t1.c1 AND \
t0.c0) +----
+-1
+
+query I
+SELECT (t1.c1>1) IS NULL FROM t0 INNER  JOIN t1 ON (t0.c1 NOT BETWEEN t1.c1 AND \
t0.c0) +----
+1
+
+query I
+SELECT t0.c0             FROM t0 INNER  JOIN t1 ON (t0.c1 NOT BETWEEN t1.c1 AND \
t0.c0) WHERE (t1.c1>1) IS NULL +----
+-1
+
+statement ok
+DROP TABLE t0 CASCADE
+
+statement ok
+DROP TABLE t1 CASCADE
diff --git a/sql/test/BugTracker-2024/Tests/where-cond-issue-7448.test \
b/sql/test/BugTracker-2024/Tests/where-cond-issue-7448.test new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2024/Tests/where-cond-issue-7448.test
@@ -0,0 +1,28 @@
+statement ok
+CREATE TABLE t0(c0 BOOLEAN,  c1 VARCHAR)
+
+statement ok
+INSERT INTO t0 (c0, c1) VALUES (true, true)
+
+statement ok
+CREATE INDEX i0 ON t0(c1 , c0 )
+
+query IT
+SELECT * FROM t0
+----
+1
+true
+
+query I
+SELECT (t0.c1=(t0.c0 OR true))AND(t0.c0) FROM t0
+----
+1
+
+query IT
+SELECT * FROM t0 WHERE ((t0.c1=(t0.c0 OR true))AND(t0.c0))
+----
+1
+true
+
+statement ok
+DROP TABLE t0 CASCADE
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-leave@monetdb.org


[prev in list] [next in list] [prev in thread] [next in thread]