Changeset: f714124b9e7d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/f714124b9e7d
Modified Files:
sql/test/BugTracker-2025/Tests/All
sql/test/BugTracker-2026/Tests/All
Branch: default
Log Message:
Merge with Dec2025 branch.
diffs (truncated from 409 to 300 lines):
diff --git a/sql/test/BugTracker-2025/Tests/7724-sql_ref_inc-error.test
b/sql/test/BugTracker-2025/Tests/7724-sql_ref_inc-error.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2025/Tests/7724-sql_ref_inc-error.test
@@ -0,0 +1,9 @@
+-- GDK reported error: selectjoin: more than one match
+statement error /more than one match/
+SELECT ( WITH x ( x ) AS ( SELECT 1 )
+ SELECT 16 FROM x
+ WHERE ( SELECT ( SELECT * FROM generate_series ( 32989 , x = ( SELECT (
WITH x AS ( SELECT x ) SELECT x GROUP BY x HAVING ( ( SELECT ( SELECT x ) ) ) )
) ) )
+ GROUP BY x + 1 , x
+ )
+ )
+
diff --git a/sql/test/BugTracker-2025/Tests/7729-tail_type-crash.test
b/sql/test/BugTracker-2025/Tests/7729-tail_type-crash.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2025/Tests/7729-tail_type-crash.test
@@ -0,0 +1,5 @@
+-- Segmentation fault in tail_type (st=0x0) at
sql/backends/monet5/sql_statement.c:4647 switch (st->type) {
+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 )
+----
+
diff --git a/sql/test/BugTracker-2025/Tests/All
b/sql/test/BugTracker-2025/Tests/All
--- a/sql/test/BugTracker-2025/Tests/All
+++ b/sql/test/BugTracker-2025/Tests/All
@@ -66,8 +66,10 @@ HAVE_HGE?7637_str_to_decimal
7719-crash-in-complex-query
7720-coalesce
7722-recusive-cte-with-error-crash
+7724-sql_ref_inc-error
7725-crash-find-rel-ref
7726-commonterms
+KNOWNFAIL?7729-tail_type-crash
7730-generate-series-month-int
7732-table-exp-issue
7734-epoch-missing-cast
diff --git a/sql/test/BugTracker-2026/Tests/7890-insert-exists-issue.test
b/sql/test/BugTracker-2026/Tests/7890-insert-exists-issue.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2026/Tests/7890-insert-exists-issue.test
@@ -0,0 +1,114 @@
+statement ok
+DROP TABLE IF EXISTS t2
+
+statement ok
+DROP TABLE IF EXISTS t3
+
+statement ok
+CREATE TABLE t2(
+ c1 INT NOT NULL,
+ c2 INT,
+ c15 DOUBLE,
+ PRIMARY KEY(c1)
+)
+
+statement ok
+CREATE TABLE t3(
+ c5 TIMESTAMP
+)
+
+statement ok rowcount 6
+INSERT INTO t2(c1,c2,c15) VALUES
+ (1,3,599.0),
+ (2,4,375.0),
+ (3,4,789.0),
+ (4,3,435.0),
+ (5,2,NULL),
+ (6,2,827.0)
+
+statement ok rowcount 6
+INSERT INTO t3(c5) VALUES
+ (TIMESTAMP '2002-11-29 06:01:10'),
+ (TIMESTAMP '2009-02-17 14:54:39'),
+ (TIMESTAMP '2012-02-14 07:00:27'),
+ (TIMESTAMP '2005-01-28 21:54:29'),
+ (NULL),
+ (TIMESTAMP '2012-02-14 07:00:27')
+
+-- original
+statement ok rowcount 5
+INSERT INTO t2(c1,c2)
+SELECT c1+33,c2 FROM t2
+WHERE c15 IS NOT NULL
+AND EXISTS(
+ SELECT c5 FROM t3
+ UNION
+ SELECT * FROM (
+ SELECT k FROM (
+ SELECT c5 k, c5 FROM t3
+ EXCEPT
+ SELECT c5, c5 FROM t3
+ ) a
+ WHERE k BETWEEN DATE '2000-01-01' AND DATE '2030-01-01'
+ INTERSECT
+ SELECT c5 FROM t3 WHERE 1=0
+ ) s
+)
+
+query II rowsort
+SELECT c1,c2 FROM t2 WHERE c1>=34 ORDER BY c1
+----
+34
+3
+35
+4
+36
+4
+37
+3
+39
+2
+
+statement ok rowcount 5
+DELETE FROM t2 WHERE c1>=34
+
+-- mutated
+statement ok rowcount 5
+INSERT INTO t2(c1,c2)
+SELECT c1+33,c2 FROM t2
+WHERE c15 IS NOT NULL
+AND EXISTS(
+ SELECT c5 FROM t3
+ UNION
+ SELECT * FROM (
+ SELECT k FROM (
+ SELECT c5 k, c5 FROM t3
+ EXCEPT
+ SELECT c5, c5 FROM t3
+ ) a
+ WHERE 1=0 AND k BETWEEN DATE '2000-01-01' AND DATE '2030-01-01'
+ INTERSECT
+ SELECT c5 FROM t3 WHERE 1=0
+ ) s
+)
+
+query II rowsort
+SELECT c1,c2 FROM t2 WHERE c1>=34 ORDER BY c1
+----
+34
+3
+35
+4
+36
+4
+37
+3
+39
+2
+
+statement ok
+DROP TABLE t2
+
+statement ok
+DROP TABLE t3
+
diff --git a/sql/test/BugTracker-2026/Tests/7891-update-issue.test
b/sql/test/BugTracker-2026/Tests/7891-update-issue.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2026/Tests/7891-update-issue.test
@@ -0,0 +1,116 @@
+statement ok
+DROP TABLE IF EXISTS t2
+
+statement ok
+DROP TABLE IF EXISTS t1
+
+statement ok
+CREATE TABLE t1(
+ c1 INT,
+ c3 VARCHAR(100),
+ c4 INT,
+ c6 VARCHAR(100)
+)
+
+statement ok
+CREATE TABLE t2(
+ c1 INT,
+ c2 INT,
+ c6 VARCHAR(100),
+ c13 TIMESTAMP
+)
+
+statement ok rowcount 2
+INSERT INTO t1 VALUES
+ (4, 'x', 1, 'rpuirlu'),
+ (8, 'y', 1, 'trc')
+
+statement ok rowcount 3
+INSERT INTO t2 VALUES
+ (3, 4, NULL, TIMESTAMP '2002-09-11 17:01:39'),
+ (8, 8, 'egculthpiak', TIMESTAMP '2002-05-04 20:51:45'),
+ (1, 6, 'tdingsooyv', TIMESTAMP '2010-04-13 15:30:07')
+
+-- original
+statement ok rowcount 2
+UPDATE t2
+SET c6 = d.v, c2 = ABS(d.k)
+FROM (
+ SELECT c1 AS k, LOWER(c6) AS v
+ FROM t1
+) AS d
+WHERE
+ (
+ NOT t2.c13 BETWEEN TIMESTAMP '2007-09-07 20:32:59'
+ AND TIMESTAMP '2024-07-12 00:28:28'
+ OR (
+ CAST('2003-02-07 23:56:12' AS TIMESTAMP)
+ BETWEEN TIMESTAMP '2003-05-29 18:50:56'
+ AND TIMESTAMP '2007-02-14 04:35:02'
+ )
+ )
+ AND t2.c2 = d.k
+
+query IIT rowsort
+SELECT c1, c2, c6 FROM t2 ORDER BY c1
+----
+1
+6
+tdingsooyv
+3
+4
+rpuirlu
+8
+8
+trc
+
+statement ok rowcount 3
+DELETE FROM t2
+
+statement ok rowcount 3
+INSERT INTO t2 VALUES
+ (3, 4, NULL, TIMESTAMP '2002-09-11 17:01:39'),
+ (8, 8, 'egculthpiak', TIMESTAMP '2002-05-04 20:51:45'),
+ (1, 6, 'tdingsooyv', TIMESTAMP '2010-04-13 15:30:07');
+
+-- rewritten / mutated
+statement ok rowcount 2
+UPDATE t2
+SET c6 = d.v, c2 = ABS(d.k)
+FROM (
+ SELECT c1 AS k, LOWER(c6) AS v
+ FROM t1
+) AS d
+WHERE
+ (
+ NOT (
+ t2.c13 > TIMESTAMP '2007-09-07 20:32:59'
+ AND t2.c13 < TIMESTAMP '2024-07-12 00:28:28'
+ )
+ OR (
+ CAST('2003-02-07 23:56:12' AS TIMESTAMP)
+ BETWEEN TIMESTAMP '2003-05-29 18:50:56'
+ AND TIMESTAMP '2007-02-14 04:35:02'
+ )
+ )
+ AND t2.c2 = d.k
+
+query IIT rowsort
+SELECT c1, c2, c6 FROM t2 ORDER BY c1
+----
+1
+6
+tdingsooyv
+3
+4
+rpuirlu
+8
+8
+trc
+
+statement ok
+DROP TABLE t2
+
+statement ok
+DROP TABLE t1
+
diff --git a/sql/test/BugTracker-2026/Tests/All
b/sql/test/BugTracker-2026/Tests/All
--- a/sql/test/BugTracker-2026/Tests/All
+++ b/sql/test/BugTracker-2026/Tests/All
@@ -76,3 +76,5 @@ KNOWNFAIL?7774-insert-into-renamed-table
7886-local-view-in-with
7888-or-false-write
7889-delete-with-union-intersect
+7890-insert-exists-issue
+KNOWNFAIL?7891-update-issue
diff --git a/testing/Mtest.py.in b/testing/Mtest.py.in
--- a/testing/Mtest.py.in
+++ b/testing/Mtest.py.in
@@ -696,38 +696,43 @@ def CreateTstWhatXhtml(env, TST, stableW
Element('a', {'href': '%s%s.diff.html' % (TST, WHAT),
'target': target,
'class': diffclass},
- Text(difftext)),
- Text(' between '),
- Element('a', {'href': '%s%s' % (TST, stableWHAT),
- 'target': target},
- Text(stableWHAT[1:])))
- if REV:
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
