Changeset: a3c7998df5f9 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a3c7998df5f9 Added Files: sql/test/BugTracker-2026/Tests/7851-assertion-failure.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for #7851 diffs (118 lines): diff --git a/sql/test/BugTracker-2026/Tests/7851-assertion-failure.test b/sql/test/BugTracker-2026/Tests/7851-assertion-failure.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/7851-assertion-failure.test @@ -0,0 +1,105 @@ +statement ok +CREATE SCHEMA test7851 + +statement ok +SET SCHEMA test7851 + +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 comments ( + id INT, + post_id INT, + user_id INT, + content VARCHAR(1000), + is_spam INT, + created_at TIMESTAMP +) + +statement ok +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 +INSERT INTO comments VALUES +(1, 1, 2, 'Nice post', 0, '2022-01-20 10:00:00'), +(2, 1, 3, 'Spam here', 1, '2022-01-21 11:00:00'), +(3, 2, 1, 'Thanks', 0, '2022-01-22 12:00:00'), +(4, 4, 5, NULL, 0, '2022-01-23 13:00:00') + +-- statement triggers assertion failure in rel2bin_semijoin (be=0x7f92a01a61b0, rel=0x7f92a01e0140, refs=0x7f92a02629a0) at MonetDB/sql/backends/monet5/rel_bin.c:3953 +statement ok +MERGE INTO comments as target_0 +USING (select + nullif(ref_0.age, + ref_0.age) as c6 + from + users as ref_0 + inner join users as ref_1 + on (false), + lateral (select 1 + from + comments as ref_2 + where ((ref_2.is_spam < ref_2.user_id)) + and (EXISTS ( + select 1 + from + users as ref_3, + lateral (select + ref_1.created_at as c0, + ref_1.created_at as c1, + ref_0.id as c2, + ref_3.username as c3, + ref_2.is_spam as c4, + ref_1.id as c5 + from + comments as ref_4, + lateral (select + ref_0.username as c0 + from + comments as ref_5 + where ref_2.id >= ref_0.id) as subq_0 + where EXISTS ( + select 1 + from + users as ref_6, + lateral ( + SELECT ref_4.user_id AS c5 + FROM users AS ref_7 + WHERE false + ) subq_1 + where ('V' >= 'Pw') + and (('2' >= 'l13S')))) as subq_2 + where subq_2.c5 > 55))) as subq_3 + where true) as subq_4 +ON target_0.user_id = subq_4.c6 +WHEN NOT MATCHED AND true + THEN INSERT VALUES ( 47, 84 + , 50, case when 16 is not NULL then null else null end + , 67, CURRENT_TIMESTAMP) + +statement ok +DROP TABLE comments + +statement ok +DROP TABLE users + +statement ok +SET SCHEMA sys + +statement ok +DROP SCHEMA test7851 + 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 @@ -53,3 +53,4 @@ KNOWNFAIL?7847-assertion-failure KNOWNFAIL?7848-assertion-failure KNOWNFAIL?7849-assertion-failure KNOWNFAIL?7850-assertion-failure +KNOWNFAIL?7851-assertion-failure _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
