Changeset: 631d1c86362c for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/631d1c86362c
Modified Files:
sql/test/BugTracker-2026/Tests/7850-assertion-failure.test
sql/test/BugTracker-2026/Tests/7854-rcte-trims.test
Branch: default
Log Message:
fixed test for recent changes to automatic type conversions
diffs (72 lines):
diff --git a/sql/test/BugTracker-2026/Tests/7850-assertion-failure.test
b/sql/test/BugTracker-2026/Tests/7850-assertion-failure.test
--- a/sql/test/BugTracker-2026/Tests/7850-assertion-failure.test
+++ b/sql/test/BugTracker-2026/Tests/7850-assertion-failure.test
@@ -105,7 +105,7 @@ WHERE
(subq_0.c0 >= subq_0.c3)
OR
(
- 0
+ '0'
>=
CASE
WHEN ref_0.id IS NOT NULL
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,55 @@
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 , 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 )
+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)
+ FROM generate_series (1, 40) AS x
+ WHERE x BETWEEN cast(22 as VARCHAR) AND
+ (SELECT md5 (NULL)
+ WHERE x IN
+ (SELECT cast (row_number () OVER () as VARCHAR)
+ GROUP BY x
+ HAVING NOT x < ANY( CAST(NOT MAX (42.400002) < AVG
(CAST(NULL AS DOUBLE))as VARCHAR)))))
+ LIMIT 24)
+ OR x = cast(512 as varchar));
----
512.000
512
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
