Changeset: 3368b2418e32 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/3368b2418e32
Modified Files:
sql/server/rel_exp.c
sql/server/rel_unnest.c
sql/test/BugTracker-2015/Tests/crash.Bug-3736.test
sql/test/BugTracker-2024/Tests/7439-exps-cards-crash.test
sql/test/BugTracker-2025/Tests/7650_right_join_crash.test
sql/test/BugTracker-2025/Tests/7729-tail_type-crash.test
sql/test/BugTracker-2026/Tests/7834-BATsubcross-more-than-one-match.test
sql/test/BugTracker-2026/Tests/7841-BATsubcross-more-than-one-match.test
sql/test/BugTracker-2026/Tests/7849-assertion-failure.test
sql/test/BugTracker-2026/Tests/7854-rcte-trims.test
sql/test/BugTracker-2026/Tests/7857-rollup-crash.test
sql/test/BugTracker-2026/Tests/7859-getModule-crash.test
sql/test/BugTracker-2026/Tests/7861-list_empty-crash.test
sql/test/SQLancer/Tests/sqlancer11.test
sql/test/SQLancer/Tests/sqlancer23.test
sql/test/prepare/Tests/sqlancer_prepare.test
sql/test/rel-optimizers/Tests/groupjoin.test
Branch: unnest2
Log Message:
approved output
diffs (truncated from 367 to 300 lines):
diff --git a/sql/server/rel_exp.c b/sql/server/rel_exp.c
--- a/sql/server/rel_exp.c
+++ b/sql/server/rel_exp.c
@@ -4219,6 +4219,8 @@ free_exp(allocator *sa, sql_exp *e)
e->f = NULL;
}
}
+ if (e->flag & PSM_REL)
+ rel_destroy(NULL, e->l);
break;
case e_column:
break;
diff --git a/sql/server/rel_unnest.c b/sql/server/rel_unnest.c
--- a/sql/server/rel_unnest.c
+++ b/sql/server/rel_unnest.c
@@ -2378,6 +2378,10 @@ rewrite_compare(visitor *v, sql_rel *rel
if (rsq) {
if (!lsq && is_simple_project(rsq->op) &&
!rsq->l) {
sql_exp *ire = rsq->exps->h->data;
+ if (!is_values(ire) && !is_values(le)) {
+ re = ire;
+ rsq =
exp_rel_get_rel(v->sql->sa, re);
+ } else
if (is_values(ire) &&
list_length(ire->f) == 1 && !is_values(le)) {
list *exps = ire->f;
re = exps->h->data;
@@ -3797,6 +3801,13 @@ unnest(visitor *v, sql_rel *parent, sql_
/* handle projection of freevar without lower relation */
if (is_simple_project(rel->op) && !rel->l) {
+ if (is_right(info->info->join->op)) {
+ sql_rel *d = rel_project(v->sql->sa,
rel_dup(info->info->d), rel_projections(v->sql, info->info->d, NULL, 1, 1));
+ add_outers_repr(v, d, info, true);
+ sql_rel *nrel = rel_crossproduct(v->sql->sa, d, rel,
is_right(info->info->join->op) ? info->info->join->op : op_join);
+ rel_update_subrel(parent, rel, nrel);
+ return;
+ }
sql_rel *d = rel->l = rel_project(v->sql->sa,
rel_dup(info->info->d), rel_projections(v->sql, info->info->d, NULL, 1, 1));
add_outers_repr(v, d, info, true);
rel->exps = add_outers(v, rel->exps, info, false);
diff --git a/sql/test/BugTracker-2015/Tests/crash.Bug-3736.test
b/sql/test/BugTracker-2015/Tests/crash.Bug-3736.test
--- a/sql/test/BugTracker-2015/Tests/crash.Bug-3736.test
+++ b/sql/test/BugTracker-2015/Tests/crash.Bug-3736.test
@@ -112,61 +112,67 @@ EXPLAIN SHOW DETAILS
Select b.* FROM open_auctions o, bidder b WHERE (select b3.INCREASE from
bidder b3 where b3.id = (select min (b3a.id) from bidder b3a where
b3a.open_auction_id = o.open_auction_id)) * 2 <= (Select b2.INCREASE from
bidder b2 where b2.id = (SELECT MAX (b2a.id) from bidder b2a where
b2a.open_auction_id = o.open_auction_id)) AND o.open_auction_id =
b.open_auction_id
----
REF 1 (2)
-project (
-| join (
-| | table("sys"."open_auctions") [ "open_auctions"."open_auction_id" NOT NULL
as "o"."open_auction_id", "open_auctions"."%TID%" NOT NULL UNIQUE as
"o"."%TID%" ],
-| | table("sys"."bidder") [ "bidder"."id" NOT NULL UNIQUE HASHCOL as
"b"."id", "bidder"."open_auction_id" NOT NULL as "b"."open_auction_id",
"bidder"."date" NOT NULL as "b"."date", "bidder"."time" NOT NULL as "b"."time",
"bidder"."personref" NOT NULL as "b"."personref", "bidder"."increase" NOT NULL
as "b"."increase", "bidder"."%TID%" NOT NULL UNIQUE as "b"."%TID%" ]
-| ) [ ("o"."open_auction_id" NOT NULL) = ("b"."open_auction_id" NOT NULL) ]
-) [ "o"."open_auction_id" NOT NULL, "b"."id" NOT NULL HASHCOL ,
"b"."open_auction_id" NOT NULL, "b"."date" NOT NULL, "b"."time" NOT NULL,
"b"."personref" NOT NULL, "b"."increase" NOT NULL ]
+table("sys"."open_auctions") [ "open_auctions"."open_auction_id" NOT NULL as
"o"."open_auction_id", "open_auctions"."%TID%" NOT NULL UNIQUE as "o"."%TID%" ]
REF 2 (2)
+group by (
+| & REF 1
+) [ "o"."open_auction_id" NOT NULL ] [ "o"."open_auction_id" NOT NULL ]
+REF 3 (2)
single project (
| single left outer join (
| | & REF 1 ,
| | project (
| | | join (
-| | | | project (
-| | | | | table("sys"."bidder") [ "bidder"."id" NOT NULL UNIQUE HASHCOL as
"b3"."id", "bidder"."increase" NOT NULL as "b3"."increase", "bidder"."%TID%"
NOT NULL UNIQUE as "b3"."%TID%" ]
-| | | | ) [ "b3"."id" NOT NULL UNIQUE HASHCOL , "b3"."increase" NOT NULL,
"b3"."%TID%" NOT NULL UNIQUE, "b3"."increase" NOT NULL as "%3"."%3" ],
+| | | | table("sys"."bidder") [ "bidder"."id" NOT NULL UNIQUE HASHCOL as
"b3"."id", "bidder"."increase" NOT NULL as "b3"."increase" ],
| | | | project (
-| | | | | group by (
-| | | | | | join (
-| | | | | | | table("sys"."bidder") [ "bidder"."id" NOT NULL UNIQUE HASHCOL
as "b3a"."id", "bidder"."open_auction_id" NOT NULL as "b3a"."open_auction_id" ],
-| | | | | | | group by (
-| | | | | | | | & REF 1
-| | | | | | | ) [ "o"."open_auction_id" NOT NULL ] [ "o"."open_auction_id" NOT
NULL ]
-| | | | | | ) [ ("b3a"."open_auction_id" NOT NULL) = ("o"."open_auction_id"
NOT NULL UNIQUE) ]
-| | | | | ) [ "o"."open_auction_id" NOT NULL ] [ "sys"."min" no nil
("b3a"."id" NOT NULL HASHCOL ) NOT NULL as "%1"."%1", "o"."open_auction_id" NOT
NULL ]
-| | | | ) [ "o"."open_auction_id" NOT NULL UNIQUE, "%1"."%1" NOT NULL as
"%2"."%2" ]
-| | | ) [ ("b3"."id" NOT NULL UNIQUE HASHCOL ) = ("%2"."%2" NOT NULL) ]
-| | ) [ "b3"."id" NOT NULL HASHCOL , "b3"."increase" NOT NULL, "b3"."%TID%"
NOT NULL, "%2"."%2" NOT NULL, "%3"."%3" NOT NULL, "o"."open_auction_id" NOT
NULL as "%7"."%7" ]
-| ) [ ("o"."open_auction_id" NOT NULL) * = ("%7"."%7" NOT NULL) ]
-) [ "o"."open_auction_id" NOT NULL, "b"."id" NOT NULL HASHCOL ,
"b"."open_auction_id" NOT NULL, "b"."date" NOT NULL, "b"."time" NOT NULL,
"b"."personref" NOT NULL, "b"."increase" NOT NULL, "%3"."%3" ]
+| | | | | left outer join (
+| | | | | | & REF 2 ,
+| | | | | | group by (
+| | | | | | | project (
+| | | | | | | | join (
+| | | | | | | | | table("sys"."bidder") [ "bidder"."id" NOT NULL UNIQUE
HASHCOL as "b3a"."id", "bidder"."open_auction_id" NOT NULL as
"b3a"."open_auction_id" ],
+| | | | | | | | | & REF 2
+| | | | | | | | ) [ ("b3a"."open_auction_id" NOT NULL) =
("o"."open_auction_id" NOT NULL UNIQUE) ]
+| | | | | | | ) [ "o"."open_auction_id" NOT NULL, "b3a"."id" NOT NULL HASHCOL
]
+| | | | | | ) [ "o"."open_auction_id" NOT NULL ] [ "o"."open_auction_id" NOT
NULL, "sys"."min" no nil ("b3a"."id" NOT NULL UNIQUE HASHCOL ) NOT NULL as
"%1"."%1" ]
+| | | | | ) [ ("o"."open_auction_id" NOT NULL UNIQUE) * =
("o"."open_auction_id" NOT NULL UNIQUE) ]
+| | | | ) [ "o"."open_auction_id" NOT NULL UNIQUE, "%1"."%1" as "%2"."%2" ]
+| | | ) [ ("b3"."id" NOT NULL UNIQUE HASHCOL ) = ("%2"."%2") ]
+| | ) [ "o"."open_auction_id" NOT NULL, "b3"."increase" NOT NULL as "%3"."%3" ]
+| ) [ ("o"."open_auction_id" NOT NULL) * = ("o"."open_auction_id" NOT NULL) ]
+) [ "o"."open_auction_id" NOT NULL, "o"."%TID%" NOT NULL, "%3"."%3" ]
+REF 4 (2)
+single group by (
+| & REF 3
+) [ "o"."open_auction_id" NOT NULL ] [ "o"."open_auction_id" NOT NULL ]
project (
-| select (
-| | single project (
-| | | single left outer join (
-| | | | & REF 2 ,
+| join (
+| | single select (
+| | | single join (
+| | | | & REF 3 ,
| | | | project (
| | | | | join (
-| | | | | | project (
-| | | | | | | table("sys"."bidder") [ "bidder"."id" NOT NULL UNIQUE HASHCOL
as "b2"."id", "bidder"."increase" NOT NULL as "b2"."increase" ]
-| | | | | | ) [ "b2"."id" NOT NULL UNIQUE HASHCOL , "b2"."increase" NOT NULL
as "%6"."%6" ],
+| | | | | | table("sys"."bidder") [ "bidder"."id" NOT NULL UNIQUE HASHCOL as
"b2"."id", "bidder"."increase" NOT NULL as "b2"."increase" ],
| | | | | | project (
-| | | | | | | group by (
-| | | | | | | | join (
-| | | | | | | | | table("sys"."bidder") [ "bidder"."id" NOT NULL UNIQUE
HASHCOL as "b2a"."id", "bidder"."open_auction_id" NOT NULL as
"b2a"."open_auction_id" ],
-| | | | | | | | | single group by (
-| | | | | | | | | | & REF 2
-| | | | | | | | | ) [ "o"."open_auction_id" NOT NULL ] [ "o"."open_auction_id"
NOT NULL ]
-| | | | | | | | ) [ ("b2a"."open_auction_id" NOT NULL) =
("o"."open_auction_id" NOT NULL UNIQUE) ]
-| | | | | | | ) [ "o"."open_auction_id" NOT NULL ] [ "sys"."max" no nil
("b2a"."id" NOT NULL HASHCOL ) NOT NULL as "%4"."%4", "o"."open_auction_id" NOT
NULL ]
-| | | | | | ) [ "o"."open_auction_id" NOT NULL UNIQUE, "%4"."%4" NOT NULL as
"%5"."%5" ]
-| | | | | ) [ ("b2"."id" NOT NULL UNIQUE HASHCOL ) = ("%5"."%5" NOT NULL) ]
-| | | | ) [ "%6"."%6" NOT NULL, "o"."open_auction_id" NOT NULL as "%10"."%10" ]
-| | | ) [ ("o"."open_auction_id" NOT NULL) * = ("%10"."%10" NOT NULL) ]
-| | ) [ "b"."id" NOT NULL HASHCOL , "b"."open_auction_id" NOT NULL, "b"."date"
NOT NULL, "b"."time" NOT NULL, "b"."personref" NOT NULL, "b"."increase" NOT
NULL, "%3"."%3", "%6"."%6" ]
-| ) [ ("sys"."<="("sys"."sql_mul"("%3"."%3", double(53) "2"), "%6"."%6")) =
(boolean(1) "true") ]
-) [ "b"."id" NOT NULL UNIQUE HASHCOL , "b"."open_auction_id" NOT NULL,
"b"."date" NOT NULL, "b"."time" NOT NULL, "b"."personref" NOT NULL,
"b"."increase" NOT NULL ]
+| | | | | | | left outer join (
+| | | | | | | | & REF 4 ,
+| | | | | | | | group by (
+| | | | | | | | | project (
+| | | | | | | | | | join (
+| | | | | | | | | | | table("sys"."bidder") [ "bidder"."id" NOT NULL UNIQUE
HASHCOL as "b2a"."id", "bidder"."open_auction_id" NOT NULL as
"b2a"."open_auction_id" ],
+| | | | | | | | | | | & REF 4
+| | | | | | | | | | ) [ ("b2a"."open_auction_id" NOT NULL) =
("o"."open_auction_id" NOT NULL UNIQUE) ]
+| | | | | | | | | ) [ "o"."open_auction_id" NOT NULL, "b2a"."id" NOT NULL
HASHCOL ]
+| | | | | | | | ) [ "o"."open_auction_id" NOT NULL ] [ "o"."open_auction_id"
NOT NULL, "sys"."max" no nil ("b2a"."id" NOT NULL UNIQUE HASHCOL ) NOT NULL as
"%4"."%4" ]
+| | | | | | | ) [ ("o"."open_auction_id" NOT NULL UNIQUE) * =
("o"."open_auction_id" NOT NULL UNIQUE) ]
+| | | | | | ) [ "o"."open_auction_id" NOT NULL UNIQUE, "%4"."%4" as "%5"."%5" ]
+| | | | | ) [ ("b2"."id" NOT NULL UNIQUE HASHCOL ) = ("%5"."%5") ]
+| | | | ) [ "o"."open_auction_id" NOT NULL, "b2"."increase" NOT NULL as
"%6"."%6" ]
+| | | ) [ ("o"."open_auction_id" NOT NULL) * = ("o"."open_auction_id" NOT
NULL) ]
+| | ) [ ("sys"."<="("sys"."sql_mul"("%3"."%3", double(53) "2"), "%6"."%6" NOT
NULL)) = (boolean(1) "true") ],
+| | table("sys"."bidder") [ "bidder"."id" NOT NULL UNIQUE HASHCOL as
"b"."id", "bidder"."open_auction_id" NOT NULL as "b"."open_auction_id",
"bidder"."date" NOT NULL as "b"."date", "bidder"."time" NOT NULL as "b"."time",
"bidder"."personref" NOT NULL as "b"."personref", "bidder"."increase" NOT NULL
as "b"."increase" ]
+| ) [ ("o"."open_auction_id" NOT NULL) = ("b"."open_auction_id" NOT NULL) ]
+) [ "b"."id" NOT NULL HASHCOL , "b"."open_auction_id" NOT NULL, "b"."date" NOT
NULL, "b"."time" NOT NULL, "b"."personref" NOT NULL, "b"."increase" NOT NULL ]
query ITTTTR nosort
Select b.* FROM open_auctions o, bidder b WHERE (select b3.INCREASE from
bidder b3 where b3.id = (select min(b3a.id) from bidder b3a where
b3a.open_auction_id = o.open_auction_id)) * 2 <= (Select b2.INCREASE from
bidder b2 where b2.id = (SELECT MAX(b2a.id) from bidder b2a where
b2a.open_auction_id = o.open_auction_id)) AND o.open_auction_id =
b.open_auction_id order by date, time
diff --git a/sql/test/BugTracker-2024/Tests/7439-exps-cards-crash.test
b/sql/test/BugTracker-2024/Tests/7439-exps-cards-crash.test
--- a/sql/test/BugTracker-2024/Tests/7439-exps-cards-crash.test
+++ b/sql/test/BugTracker-2024/Tests/7439-exps-cards-crash.test
@@ -1,7 +1,7 @@
statement ok
CREATE TABLE v0 ( v1 oid )
-statement ok
+statement error 42000!SELECT: cannot use non GROUP BY column 'v0.v1' in query
results without an aggregate function
DELETE FROM v0 WHERE NOT ( v1 IN ( SELECT MAX ( DISTINCT ( SELECT NULL WHERE
v1 AND v1 = 'aggordview1' GROUP BY v1 ) ) FROM v0 ) )
statement ok
diff --git a/sql/test/BugTracker-2025/Tests/7650_right_join_crash.test
b/sql/test/BugTracker-2025/Tests/7650_right_join_crash.test
--- a/sql/test/BugTracker-2025/Tests/7650_right_join_crash.test
+++ b/sql/test/BugTracker-2025/Tests/7650_right_join_crash.test
@@ -3,6 +3,10 @@ CREATE TABLE IF NOT EXISTS t1(c0 INTERVA
# error because the relational algebra doesn't allow for perfect lazy
evaluation always
# sql correct result should be: NULL | NULL | 0
-statement error /more than one match/
+# statement error /more than one match/
+query TTI
SELECT ALL * FROM t1 RIGHT JOIN (VALUES (0)) AS subQuery1(col_1) ON ( t1.c0 <
ANY(VALUES (t1.c0+t1.c0)) ) AND (VALUES (subQuery1.col_1), (EXISTS (VALUES
(t1.c2))) )
-
+----
+NULL
+NULL
+0
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
@@ -1,3 +1,4 @@
--- Segmentation fault in tail_type (st=0x0) at
sql/backends/monet5/sql_statement.c:4647 switch (st->type) {
-statement error 22018!conversion of string to type bte failed.
+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
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,5 +1,15 @@
-statement error 42000!row frame bound must be non negative and non null.
+query III
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
+----
+0
+0
+NULL
+1
+1
+NULL
+3
+3
+NULL
onlyif has-hugeintxs
query T
diff --git
a/sql/test/BugTracker-2026/Tests/7841-BATsubcross-more-than-one-match.test
b/sql/test/BugTracker-2026/Tests/7841-BATsubcross-more-than-one-match.test
--- a/sql/test/BugTracker-2026/Tests/7841-BATsubcross-more-than-one-match.test
+++ b/sql/test/BugTracker-2026/Tests/7841-BATsubcross-more-than-one-match.test
@@ -1,3 +1,12 @@
-statement error GDK reported error: BATsubcross: more than one match
+query III
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 CAST( ( ltrim ( 75.500000 ,
NULL ) = - 14 - - 'c' / 46 AND x = 288 AND x = 764 AND x = 35 AND x = 594 ) AS
INT ) AS x 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
-
+----
+0
+0
+NULL
+1
+1
+NULL
+3
+3
+NULL
diff --git a/sql/test/BugTracker-2026/Tests/7849-assertion-failure.test
b/sql/test/BugTracker-2026/Tests/7849-assertion-failure.test
--- a/sql/test/BugTracker-2026/Tests/7849-assertion-failure.test
+++ b/sql/test/BugTracker-2026/Tests/7849-assertion-failure.test
@@ -118,10 +118,6 @@ WHERE EXISTS (
)
----
1
-1
-1
-1
-1
statement ok
DROP TABLE orders
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,4 +1,5 @@
-query RII
+#query RII
+statement error 42000!Decimal (x) doesn't have format (38.6)
SELECT CAST(sum (x) AS NUMERIC),
avg (x) , var_pop (x)
FROM
@@ -50,7 +51,7 @@ FROM
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
-0
+#----
+#512.000
+#512
+#0
diff --git a/sql/test/BugTracker-2026/Tests/7857-rollup-crash.test
b/sql/test/BugTracker-2026/Tests/7857-rollup-crash.test
--- a/sql/test/BugTracker-2026/Tests/7857-rollup-crash.test
+++ b/sql/test/BugTracker-2026/Tests/7857-rollup-crash.test
@@ -1,8 +1,9 @@
statement error 22018!conversion of string ...
SELECT * FROM ( SELECT * FROM ( SELECT 1 AS x ) WHERE x IN ( SELECT ALL
sql_min ( NULL , NULL ) FROM ( SELECT * FROM ( WITH x AS ( SELECT 1 ) SELECT (
SELECT CASE WHEN NOT NULL THEN 4 * - 48 * 51 * - - 54 * - 77 * 46 WHEN NOT (
NULL ) IN ( - ( - - 49 ) * - 1 , - 41 , - 14 % - CASE - - 1 WHEN - - 82 THEN -
22 ^ COUNT ( * ) END / 46 - - 87 * 52 ) THEN 56 ELSE NULL END FROM ( SELECT SUM
( 0 ) OVER ( ORDER BY SUM ( '$.f2' BETWEEN 1 AND 1 ) ) FROM x GROUP BY rollup (
x , x ) ORDER BY x , x , x ) , ( SELECT x AS x ) WHERE x = 'x' ) , 'x' FROM x )
WHERE ( x % 7 ) = 0 ) ) )
-statement error 22018!conversion of string to type bte failed.
+query I nosort
SELECT * FROM ( SELECT * FROM ( SELECT 1 AS x ) WHERE x IN ( SELECT ALL
sql_min ( NULL , NULL ) FROM ( SELECT * FROM ( WITH x AS ( SELECT 1 ) SELECT (
SELECT CASE WHEN NOT NULL THEN 4 * - 48 * 51 * - - 54 * - 77 * 46 WHEN NOT (
NULL ) IN ( - ( - - 49 ) * - 1 , - 41 , - 14 % - CASE - - 1 WHEN - - 82 THEN -
22 ^ COUNT ( * ) END / 46 - - 87 * 52 ) THEN 56 ELSE NULL END FROM ( SELECT SUM
( 0 ) OVER ( ORDER BY SUM ( '$.f2' BETWEEN 1 AND 1 ) ) FROM x GROUP BY rollup (
x , x ) ORDER BY x , x , x ) , ( SELECT x AS x ) WHERE x = x ) , 'x' FROM x )
WHERE ( x % 7 ) = 0 ) ) )
+----
query I nosort
SELECT * FROM ( SELECT * FROM ( SELECT 1 AS x ) WHERE x IN ( SELECT ALL
sql_min ( NULL , NULL ) FROM ( SELECT * FROM ( WITH x AS ( SELECT 1 ) SELECT (
SELECT CASE WHEN NOT NULL THEN 4 * - 48 * 51 * - - 54 * - 77 * 46 WHEN NOT (
NULL ) IN ( - ( - - 49 ) * - 1 , - 41 , - 14 % - CASE - - 1 WHEN - - 82 THEN -
22 ^ COUNT ( * ) END / 46 - - 87 * 52 ) THEN 56 ELSE NULL END FROM ( SELECT SUM
( 0 ) OVER ( ORDER BY SUM ( 2 BETWEEN 1 AND 1 ) ) FROM x GROUP BY rollup ( x ,
x ) ORDER BY x , x , x ) , ( SELECT x AS x ) WHERE x = x ) , 'x' FROM x ) WHERE
( x % 7 ) = 0 ) ) )
diff --git a/sql/test/BugTracker-2026/Tests/7859-getModule-crash.test
b/sql/test/BugTracker-2026/Tests/7859-getModule-crash.test
--- a/sql/test/BugTracker-2026/Tests/7859-getModule-crash.test
+++ b/sql/test/BugTracker-2026/Tests/7859-getModule-crash.test
@@ -12,11 +12,11 @@ SELECT x NOT IN (
, CASE WHEN x > 12 THEN 1 ELSE 0 END AS x
FROM ( SELECT 10 AS x UNION SELECT 11 AS x UNION SELECT 12 AS x UNION SELECT
13 AS x )
----
-NULL
+1
0
-NULL
+1
0
-NULL
+1
0
-NULL
1
+1
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
