Changeset: b1bcb1caaeec for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/b1bcb1caaeec
Modified Files:
sql/server/rel_select.c
sql/test/BugTracker-2026/Tests/7788-assertion-failure.test
sql/test/BugTracker-2026/Tests/All
Branch: Dec2025
Log Message:
fixes for issue # 7788
diffs (44 lines):
diff --git a/sql/server/rel_select.c b/sql/server/rel_select.c
--- a/sql/server/rel_select.c
+++ b/sql/server/rel_select.c
@@ -4680,10 +4680,8 @@ rel_order_by(sql_query *query, sql_rel *
dnode *o = orderby->data.lval->h;
dlist *selection = NULL;
- if (is_sql_orderby(f)) {
- assert(is_project(rel->op));
+ if (is_sql_orderby(f))
rel = rel->l;
- }
for (; o; o = o->next) {
symbol *order = o->data.sym;
diff --git a/sql/test/BugTracker-2026/Tests/7788-assertion-failure.test
b/sql/test/BugTracker-2026/Tests/7788-assertion-failure.test
--- a/sql/test/BugTracker-2026/Tests/7788-assertion-failure.test
+++ b/sql/test/BugTracker-2026/Tests/7788-assertion-failure.test
@@ -11,11 +11,11 @@ statement error 42000!SELECT: no such wi
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:
+statement error 42000!SELECT: identifier 'x' unknown
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)
+statement error 42000!SELECT: identifier 'x' unknown
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
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
@@ -14,7 +14,7 @@ KNOWNFAIL?7781-truncate-sys-tables-corru
7785-recursive-cte-loops-infinitly
7786-rename-drop-table
7787-assertion-failure
-KNOWNFAIL?7788-assertion-failure
+7788-assertion-failure
KNOWNFAIL?7789-assertion-failure
KNOWNFAIL?7790-assertion-failure
KNOWNFAIL?7791-assertion-failure
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
