Changeset: 0eae52ea1a6d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/0eae52ea1a6d
Added Files:
sql/test/BugTracker-2024/Tests/7569-temp-table-column-reuse.test
Modified Files:
sql/test/BugTracker-2024/Tests/All
testing/sqllogictest.py
Branch: Aug2024
Log Message:
Test for bug #7569.
diffs (47 lines):
diff --git a/sql/test/BugTracker-2024/Tests/7569-temp-table-column-reuse.test
b/sql/test/BugTracker-2024/Tests/7569-temp-table-column-reuse.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2024/Tests/7569-temp-table-column-reuse.test
@@ -0,0 +1,23 @@
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TEMPORARY TABLE nums(x INT, y INT)
+
+statement ok
+INSERT INTO nums
+SELECT value AS x, value AS y
+FROM sys.generate_series(0, 1)
+
+statement ok
+UPDATE nums SET y = 100
+
+query II nosort
+SELECT * FROM nums
+----
+0
+100
+
+statement ok
+ROLLBACK
+
diff --git a/sql/test/BugTracker-2024/Tests/All
b/sql/test/BugTracker-2024/Tests/All
--- a/sql/test/BugTracker-2024/Tests/All
+++ b/sql/test/BugTracker-2024/Tests/All
@@ -84,3 +84,4 @@ 7556-missing-ignore-case
7465-fwf-block-boundary-error
7566-connections-refused
7562-interval-overflow
+7569-temp-table-column-reuse
diff --git a/testing/sqllogictest.py b/testing/sqllogictest.py
--- a/testing/sqllogictest.py
+++ b/testing/sqllogictest.py
@@ -769,6 +769,7 @@ class SQLLogic:
if line == '\n':
self.writeline()
continue
+ self.qline = self.line
conn = None
# look for connection string
if line.startswith('@connection'):
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
