Description:
Hi,
igor@WaylandGnome ~ $ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 16
Server version: 8.0.32 Gentoo Linux mysql-8.0.32-r2
Copyright (c) 2000, 2023, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> SELECT t.table_catalog AS catalog, t.table_schema, t.table_name, "" AS owner, CASE WHEN t.engine = 'InnoDB' THEN (SELECT st.table_id FROM information_schema.INNODB_TABLES st WHERE CONCAT(t.table_schema,'/', t.table_name) = st.name) ELSE (SELECT 0) END AS id FROM information_schema.tables t;
+---------+--------------------+------------------------------------------------------+-------+------+
| catalog | TABLE_SCHEMA | TABLE_NAME | owner | id |
+---------+--------------------+------------------------------------------------------+-------+------+
| def | draft | abcatcol | | 1093 |
| def | draft | abcatedt | | 1094 |
| def | draft | abcatfmt | | 1095 |
| def | draft | abcattbl | | 1112 |
| def | draft | abcatvld | | 1096 |
| def | draft | abcß | | NULL |
mysql> SELECT * FROM information_schema.INNODB_TABLES st;
+----------+------------------------------------------------------------+------+--------+------------+------------+---------------+------------+--------------+--------------------+
| TABLE_ID | NAME | FLAG | N_COLS | SPACE | ROW_FORMAT | ZIP_PAGE_SIZE | SPACE_TYPE | INSTANT_COLS | TOTAL_ROW_VERSIONS |
+----------+------------------------------------------------------------+------+--------+------------+------------+---------------+------------+--------------+--------------------+
| 1089 | draft/abc@1j | 33 | 5 | 24 | Dynamic | 0 | Single | 0 | 0 |
How to repeat:
CREATE TABLE abcß(id integer primary key, name text);
Then run the 2 queries above.
© 2026, Oracle Corporation and/or its affiliates