Changeset: abfb70b91492 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/abfb70b91492 Added Files: sql/test/BugTracker-2023/Tests/rel_order_by-assertion-7418.test Modified Files: sql/test/BugTracker-2023/Tests/All Branch: Dec2023 Log Message:
Add test for GH issue 7418. diffs (38 lines): diff --git a/sql/test/BugTracker-2023/Tests/All b/sql/test/BugTracker-2023/Tests/All --- a/sql/test/BugTracker-2023/Tests/All +++ b/sql/test/BugTracker-2023/Tests/All @@ -21,3 +21,4 @@ corr-issue-7414 insert-delete-insert-crash-7415 orderby-debug-crash-7416 newurl-issue-7417 +rel_order_by-assertion-7418 diff --git a/sql/test/BugTracker-2023/Tests/rel_order_by-assertion-7418.test b/sql/test/BugTracker-2023/Tests/rel_order_by-assertion-7418.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2023/Tests/rel_order_by-assertion-7418.test @@ -0,0 +1,25 @@ +statement ok +CREATE TABLE t7418 ( v1 BIGINT NOT NULL PRIMARY KEY ) + +query I +SELECT * FROM t7418 ORDER BY v1 +---- + +query I +SELECT 0 IS NOT NULL FROM t7418 ORDER BY AVG ( v1 ) NULLS LAST +---- +1 + +statement error 42000!MAX: aggregate functions cannot be nested +SELECT 0 IS NOT NULL FROM t7418 ORDER BY AVG ( max ( 331 ) ) NULLS LAST + +-- next causes: sql/server/rel_select.c:4766: rel_order_by: Assertion `is_project(rel->op)' failed. +statement error 42000!MAX: aggregate functions cannot be nested +SELECT 0 IS NOT NULL FROM t7418 ORDER BY AVG ( max ( 331 ) ) OVER ( ORDER BY 634 NULLS FIRST ) NULLS LAST + +query I +SELECT * FROM t7418 ORDER BY v1 +---- + +statement ok +DROP TABLE t7418 _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
