Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL)
-
None
Description
SHOW CREATE TABLE should not be usable for hidden I_S tables.
In sql_show.cc, some I_S tables are defined as hidden in ST_SCHEMA_TABLE schema_tables[]:
They are not shown with SHOW TABLES
MariaDB [information_schema]> show tables like "OPEN_TABLES";
|
Empty set (0.001 sec)
|
But you can use SHOW CREATE TABLE
MariaDB [information_schema]> show create table OPEN_TABLES\G
|
*************************** 1. row ***************************
|
Table: OPEN_TABLES
|
Create Table: CREATE TEMPORARY TABLE `OPEN_TABLES` (
|
`Database` varchar(64) NOT NULL,
|
`Table` varchar(64) NOT NULL,
|
`In_use` bigint(1) NOT NULL,
|
`Name_locked` bigint(4) NOT NULL
|
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci
|
1 row in set (0.001 sec)
|
Only tried with 10.6.14 and 11.2.0 (preview)