Changeset: b5d7876f520e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/b5d7876f520e
Added Files:
        sql/test/BugTracker-2026/Tests/7793-assertion-failure.test
Modified Files:
        sql/test/BugTracker-2026/Tests/All
Branch: Dec2025
Log Message:

Add test for #7793


diffs (43 lines):

diff --git a/sql/test/BugTracker-2026/Tests/7793-assertion-failure.test 
b/sql/test/BugTracker-2026/Tests/7793-assertion-failure.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2026/Tests/7793-assertion-failure.test
@@ -0,0 +1,27 @@
+statement ok
+CREATE TABLE v0 ( v1 INT , v2 INT , v3 VARCHAR ( 73 ) )
+
+statement ok
+INSERT INTO v0 VALUES ( 52 , NULL , 'x' ) , ( -128 , NULL , 'x' ) , ( 38 , 
NULL , 'x' )
+
+statement ok
+CREATE TABLE v4 ( v5 INT , v6 INT )
+
+statement ok
+INSERT INTO v4 VALUES ( 30 , 2147483647 ) , ( 94 , 8 ) , ( 73 , -1 )
+
+query I nosort
+SELECT v5 FROM v4 WHERE v5 IN ( SELECT DISTINCT v2 FROM v0 WHERE v5 = v6 + 12 )
+----
+
+-- sql/backends/monet5/rel_bin.c:3953: rel2bin_semijoin: Assertion 
`sql->session->status == -10' failed.
+statement ok
+UPDATE v0 SET v1 = ( SELECT v5 FROM v4 WHERE v5 IN ( SELECT DISTINCT v2 WHERE 
v5 = v6 + 12 ) ) WHERE v2 IS NULL
+
+
+statement ok
+DROP TABLE v4
+
+statement ok
+DROP TABLE v0
+
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
@@ -18,6 +18,7 @@ KNOWNFAIL?7789-assertion-failure
 KNOWNFAIL?7790-assertion-failure
 KNOWNFAIL?7791-assertion-failure
 KNOWNFAIL?7792-assertion-failure
+KNOWNFAIL?7793-assertion-failure
 7804-querylog-catalog-orderby-bug
 7805-orderby-all-bug
 7806-numeric-no-prec-no-scale
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to