Changeset: 21057e375023 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/21057e375023 Added Files: sql/test/BugTracker-2026/Tests/7979-prepare-error-exec-113.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
add test for issue #7979, bug was fixed by no longer adding a forward reference for prepare statement (as those cannot be recursive anyway). diffs (truncated from 1944 to 300 lines): diff --git a/sql/test/BugTracker-2026/Tests/7979-prepare-error-exec-113.test b/sql/test/BugTracker-2026/Tests/7979-prepare-error-exec-113.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/7979-prepare-error-exec-113.test @@ -0,0 +1,1931 @@ +statement ok +create table info ( attribute int ) + +query TIITTT +PREPARE WITH x as (SELECT 1) SELECT 1 as n, row_number() over() as rn FROM (SELECT * FROM x, info where 0 = info.attribute) as z +---- +tinyint +1 +0 +(empty) +(empty) +n +int +31 +0 +(empty) +(empty) +rn + +query TIITTT +PREPARE WITH x as (SELECT 1) SELECT 1 as n, row_number() over() as rn FROM (SELECT * FROM x, info where 0 = info.attribute) as z +---- +tinyint +1 +0 +(empty) +(empty) +n +int +31 +0 +(empty) +(empty) +rn + +query TIITTT +PREPARE WITH x as (SELECT 1) SELECT 1 as n, row_number() over() as rn FROM (SELECT * FROM x, info where 0 = info.attribute) as z +---- +tinyint +1 +0 +(empty) +(empty) +n +int +31 +0 +(empty) +(empty) +rn + +query TIITTT +PREPARE WITH x as (SELECT 1) SELECT 1 as n, row_number() over() as rn FROM (SELECT * FROM x, info where 0 = info.attribute) as z +---- +tinyint +1 +0 +(empty) +(empty) +n +int +31 +0 +(empty) +(empty) +rn + +query TIITTT +PREPARE WITH x as (SELECT 1) SELECT 1 as n, row_number() over() as rn FROM (SELECT * FROM x, info where 0 = info.attribute) as z +---- +tinyint +1 +0 +(empty) +(empty) +n +int +31 +0 +(empty) +(empty) +rn + +query TIITTT +PREPARE WITH x as (SELECT 1) SELECT 1 as n, row_number() over() as rn FROM (SELECT * FROM x, info where 0 = info.attribute) as z +---- +tinyint +1 +0 +(empty) +(empty) +n +int +31 +0 +(empty) +(empty) +rn + +query TIITTT +PREPARE WITH x as (SELECT 1) SELECT 1 as n, row_number() over() as rn FROM (SELECT * FROM x, info where 0 = info.attribute) as z +---- +tinyint +1 +0 +(empty) +(empty) +n +int +31 +0 +(empty) +(empty) +rn + +query TIITTT +PREPARE WITH x as (SELECT 1) SELECT 1 as n, row_number() over() as rn FROM (SELECT * FROM x, info where 0 = info.attribute) as z +---- +tinyint +1 +0 +(empty) +(empty) +n +int +31 +0 +(empty) +(empty) +rn + +query TIITTT +PREPARE WITH x as (SELECT 1) SELECT 1 as n, row_number() over() as rn FROM (SELECT * FROM x, info where 0 = info.attribute) as z +---- +tinyint +1 +0 +(empty) +(empty) +n +int +31 +0 +(empty) +(empty) +rn + +query TIITTT +PREPARE WITH x as (SELECT 1) SELECT 1 as n, row_number() over() as rn FROM (SELECT * FROM x, info where 0 = info.attribute) as z +---- +tinyint +1 +0 +(empty) +(empty) +n +int +31 +0 +(empty) +(empty) +rn + +query TIITTT +PREPARE WITH x as (SELECT 1) SELECT 1 as n, row_number() over() as rn FROM (SELECT * FROM x, info where 0 = info.attribute) as z +---- +tinyint +1 +0 +(empty) +(empty) +n +int +31 +0 +(empty) +(empty) +rn + +query TIITTT +PREPARE WITH x as (SELECT 1) SELECT 1 as n, row_number() over() as rn FROM (SELECT * FROM x, info where 0 = info.attribute) as z +---- +tinyint +1 +0 +(empty) +(empty) +n +int +31 +0 +(empty) +(empty) +rn + +query TIITTT +PREPARE WITH x as (SELECT 1) SELECT 1 as n, row_number() over() as rn FROM (SELECT * FROM x, info where 0 = info.attribute) as z +---- +tinyint +1 +0 +(empty) +(empty) +n +int +31 +0 +(empty) +(empty) +rn + +query TIITTT +PREPARE WITH x as (SELECT 1) SELECT 1 as n, row_number() over() as rn FROM (SELECT * FROM x, info where 0 = info.attribute) as z +---- +tinyint +1 +0 +(empty) +(empty) +n +int +31 +0 +(empty) +(empty) +rn + +query TIITTT +PREPARE WITH x as (SELECT 1) SELECT 1 as n, row_number() over() as rn FROM (SELECT * FROM x, info where 0 = info.attribute) as z +---- +tinyint +1 +0 +(empty) +(empty) +n +int +31 +0 +(empty) +(empty) +rn + +query TIITTT +PREPARE WITH x as (SELECT 1) SELECT 1 as n, row_number() over() as rn FROM (SELECT * FROM x, info where 0 = info.attribute) as z +---- +tinyint +1 +0 +(empty) +(empty) +n +int +31 +0 +(empty) +(empty) +rn + +query TIITTT +PREPARE WITH x as (SELECT 1) SELECT 1 as n, row_number() over() as rn FROM (SELECT * FROM x, info where 0 = info.attribute) as z +---- +tinyint +1 +0 +(empty) +(empty) +n +int +31 +0 +(empty) +(empty) +rn + +query TIITTT +PREPARE WITH x as (SELECT 1) SELECT 1 as n, row_number() over() as rn FROM (SELECT * FROM x, info where 0 = info.attribute) as z +---- +tinyint +1 +0 +(empty) +(empty) +n +int +31 +0 +(empty) +(empty) +rn + +query TIITTT +PREPARE WITH x as (SELECT 1) SELECT 1 as n, row_number() over() as rn FROM (SELECT * FROM x, info where 0 = info.attribute) as z +---- +tinyint _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
