Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
N/A
-
None
-
Not for Release Notes
-
Q4/2025 Server Development
Description
This is likely the same core issue as MDEV-37720.
CREATE GLOBAL TEMPORARY TABLE t1 (c INT) ENGINE=InnoDB; |
CREATE TABLE t2 (c INT) ENGINE=InnoDB; |
LOCK TABLES t1 WRITE, t2 WRITE;
|
CREATE OR REPLACE GLOBAL TEMPORARY TABLE t1 LIKE t2; |
Leads to:
MDEV-35915-8 CS 12.2.0 c7ea08421d34fa7d45e27919a869ade968bd88c4 (Optimized, Clang 21.1.3-20250923) Build 20/10/2025 |
12.2.0-opt>CREATE OR REPLACE GLOBAL TEMPORARY TABLE t1 LIKE t2;
|
ERROR 1005 (HY000): Can't create table `test`.`t1` (errno: 0 "Internal error/check (Not system error)")
|
This does not happen for TT:
CREATE TEMPORARY TABLE t1 (c INT) ENGINE=InnoDB; |
CREATE TABLE t2 (c INT) ENGINE=InnoDB; |
LOCK TABLES t1 WRITE, t2 WRITE;
|
CREATE OR REPLACE TEMPORARY TABLE t1 LIKE t2; |
Which works fine:
MDEV-35915-8 CS 12.2.0 c7ea08421d34fa7d45e27919a869ade968bd88c4 (Optimized, Clang 21.1.3-20250923) Build 20/10/2025 |
12.2.0-opt>CREATE OR REPLACE TEMPORARY TABLE t1 LIKE t2;
|
Query OK, 0 rows affected (0.000 sec)
|
Besides fixing the bug, please also improve the ERROR 1005 to be a user-friendly/understandable error.
Attachments
Issue Links
- is caused by
-
MDEV-35915 Implement Global temporary tables
-
- Stalled
-
-
MDEV-37382 SIGSEGV and UBSAN null-pointer-use in wait_while_table_is_used on CoR GTT
-
- Closed
-