Changeset: a0fa0a234ffb for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a0fa0a234ffb Added Files: sql/test/BugTracker-2026/Tests/7788-assertion-failure.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for #7788 diffs (40 lines): diff --git a/sql/test/BugTracker-2026/Tests/7788-assertion-failure.test b/sql/test/BugTracker-2026/Tests/7788-assertion-failure.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/7788-assertion-failure.test @@ -0,0 +1,24 @@ +statement ok +CREATE TABLE v0 ( v1 INTEGER , v2 NUMERIC , v3 INTEGER ) + +statement ok +INSERT INTO v0 VALUES ( 13 , -1 , 87 ) + +statement ok +INSERT INTO v0 VALUES ( 80 , 0 , 37 ) + +statement error 42000!SELECT: no such window function 'nth_value'(tinyint) +SELECT NTH_VALUE ( 127 ) OVER ( ORDER BY v3 ) FROM v0 + +-- sql/server/rel_select.c:4675: rel_order_by: Assertion `is_project(rel->op)' failed. +statement error 42000!SELECT: +SELECT 0 , 'x' , 'x' , -1 FROM v0 WHERE v3 = -1 OR v2 < ( SELECT 20405044.000000 * ( v3 ) FROM v0 AS v4 NATURAL JOIN v0 WHERE v1 = v3 ) ORDER BY SUM ( + v3 ORDER BY x DESC ) , v2 + +-- sql/server/rel_select.c:4675: rel_order_by: Assertion `is_project(rel->op)' failed. +statement error 42000!SELECT: no such window function 'nth_value'(tinyint) +UPDATE v0 SET v1 = ( SELECT NTH_VALUE ( 127 ) OVER ( ORDER BY v3 ) FROM v0 ) + WHERE ( SELECT 0 , 'x' , 'x' , -1 FROM v0 WHERE v3 = -1 OR v2 < ( SELECT 20405044.000000 * ( v3 ) FROM v0 AS v4 NATURAL JOIN v0 WHERE v1 = v3 ) ORDER BY SUM ( + v3 ORDER BY x DESC ) , v2 ) = v3 <= v3 + +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 @@ -13,6 +13,7 @@ KNOWNFAIL?7781-truncate-sys-tables-corru KNOWNFAIL?7785-recursive-cte-loops-infinitly 7786-rename-drop-table 7787-assertion-failure +7788-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]
