Changeset: 3ff821f519e5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/3ff821f519e5 Modified Files: sql/test/BugTracker-2025/Tests/7729-tail_type-crash.test Branch: default Log Message:
added some variantions of the original query. several of the new queries produce wrong results without --pipeline; one of the new queries needs the 'manti' branch to produce the correct result diffs (58 lines): diff --git a/sql/test/BugTracker-2025/Tests/7729-tail_type-crash.test b/sql/test/BugTracker-2025/Tests/7729-tail_type-crash.test --- a/sql/test/BugTracker-2025/Tests/7729-tail_type-crash.test +++ b/sql/test/BugTracker-2025/Tests/7729-tail_type-crash.test @@ -2,3 +2,54 @@ query I SELECT ( WITH x ( x ) AS ( SELECT DISTINCT 1 ) SELECT ( SELECT x FROM x WHERE x = ( SELECT ( CASE WHEN x THEN x END ) WHERE ( SELECT x FROM x WHERE ( x , ( SELECT ( WITH x ( x ) AS ( SELECT DISTINCT 1 ) SELECT ( SELECT x FROM x WHERE x = ( SELECT ( CASE WHEN x THEN x END ) WHERE 1 + 1 + 1 + 1 + 1 + 1 + 1 + 9223372036854775808.000000 + 1 + 1 = ( SELECT x FROM x ) AND x GROUP BY 1 HAVING ( - 'x' >= x IS NOT NULL = ( 1 < x AND x < 'x' ) AND x = 8 ) ) GROUP BY x HAVING ( 9 = -1 AND x = 8 ) ) FROM x ) LIMIT 10 OFFSET 0 ) ) NOT IN ( SELECT x , x FROM x WHERE x > 1 ) ) AND x ) ) FROM x ) ---- 1 + +query I +WITH x ( x ) AS ( SELECT DISTINCT 1 ) SELECT ( SELECT x FROM x WHERE ( x , ( SELECT x FROM x where false) ) NOT IN ( SELECT x , x FROM x WHERE FALSE ) ) FROM x; +---- +1 + +query I +WITH x ( x ) AS ( SELECT DISTINCT 1 ) SELECT x FROM x WHERE ( x , ( SELECT x FROM x where false) ) NOT IN ( SELECT x , x FROM x WHERE FALSE ) ; +---- +1 + +query I +WITH x ( x ) AS ( SELECT DISTINCT 1 ) SELECT ( SELECT x FROM x WHERE ( x , ( SELECT x FROM x where false) ) NOT IN ( SELECT null , null FROM x) ) FROM x; +---- +NULL + +query I +WITH x ( x ) AS ( SELECT DISTINCT 1 ) SELECT x FROM x WHERE ( x , ( SELECT x FROM x where false) ) NOT IN ( SELECT null , null FROM x) ; +---- + +query I +WITH x ( x ) AS ( SELECT DISTINCT 1 ) SELECT ( SELECT x FROM x WHERE ( x , ( SELECT x FROM x where false) ) NOT IN ( (SELECT null , null) ) ) FROM x; +---- +NULL + +query I +WITH x ( x ) AS ( SELECT DISTINCT 1 ) SELECT x FROM x WHERE ( x , ( SELECT x FROM x where false) ) NOT IN ( (SELECT null , null) ) ; +---- + +query I +WITH x ( x ) AS ( SELECT DISTINCT 1 ) SELECT x FROM x WHERE ( x , (select null from x)) NOT IN ( SELECT null , null FROM x); +---- + +query I +WITH x ( x ) AS ( SELECT DISTINCT 1 ) SELECT x FROM x WHERE ( x , null ) NOT IN ( SELECT x , x FROM x WHERE FALSE ) ; +---- +1 + +query I +WITH x ( x ) AS ( SELECT DISTINCT 1 ) SELECT x FROM x WHERE ( x , null ) NOT IN ( SELECT null , null FROM x) ; +---- + +query I +WITH x ( x ) AS ( SELECT DISTINCT 1 ) SELECT ( SELECT x FROM x WHERE ( x , ( SELECT ( SELECT x FROM x WHERE false ) FROM x ) ) NOT IN ( SELECT x , x FROM x WHERE FALSE) ) FROM x; +---- +1 + +query I +WITH x ( x ) AS ( SELECT DISTINCT 1 ) SELECT ( SELECT x FROM x WHERE ( x , ( SELECT ( SELECT x FROM x WHERE false ) FROM x ) ) NOT IN ( SELECT x , x FROM x WHERE FALSE ) ) FROM x; +---- +1 _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
