Details
-
Bug
-
Status: In Testing (View Workflow)
-
Critical
-
Resolution: Unresolved
-
N/A
Description
SET autocommit=0; |
# Original
|
CREATE GLOBAL TEMPORARY TABLE t (c INT) ON COMMIT DELETE ROWS; |
INSERT INTO t VALUES (1); |
SELECT COUNT(*) FROM t; -- 1, correct |
# Drop |
DROP TABLE t; |
# Repeat
|
CREATE GLOBAL TEMPORARY TABLE t (c INT) ON COMMIT DELETE ROWS; |
INSERT INTO t VALUES (1); |
SELECT COUNT(*) FROM t; -- 0, incorrect |
Leads to:
|
MDEV-35915-v11 CS 12.2.0 033918c96079e4e39e9aabb0d94c077b8ec9470c (Optimized, Clang 21.1.3-20250923) Build 14/01/2026 |
12.2.0-opt>SET autocommit=0;
|
Query OK, 0 rows affected (0.000 sec)
|
|
|
12.2.0-opt># Original
|
12.2.0-opt>CREATE GLOBAL TEMPORARY TABLE t (c INT) ON COMMIT DELETE ROWS;
|
Query OK, 0 rows affected (0.011 sec)
|
|
|
12.2.0-opt>INSERT INTO t VALUES (1);
|
Query OK, 1 row affected (0.000 sec)
|
|
|
12.2.0-opt>SELECT COUNT(*) FROM t; -- 1, correct
|
+----------+
|
| COUNT(*) |
|
+----------+
|
| 1 |
|
+----------+
|
1 row in set (0.000 sec)
|
|
|
12.2.0-opt># Drop
|
12.2.0-opt>DROP TABLE t;
|
Query OK, 0 rows affected (0.005 sec)
|
|
|
12.2.0-opt># Repeat
|
12.2.0-opt>CREATE GLOBAL TEMPORARY TABLE t (c INT) ON COMMIT DELETE ROWS;
|
Query OK, 0 rows affected (0.005 sec)
|
|
|
12.2.0-opt>INSERT INTO t VALUES (1);
|
Query OK, 1 row affected (0.000 sec)
|
|
|
12.2.0-opt>SELECT COUNT(*) FROM t; -- 0, incorrect
|
+----------+
|
| COUNT(*) |
|
+----------+
|
| 0 |
|
+----------+
|
1 row in set (0.001 sec)
|
Testcase is CLI and MTR compatible. Adding COMMIT after the DROP TABLE makes no difference.
Attachments
Issue Links
- is caused by
-
MDEV-35915 Implement Global temporary tables
-
- In Testing
-