Changeset: fd70381c1d8c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/fd70381c1d8c Added Files: sql/test/BugTracker-2026/Tests/7945_GDKanalyticalnthvalue_crash.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for #7945 diffs (56 lines): diff --git a/sql/test/BugTracker-2026/Tests/7945_GDKanalyticalnthvalue_crash.test b/sql/test/BugTracker-2026/Tests/7945_GDKanalyticalnthvalue_crash.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/7945_GDKanalyticalnthvalue_crash.test @@ -0,0 +1,43 @@ +query RTR rowsort +SELECT x + , nth_value ( 'bug' , 1 ) OVER ( RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW ) + , max ( x ) OVER ( ORDER BY x DESC RANGE BETWEEN CURRENT ROW AND 1 FOLLOWING ) + FROM ( SELECT sql_div ( 3.400000 , locate ( '5.6' , '0.1.2.3.5.4.5.6.8.5.6.8' , 7 ) ) AS x + ) +---- +0.262 +bug +0.262 + +query RR rowsort +SELECT x +-- , nth_value ( 'bug' , 1 ) OVER ( RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW ) + , max ( x ) OVER ( ORDER BY x DESC RANGE BETWEEN CURRENT ROW AND 1 FOLLOWING ) + FROM ( SELECT sql_div ( 3.400000 , locate ( '5.6' , '0.1.2.3.5.4.5.6.8.5.6.8' , 7 ) ) AS x + EXCEPT SELECT 11 AS x UNION SELECT 12 AS x UNION SELECT 13 AS x ) +---- +0.262 +0.262 +12.000 +12.000 +13.000 +13.000 + +-- next reported query crashes in GDKanalyticalnthvalue (b=0x7f8d537a2cd8 <BBP0+209048>, s=0x0, e=0x0, t=0x0, nth=0, tpe=18) at gdk/gdk_analytic_func.c:561 +query RTR rowsort +SELECT x + , nth_value ( 'bug' , 1 ) OVER ( RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW ) + , max ( x ) OVER ( ORDER BY x DESC RANGE BETWEEN CURRENT ROW AND 1 FOLLOWING ) + FROM ( SELECT sql_div ( 3.400000 , locate ( '5.6' , '0.1.2.3.5.4.5.6.8.5.6.8' , 7 ) ) AS x + EXCEPT SELECT 11 AS x UNION SELECT 12 AS x UNION SELECT 13 AS x ) +---- +0.262 +bug +0.262 +12.000 +bug +12.000 +13.000 +bug +13.000 + 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 @@ -130,3 +130,4 @@ KNOWNFAIL?7931-rel2bin_select-assertion- 7934-ALGouterselect-assertion-failure 7937-where-not-in-values-null-bug 7938-not-x-is-const-and-x-is-not-null-bug +KNOWNFAIL?7945_GDKanalyticalnthvalue_crash _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
