Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
13.0
-
None
-
Not for Release Notes
-
Q3/2026 Server Maintenance
Description
MTR test
CREATE GLOBAL TEMPORARY TABLE gtt (id INT) ON COMMIT PRESERVE ROWS; |
INSERT INTO gtt VALUES (1); |
--ERROR ER_TABLE_IN_USE
|
DROP TABLE gtt; -- ER_TABLE_IN_USE (4256) |
DROP DATABASE test; -- SUCCEEDS (bypasses the guard) |
13.0.0-opt>CREATE GLOBAL TEMPORARY TABLE gtt (id INT) ON COMMIT PRESERVE ROWS; |
Query OK, 0 rows affected (0.014 sec) |
|
|
13.0.0-opt>INSERT INTO gtt VALUES (1); |
Query OK, 1 row affected (0.001 sec)
|
|
|
13.0.0-opt>DROP TABLE gtt; |
ERROR 4256 (HY000): Table `test`.`gtt` is in use. |
13.0.0-opt>DROP DATABASE test; |
Query OK, 1 row affected (0.014 sec)
|
|
|
13.0.0-opt>
|
Attachments
Issue Links
- is caused by
-
MDEV-35915 Implement Global temporary tables
-
- Stalled
-