Changeset: a80aec89f4e3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a80aec89f4e3 Modified Files: sql/test/BugTracker-2026/Tests/7834-BATsubcross-more-than-one-match.test Branch: pp_hashjoin Log Message:
approved error diffs (10 lines): diff --git a/sql/test/BugTracker-2026/Tests/7834-BATsubcross-more-than-one-match.test b/sql/test/BugTracker-2026/Tests/7834-BATsubcross-more-than-one-match.test --- a/sql/test/BugTracker-2026/Tests/7834-BATsubcross-more-than-one-match.test +++ b/sql/test/BugTracker-2026/Tests/7834-BATsubcross-more-than-one-match.test @@ -1,4 +1,5 @@ -statement error: /more than one match/ +#statement error: /more than one match/ +statement error 42000!row frame bound must be non negative and non null. SELECT x , x , STDDEV_POP ( NULLIF ( ( WITH RECURSIVE x ( x ) AS ( WITH RECURSIVE x ( x ) AS ( SELECT 440 UNION SELECT 1 - x FROM x ) SELECT * FROM generate_series ( 0 , 10 ) WHERE x < 5 ) SELECT - COUNT ( * ) OVER ( ROWS BETWEEN 2 PRECEDING AND 3 >= ( SELECT CASE WHEN x = 12 THEN 1 ELSE CASE WHEN length ( 'abcdefg' ) >= 1 THEN substr ( ( SELECT SUM ( 0 ) OVER ( ) ) , locate ( RPAD ( 'abc' , 1 , ( SELECT 1 ) > ANY ( 1 ) ) , 'joeuser@mydatabase@test' , 9 ) , 1 ) ELSE 'nil' END END FROM ( SELECT 1 x HAVING COUNT ( * ) > ( SELECT - CASE - ( 0 ) WHEN 18 + - 60 THEN NULL WHEN - CASE - 67 WHEN - 79 * ROW_NUMBER ( ) OVER ( ORDER BY ( SELECT * FROM ( SELECT 1 AS x ) WHERE x IN ( SELECT ( row_number ( ) OVER ( ) ) ) ) ) <= -5.500000 / 30 - 32 * 69 THEN sign ( CAST( '-9223372036854775808.5' AS FLOAT ) ) + 0 ELSE NULL END * ( 45 ) + 19 * 17 THEN 20 WHEN SUM ( 78 ) + 69 THEN 1234567954432.000000 % 119070 % '' * 74 ELSE NULLIF ( 82 , 72 + 26 ) * 7 END * - 92 WHERE FALSE ) UNION SELECT 1 + 1 AS x INTERSECT SELECT 3 ) AS x ) FOLLOWING ) FROM x AS x WHERE NOT ( - x ) BETWEEN - x AND NULL ) , NULL ) ) OVER ( ORDER BY CASE WHEN x % 2 = 0 THEN 0 ELSE 1 END RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING ) AS x FROM ( SELECT rank ( ) OVER ( PARTITION BY 'x' , 1 , 1 , 'x' ) AS x UNION SELECT 0 AS x UNION SELECT 3 AS x ) ORDER BY 1 , 2 , 3 onlyif has-hugeintxs _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
