Changeset: f38bd0732bb3 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/f38bd0732bb3
Added Files:
        sql/test/BugTracker-2026/Tests/7948-exp_bin-first_value-crash.test
Modified Files:
        sql/test/BugTracker-2026/Tests/All
Branch: Dec2025
Log Message:

Add test for #7948


diffs (21 lines):

diff --git a/sql/test/BugTracker-2026/Tests/7948-exp_bin-first_value-crash.test 
b/sql/test/BugTracker-2026/Tests/7948-exp_bin-first_value-crash.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2026/Tests/7948-exp_bin-first_value-crash.test
@@ -0,0 +1,8 @@
+query I nosort
+SELECT MIN ( x )
+  FROM ( WITH RECURSIVE x ( x ) AS ( SELECT RANK ( ) OVER ( ORDER BY x , x ) 
AS x FROM ( SELECT 1 AS x ) WHERE x IN ( SELECT ( row_number ( ) OVER ( ) ) 
FROM ( SELECT CAST( NULL AS INT ) AS x , 'v1' AS x , 1 AS x , 2 AS x UNION 
SELECT NULL , 'v1' , 1 , 2 ) AS x ) )
+         SELECT x * ( not_like ( 'abc' , '_C_' , NULLIF ( ( SELECT sum ( x ) 
OVER ( ROWS BETWEEN CURRENT ROW AND CURRENT ROW ) AS x UNION SELECT 2 AS x 
UNION SELECT 3 AS x ) , 1 ) NOT IN ( 2 , 3 , FIRST_VALUE ( 999 ) OVER ( ) ) , 
TRUE ) + x ) AS x
+           FROM x ) AS x
+----
+1
+
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
@@ -133,3 +133,4 @@ KNOWNFAIL?7931-rel2bin_select-assertion-
 KNOWNFAIL?7945-GDKanalyticalnthvalue-crash
 KNOWNFAIL?7946-GDKanalyticalnthvalue-crash
 KNOWNFAIL?7947-exp_bin-crash
+KNOWNFAIL?7948-exp_bin-first_value-crash
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to