Changeset: 621380a93178 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/621380a93178 Added Files: sql/test/BugTracker-2022/Tests/single_row_in_rel_order_by_column.Bug-7306.test Modified Files: sql/test/BugTracker-2022/Tests/All Branch: Sep2022 Log Message:
Add test for issue #7306 diffs (43 lines): diff --git a/sql/test/BugTracker-2022/Tests/All b/sql/test/BugTracker-2022/Tests/All --- a/sql/test/BugTracker-2022/Tests/All +++ b/sql/test/BugTracker-2022/Tests/All @@ -11,3 +11,4 @@ having-clauses.Bug-7278 dump-table-data.Bug-7282 NOT_WIN32?cudf-grouped-aggr.Bug-7285 create_func_with_case_and_in +single_row_in_rel_order_by_column.Bug-7306 diff --git a/sql/test/BugTracker-2022/Tests/single_row_in_rel_order_by_column.Bug-7306.test b/sql/test/BugTracker-2022/Tests/single_row_in_rel_order_by_column.Bug-7306.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2022/Tests/single_row_in_rel_order_by_column.Bug-7306.test @@ -0,0 +1,30 @@ +query R +SELECT avg(4); +---- +4.000 + +query I +SELECT count(*); +---- +1 + +query I +SELECT count(*) over (order by 1); +---- +1 + +query R +SELECT avg(42) over (order by 2); +---- +42.000 + +query I +SELECT count(*) over (order by row_number() over ()); +---- +1 + +query R +SELECT avg(42) over (order by row_number() over ()); +---- +42.000 + _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
