Changeset: fe7c484c9ac8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/fe7c484c9ac8 Modified Files: sql/test/BugTracker-2026/Tests/7854-rcte-trims.test Branch: Dec2025 Log Message:
Speedup test 7854-rcte-trims from 6s to 0.6s by changeing generate_series ( 1 , 29512 ) into generate_series ( 1 , 2512 ). diffs (10 lines): diff --git a/sql/test/BugTracker-2026/Tests/7854-rcte-trims.test b/sql/test/BugTracker-2026/Tests/7854-rcte-trims.test --- a/sql/test/BugTracker-2026/Tests/7854-rcte-trims.test +++ b/sql/test/BugTracker-2026/Tests/7854-rcte-trims.test @@ -1,5 +1,5 @@ query RII -SELECT CAST( sum ( x ) AS NUMERIC ) , avg ( x ) , var_pop ( x ) FROM ( WITH RECURSIVE x ( x ) AS ( SELECT ltrim ( rtrim ( sql_min ( 1.200000 , ( ' ' ) ) , 'abc' ) ) AS x UNION SELECT * FROM generate_series ( 1 , 29512 ) ORDER BY - 1 DESC ) SELECT x FROM x WHERE x IN ( SELECT NOT NULL <= 'x' IN ( - 69 , ( SUM ( DISTINCT CAST( NULL IN ( WITH RECURSIVE x ( x ) AS ( SELECT 1 UNION SELECT x + 1 FROM x WHERE x < 20 ) SELECT x AS x FROM x WHERE x NOT IN ( 8 , 12 , CAST( 0.000000 AS FLOAT ) , 24 , 32 ) OR x = 512 GROUP BY x HAVING NOT x < ANY ( 5 IN ( SELECT 5 FROM ( SELECT 5 UNION SELECT 3 ) AS x ) AND 6 IN ( SELECT MAX ( x ) , MIN ( x ) , MAX ( x ) , MIN ( x ) , MAX ( x ) , MIN ( x ) ORDER BY 1 , 2 LIMIT 0 OFFSET 0 ) ) ) AS INTEGER ) ) ) + MAX ( DISTINCT - 6 ) + - COUNT ( * ) / - - ( 77 ) + 37 , 44 , - - 0 * 23 , - - 86 , 3 , - ( SELECT 5 WHERE x = ( SELECT x WHERE x = x ) UNION SELECT 3 LIMIT 1 ) + 0.100000 + 0.100000 + 0.100000 ) FROM ( SELECT substring ( 'Top.Child1.Child2' , 1 , 0 ) F ROM generate_series ( 1 , 40 ) AS x WHERE x BETWEEN 22 AND ( SELECT md5 ( NULL ) WHERE x IN ( SELECT ( row_number ( ) OVER ( ) ) GROUP BY x HAVING NOT x < ANY ( NOT MAX ( 42.400002 ) < AVG ( CAST( NULL AS INT ) ) ) ) ) ) LIMIT 24 ) OR x = 512 ) ; +SELECT CAST( sum ( x ) AS NUMERIC ) , avg ( x ) , var_pop ( x ) FROM ( WITH RECURSIVE x ( x ) AS ( SELECT ltrim ( rtrim ( sql_min ( 1.200000 , ( ' ' ) ) , 'abc' ) ) AS x UNION SELECT * FROM generate_series ( 1 , 2512 ) ORDER BY - 1 DESC ) SELECT x FROM x WHERE x IN ( SELECT NOT NULL <= 'x' IN ( - 69 , ( SUM ( DISTINCT CAST( NULL IN ( WITH RECURSIVE x ( x ) AS ( SELECT 1 UNION SELECT x + 1 FROM x WHERE x < 20 ) SELECT x AS x FROM x WHERE x NOT IN ( 8 , 12 , CAST( 0.000000 AS FLOAT ) , 24 , 32 ) OR x = 512 GROUP BY x HAVING NOT x < ANY ( 5 IN ( SELECT 5 FROM ( SELECT 5 UNION SELECT 3 ) AS x ) AND 6 IN ( SELECT MAX ( x ) , MIN ( x ) , MAX ( x ) , MIN ( x ) , MAX ( x ) , MIN ( x ) ORDER BY 1 , 2 LIMIT 0 OFFSET 0 ) ) ) AS INTEGER ) ) ) + MAX ( DISTINCT - 6 ) + - COUNT ( * ) / - - ( 77 ) + 37 , 44 , - - 0 * 23 , - - 86 , 3 , - ( SELECT 5 WHERE x = ( SELECT x WHERE x = x ) UNION SELECT 3 LIMIT 1 ) + 0.100000 + 0.100000 + 0.100000 ) FROM ( SELECT substring ( 'Top.Child1.Child2' , 1 , 0 ) FR OM generate_series ( 1 , 40 ) AS x WHERE x BETWEEN 22 AND ( SELECT md5 ( NULL ) WHERE x IN ( SELECT ( row_number ( ) OVER ( ) ) GROUP BY x HAVING NOT x < ANY ( NOT MAX ( 42.400002 ) < AVG ( CAST( NULL AS INT ) ) ) ) ) ) LIMIT 24 ) OR x = 512 ) ---- 512.000 512 _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
