Changeset: 93e743b34402 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/93e743b34402 Added Files: sql/test/BugTracker-2026/Tests/7885-right-join-where-true-crash.test Modified Files: sql/test/BugTracker-2026/Tests/7883-right-join-crash.test sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for issue #7885 The test was previously added to 7883-right-join-crash.test but it is better to have it separate. diffs (191 lines): diff --git a/sql/test/BugTracker-2026/Tests/7883-right-join-crash.test b/sql/test/BugTracker-2026/Tests/7883-right-join-crash.test --- a/sql/test/BugTracker-2026/Tests/7883-right-join-crash.test +++ b/sql/test/BugTracker-2026/Tests/7883-right-join-crash.test @@ -23,7 +23,7 @@ INSERT INTO users VALUES (4, 'dave', '[email protected]', 45, 'active', '2022-01-04 13:00:00', 65.2), (5, NULL, '[email protected]', 18, 'inactive','2022-01-05 14:00:00', 70.0) -query I +query I rowsort select 1 from users @@ -40,6 +40,9 @@ where true ---- statement ok +drop table users + +statement ok CREATE TABLE posts ( id INT, user_id INT, @@ -77,8 +80,7 @@ INSERT INTO orders VALUES (5, 5, 999.99, 'paid', '2022-02-05 13:00:00') -- Crash SQL - -query I +query I rowsort select 1 from posts as ref_0, @@ -96,65 +98,14 @@ where false ---- statement ok -drop table users - -statement ok drop table posts statement ok drop table orders statement ok -CREATE TABLE users ( - id INT, - username VARCHAR(100), - email VARCHAR(255), - age INT, - status VARCHAR(20), - created_at TIMESTAMP, - score DOUBLE -) +SET SCHEMA sys statement ok -CREATE TABLE orders ( - id INT, - user_id INT, - amount DOUBLE, - status VARCHAR(20), - created_at TIMESTAMP -) - -statement ok rowcount 5 -INSERT INTO users VALUES -(1, 'alice', '[email protected]', 20, 'active', '2022-01-01 10:00:00', 88.5), -(2, 'bob', '[email protected]', 30, 'active', '2022-01-02 11:00:00', 92.3), -(3, 'carol', NULL, NULL, 'banned','2022-01-03 12:00:00', NULL), -(4, 'dave', '[email protected]', 45, 'active', '2022-01-04 13:00:00', 65.2), -(5, NULL, '[email protected]', 18, 'inactive','2022-01-05 14:00:00', 70.0) +DROP SCHEMA test7883 -statement ok rowcount 5 -INSERT INTO orders VALUES -(1, 1, 100.00, 'paid', '2022-02-01 09:00:00'), -(2, 1, 200.50, 'shipped', '2022-02-02 10:00:00'), -(3, 2, NULL, 'failed', '2022-02-03 11:00:00'), -(4, 3, 50.00, 'paid', '2022-02-04 12:00:00'), -(5, 5, 999.99, 'paid', '2022-02-05 13:00:00') - -query I -select count(*) -from - (select 1 - from - orders as ref_0 - where true) as subq_0 - right join orders as ref_1 - right join users as ref_2 - inner join orders as ref_3 - on (true) - on (false) - on (true ) -where ((true) - and (55.85 != 55.45)) - or (true AND true) ----- -125 diff --git a/sql/test/BugTracker-2026/Tests/7885-right-join-where-true-crash.test b/sql/test/BugTracker-2026/Tests/7885-right-join-where-true-crash.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/7885-right-join-where-true-crash.test @@ -0,0 +1,75 @@ +statement ok +CREATE SCHEMA test7885 + +statement ok +SET SCHEMA test7885 + +-- Schema +statement ok +CREATE TABLE users ( + id INT, + username VARCHAR(100), + email VARCHAR(255), + age INT, + status VARCHAR(20), + created_at TIMESTAMP, + score DOUBLE +) + +statement ok +CREATE TABLE orders ( + id INT, + user_id INT, + amount DOUBLE, + status VARCHAR(20), + created_at TIMESTAMP +) + +statement ok rowcount 5 +INSERT INTO users VALUES +(1, 'alice', '[email protected]', 20, 'active', '2022-01-01 10:00:00', 88.5), +(2, 'bob', '[email protected]', 30, 'active', '2022-01-02 11:00:00', 92.3), +(3, 'carol', NULL, NULL, 'banned','2022-01-03 12:00:00', NULL), +(4, 'dave', '[email protected]', 45, 'active', '2022-01-04 13:00:00', 65.2), +(5, NULL, '[email protected]', 18, 'inactive','2022-01-05 14:00:00', 70.0) + +statement ok rowcount 5 +INSERT INTO orders VALUES +(1, 1, 100.00, 'paid', '2022-02-01 09:00:00'), +(2, 1, 200.50, 'shipped', '2022-02-02 10:00:00'), +(3, 2, NULL, 'failed', '2022-02-03 11:00:00'), +(4, 3, 50.00, 'paid', '2022-02-04 12:00:00'), +(5, 5, 999.99, 'paid', '2022-02-05 13:00:00') + +-- Crash SQL +query I nosort +select count(*) as count +from + (select 1 + from + orders as ref_0 + where true) as subq_0 + right join orders as ref_1 + right join users as ref_2 + inner join orders as ref_3 + on (true) + on (false) + on (true ) +where ((true) + and (55.85 != 55.45)) + or (true AND true) +---- +125 + +statement ok +drop table users + +statement ok +drop table orders + +statement ok +SET SCHEMA sys + +statement ok +DROP SCHEMA test7885 + diff --git a/sql/test/BugTracker-2026/Tests/All b/sql/test/BugTracker-2026/Tests/All --- a/sql/test/BugTracker-2026/Tests/All +++ b/sql/test/BugTracker-2026/Tests/All @@ -82,6 +82,7 @@ KNOWNFAIL?7774-insert-into-renamed-table 7880-exp_bin_conjunctive-crash 7882-later-distinct 7883-right-join-crash +7885-right-join-where-true-crash 7886-local-view-in-with 7887-closed-connection-bug 7888-or-false-write _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
