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

Add test for #7800


diffs (31 lines):

diff --git a/sql/test/BugTracker-2026/Tests/7800-assertion-failure.test 
b/sql/test/BugTracker-2026/Tests/7800-assertion-failure.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2026/Tests/7800-assertion-failure.test
@@ -0,0 +1,15 @@
+statement ok
+CREATE TABLE v0 ( v1 INTEGER , v2 REAL )
+
+query R nosort
+SELECT v3 . v2 FROM v0 v3 ORDER BY v2 , v2 DESC , v1 ASC
+----
+
+-- sql/server/rel_optimize_proj.c:41: rel_used_projections: Assertion `e->nid 
&& exps_bind_nid(exps, e->nid)' failed.
+query IR nosort
+SELECT * FROM v0 ORDER BY v2 = ( SELECT v0 . v2 FROM v0 v3 ORDER BY v2 , v2 
DESC , v1 ASC ) AND v2 IS NOT NULL ASC NULLS LAST
+----
+
+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
@@ -23,6 +23,7 @@ KNOWNFAIL?7794-assertion-failure
 KNOWNFAIL?7795-assertion-failure
 7796-assertion-failure
 KNOWNFAIL?7797-assertion-failure
+KNOWNFAIL?7800-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