[Bug]: Show Create table Result Error

[qingxinhome]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Branch Name

main, 1.2-dev

Commit ID

9571a73

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

mysql> CREATE TABLE t (
-> id INT PRIMARY KEY,
-> a VARCHAR(30) NULL default 'foo',
-> b VARCHAR(30) NOT NULL default 'foo',
-> c INT NULL DEFAULT 1000,
-> d INT NOT NULL DEFAULT 2000
-> );
Query OK, 0 rows affected (0.35 sec)

mysql> show create table t;
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| t | CREATE TABLE t (
id INT NOT NULL,
a VARCHAR(30) DEFAULT 'foo',
b VARCHAR(30) DEFAULT 'foo',
c INT DEFAULT 1000,
d INT DEFAULT 2000,
PRIMARY KEY (id)
) |
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

Note： MO execute of show create table lost table column not null constraint information

Expected Behavior

mysql> CREATE TABLE t (
-> id INT PRIMARY KEY,
-> a VARCHAR(30) NULL default 'foo',
-> b VARCHAR(30) NOT NULL default 'foo',
-> c INT NULL DEFAULT 1000,
-> d INT NOT NULL DEFAULT 2000
-> );
Query OK, 0 rows affected (0.00 sec)

mysql> show create table t;
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| t | CREATE TABLE t (
id int NOT NULL,
a varchar(30) DEFAULT 'foo',
b varchar(30) NOT NULL DEFAULT 'foo',
c int DEFAULT '1000',
d int NOT NULL DEFAULT '2000',
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

Steps to Reproduce

CREATE TABLE t (
	id INT PRIMARY KEY,
	a VARCHAR(30) NULL default 'foo',
	b VARCHAR(30) NOT NULL default 'foo',
	c INT NULL DEFAULT 1000,
	d INT NOT NULL DEFAULT 2000
);

show create table t;

Additional information

No response

[qingxinhome]

The issue has been resolved, please verify and test， @sukki37 @heni02 @aressu1985 @daviszhen

[Ariznawlll]

commit：18f806e26a516a2990d1b348728d7f838a5ba43b

verified