about “show create table” bug

[pipahuadi]

Steps to reproduce the behavior (Required)

1. create table test_db.test
   ( id int(9),
   create_time datetime NOT NULL DEFAULT current_timestamp )
   ENGINE=OLAP
   PRIMARY KEY (id)
   DISTRIBUTED BY HASH(id) BUCKETS 5

2. show create table test_db.test

3. result ： CREATE TABLE test ( id int(11) NOT NULL COMMENT "", create_time datetime NOT NULL COMMENT "" ) ENGINE=OLAP PRIMARY KEY(id) COMMENT "OLAP" DISTRIBUTED BY HASH(id) BUCKETS 5 PROPERTIES ( "replication_num" = "3", "in_memory" = "false", "storage_format" = "DEFAULT" );

4.create table test_db.test
( id int(9),
create_time datetime NOT NULL DEFAULT current_timestamp )
ENGINE=OLAP
DISTRIBUTED BY HASH(id) BUCKETS 5

5.show create table test_db.test

6.result ：CREATE TABLE test ( id int(11) NULL COMMENT "", create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT "" ) ENGINE=OLAP DUPLICATE KEY(id, create_time) COMMENT "OLAP" DISTRIBUTED BY HASH(id) BUCKETS 10 PROPERTIES ( "replication_num" = "3", "in_memory" = "false", "storage_format" = "DEFAULT" );

Expected behavior (Required)

This happens only when PRIMARY KEY is used, and it does not happen when using UNIQUE KEY, DUPLICATE KEY or not using PRIMARY KEY，it should be fixed

Real behavior (Required)

StarRocks version (Required)

starrocks-2.4.3、
starrocks-2.2.2

[Astralidea]

This problem will only be fixed to version 2.5 and later, the previous version will not be maintained because it is not LTS