Changeset: 7c9853c5bd45 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/7c9853c5bd45 Modified Files: sql/test/BugTracker-2024/Tests/SQLunionfunc-Bug-7473.test Branch: default Log Message:
some more simplified versions too test diffs (19 lines): diff --git a/sql/test/BugTracker-2024/Tests/SQLunionfunc-Bug-7473.test b/sql/test/BugTracker-2024/Tests/SQLunionfunc-Bug-7473.test --- a/sql/test/BugTracker-2024/Tests/SQLunionfunc-Bug-7473.test +++ b/sql/test/BugTracker-2024/Tests/SQLunionfunc-Bug-7473.test @@ -1,4 +1,15 @@ +query I nosort +SELECT ( SELECT ( SELECT ( NULLIF ( 9.000000 , 0 ) ) FROM GENERATE_SERIES ( 1 , x )) FROM ( SELECT DISTINCT SUM ( 1 ) ) x (x)) FROM ( SELECT 1 ) x (x) +---- +9 + +query I nosort +SELECT ( SELECT ( SELECT ( SELECT ( NULLIF ( 9.000000 , 0 ) ) FROM GENERATE_SERIES ( 1 , x )) FROM ( SELECT DISTINCT SUM ( 1 ) ) x (x)) FROM ( SELECT 1 ) x (x)) +---- +9 + query I nosort SELECT ( WITH x ( x ) AS ( SELECT 1 ) SELECT ( WITH x ( x ) AS ( SELECT DISTINCT SUM ( 1 ) ) SELECT ( SELECT ( NULLIF ( 9.000000 , 0 ) ) FROM GENERATE_SERIES ( 1 , x ) ) FROM x ) FROM x ) ---- 9 + _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
