Changeset: 0a04c05040bd for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0a04c05040bd Added Files: sql/test/BugTracker-2026/Tests/7848-assertion-failure.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for #7848 diffs (175 lines): diff --git a/sql/test/BugTracker-2026/Tests/7848-assertion-failure.test b/sql/test/BugTracker-2026/Tests/7848-assertion-failure.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/7848-assertion-failure.test @@ -0,0 +1,162 @@ +statement ok +CREATE SCHEMA test7848 + +statement ok +SET SCHEMA test7848 + +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 posts ( + id INT, + user_id INT, + title VARCHAR(255), + content VARCHAR(1000), + views INT, + likes INT, + created_at TIMESTAMP, + rating 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 +CREATE TABLE orders ( + id INT, + user_id INT, + amount DOUBLE, + status VARCHAR(20), + 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 posts VALUES +(1, 1, 'Hello World', 'First post', 100, 10, '2022-01-10 10:00:00', 4.5), +(2, 1, 'Another Post', NULL, 150, 20, '2022-01-11 11:00:00', 3.0), +(3, 2, 'Bob Post', 'Content', NULL, 5, '2022-01-12 12:00:00', NULL), +(4, 3, NULL, 'Empty', 50, 2, '2022-01-13 13:00:00', 5.0), +(5, 4, 'Last Post', 'Last', 300, 30,'2022-01-14 14:00:00', 4.9) + +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 ok +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 triggers assertion failure in exp_bin (be=0x7f16781a61b0, e=0x7f16781bad50, left=0x7f1678261cf0, right=0x7f1678261db0, grp=0x0, ext=0x0, cnt=0x0, sel=0x0, depth=6, reduce=0, push=1) at sql/backends/monet5/rel_bin.c:1899 +query IT rowsort +SELECT + subq_1.c1 AS c0, + (SELECT created_at FROM comments LIMIT 1 OFFSET 2) AS c1 +FROM +( + SELECT + ref_0.created_at AS c0, + ref_0.is_spam AS c1, + ref_0.post_id AS c2, + CASE WHEN 81.31 <> (SELECT stddev_pop(id) FROM users) THEN subq_0.c3 ELSE NULLIF(ref_0.post_id, ref_0.user_id) END AS c3, + ref_0.user_id AS c4, + ref_0.is_spam AS c5, + CASE WHEN ref_0.user_id < ref_0.user_id THEN (SELECT user_id FROM posts LIMIT 1 OFFSET 3) ELSE ref_0.user_id END AS c6, + ref_0.user_id AS c7, + ref_0.user_id AS c8 + FROM + comments AS ref_0, + LATERAL ( + SELECT + ref_1.post_id AS c0, + ref_1.user_id AS c1, + ref_0.content AS c2, + (SELECT is_spam FROM comments LIMIT 1 OFFSET 6) AS c3 + FROM + comments AS ref_1 + WHERE + 57.96 >= (SELECT var_pop(id) FROM comments) + ) AS subq_0 + WHERE + true +) AS subq_1 +WHERE + 'f0LWq' <= + CASE + WHEN + CASE WHEN (subq_1.c7 < subq_1.c8) + AND ((subq_1.c8 <= subq_1.c4) AND (subq_1.c4 IS NULL)) + THEN 78.41 + ELSE COALESCE(power(36.42, 80.7), 52.51) + END + = + sqrt( + CASE WHEN subq_1.c3 IS NULL + THEN COALESCE((SELECT avg(id) FROM comments), 35.89) + ELSE CASE WHEN 24.59 <= 8.32 THEN 24.21 ELSE 27.89 END + END + ) + THEN + CASE WHEN (subq_1.c5 IS NOT NULL) + THEN substring( + nullif( + substr('J8L0', subq_1.c6), + 'C4st' + ), + CASE WHEN subq_1.c2 IS NOT NULL THEN subq_1.c6 ELSE subq_1.c4 END, + subq_1.c1 + ) + ELSE coalesce(nullif('xw','g9W'), 'W3') + END + ELSE 'Z12RC' + END +---- + +statement ok +DROP TABLE orders + +statement ok +DROP TABLE comments + +statement ok +DROP TABLE posts + +statement ok +DROP TABLE users + +statement ok +SET SCHEMA sys + +statement ok +DROP SCHEMA test7848 + 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 @@ -50,3 +50,4 @@ KNOWNFAIL?7843-assertion-failure KNOWNFAIL?7845-assertion-failure KNOWNFAIL?7846-do_covariance_and_correlation-crash KNOWNFAIL?7847-assertion-failure +KNOWNFAIL?7848-assertion-failure _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
