Changeset: cdca4fdd9129 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/cdca4fdd9129 Added Files: sql/test/BugTracker-2026/Tests/7728-select-with-subqueries-crash.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for #7728 diffs (39 lines): diff --git a/sql/test/BugTracker-2026/Tests/7728-select-with-subqueries-crash.test b/sql/test/BugTracker-2026/Tests/7728-select-with-subqueries-crash.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/7728-select-with-subqueries-crash.test @@ -0,0 +1,26 @@ +-- in strNil error: Cannot access memory at address 0x134>) at MonetDB/gdk/gdk_atoms.h:410 +-- in strEq error: Cannot access memory at address 0x134>, r=0x7fc800d0e46b <str_nil> "\200") at MonetDB/gdk/gdk_atoms.h:438 +-- in GDKanalyticalmax (tpe=18, frame_type=0) at MonetDB/gdk/gdk_analytic_func.c:1361 +statement error GDK reported error: mergejoin: more than one match +SELECT ( WITH x ( x ) AS ( SELECT 1 ) SELECT ( WITH x ( x ) AS ( SELECT 1 UNION SELECT 1 - x FROM x ) SELECT ( SELECT ( NULLIF ( 9.000000 , 0 ) ) FROM ( SELECT ( WITH x AS ( SELECT * FROM generate_series ( 44 , 3 ) ) SELECT CASE WHEN lead ( x ) OVER ( ORDER BY x ASC , x DESC , x ) IN ( 69 , MAX ( CASE WHEN 97 THEN 66 END ) OVER ( ) + ( SELECT COUNT ( * ) ) ) THEN 41 END FROM x ORDER BY max ( 'y' ) OVER ( ROWS BETWEEN ( WITH x ( x ) AS ( SELECT 1 ) SELECT ( WITH x ( x ) AS ( SELECT DISTINCT SUM ( 1 ) ) SELECT ( SELECT ( CASE WHEN NOT - 10 IS NULL AND NULL IS NULL THEN - 30 WHEN - - 39 * - 89 NOT IN ( - 51 * - - 1.000000 , count ( * ) / 67 ) THEN count ( 54 ) END ) FROM GENERATE_SERIES ( 1 , x ) ) ) FROM x ) PRECEDING AND CURRENT ROW ) ) WHERE ( SELECT x FROM x WHERE x != 1 GROUP BY x ) != x ORDER BY x ) ) FROM x ) FROM x ) + +statement error GDK reported error: mergejoin: more than one match +SELECT ( WITH x ( x ) AS ( SELECT 1 ) + SELECT ( WITH x ( x ) AS ( SELECT 1 UNION SELECT 1 - x FROM x ) + SELECT ( SELECT ( NULLIF ( 9.000000 , 0 ) ) FROM ( + SELECT ( WITH x AS ( SELECT * FROM generate_series ( 44 , 3 ) ) + SELECT CASE WHEN lead ( x ) OVER ( ORDER BY x ASC , x DESC , x ) IN ( 69 , MAX ( CASE WHEN 97 THEN 66 END ) OVER ( ) + ( SELECT COUNT ( * ) ) ) THEN 41 END FROM x + ORDER BY max ( 'y' ) OVER ( ROWS BETWEEN ( + WITH x ( x ) AS ( SELECT 1 ) + SELECT ( WITH x ( x ) AS ( SELECT DISTINCT SUM ( 1 ) ) + SELECT ( + SELECT ( CASE WHEN NOT - 10 IS NULL AND NULL IS NULL THEN - 30 WHEN - - 39 * - 89 NOT IN ( - 51 * - - 1.000000 , count ( * ) / 67 ) THEN count ( 54 ) END ) FROM GENERATE_SERIES ( 1 , x ) + ) + ) + FROM x ) PRECEDING AND CURRENT ROW ) + ) WHERE ( SELECT x FROM x WHERE x != 1 GROUP BY x ) != x ORDER BY x + ) + ) + FROM x ) +FROM x ) + 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 @@ -1,3 +1,4 @@ +KNOWNFAIL?7728-select-with-subqueries-crash KNOWNFAIL?7758-truncate-sys-tables-corrupts-db 7766-assertion-failure 7767-assertion-failure _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
