Bug #108014 CREATE TABLE ... LIKE misses AUTO_INCREAMENT information

• Submitted: 28 Jul 2022 9:24
• Modified: 28 Jul 2022 12:07
• Reporter: Xiong Wang
• Status: Verified
• Category: MySQL Server: DDL
• Severity: S3 (Non-critical)
• Version: 8.0.30, 5.7.39
• OS: Any
• CPU Architecture: Any

[28 Jul 2022 9:24] Xiong Wang

Description:
mysql> create table test2 (a int NOT NULL AUTO_INCREMENT primary key,b int) AUTO_INCREMENT=10;
Query OK, 0 rows affected (0.01 sec)

mysql> insert into test2(b) values(1);
Query OK, 1 row affected (0.01 sec)

mysql> select * from test2;
+----+------+
| a  | b    |
+----+------+
| 10 |    1 |
+----+------+
1 row in set (0.00 sec)

mysql> create table test3 like test2;
Query OK, 0 rows affected (0.02 sec)

mysql> show create table test3;
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                                                             |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| test3 | CREATE TABLE `test3` (
  `a` int NOT NULL AUTO_INCREMENT,
  `b` int DEFAULT NULL,
  PRIMARY KEY (`a`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> show create table test2;
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                                                                               |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| test2 | CREATE TABLE `test2` (
  `a` int NOT NULL AUTO_INCREMENT,
  `b` int DEFAULT NULL,
  PRIMARY KEY (`a`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

How to repeat:
As the description.

[28 Jul 2022 12:07] MySQL Verification Team

Hello Xiong Wang,

Thank you for the report and feedback.

regards,
Umesh