[#MDEV-30773] mysqldump --no-data does not show auto increment counter for unused tables

Why is it important that SHOW CREATE TABLE does show the last auto_increment value?

Yes, its in 10.3 too and probably has been the case since the beginning of auto_increment.

MariaDB [test]> create table t2 (i int primary key auto_increment);

Query OK, 0 rows affected (0.001 sec)

MariaDB [test]> show create table t2\G

*************************** 1. row ***************************

       Table: t2

Create Table: CREATE TABLE `t2` (

  `i` int(11) NOT NULL AUTO_INCREMENT,

  PRIMARY KEY (`i`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

1 row in set (0.001 sec)

MariaDB [test]> insert into t2()  values ();

Query OK, 1 row affected (0.001 sec)

MariaDB [test]> show create table t2\G

*************************** 1. row ***************************

       Table: t2

Create Table: CREATE TABLE `t2` (

  `i` int(11) NOT NULL AUTO_INCREMENT,

  PRIMARY KEY (`i`)

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

1 row in set (0.000 sec)

[MDEV-30773] mysqldump --no-data does not show auto increment counter for unused tables Created: 2023-03-02 Updated: 2023-03-30
Status:	Open
Project:	MariaDB Server
Component/s:	Scripts & Clients
Affects Version/s:	10.3.37
Fix Version/s:	None