[GitHub] [incubator-doris] nextdreamblue commented on pull request #9694: [Bug] Fix create table like when having hidden columns

[GitBox <gi...@apache.org>]

nextdreamblue commented on PR #9694:
URL: https://github.com/apache/incubator-doris/pull/9694#issuecomment-1134247889

   @yiguolei 
   
   i reproduce this bug like this :
   
   
   MySQL [abc]> ADMIN SET FRONTEND CONFIG ("enable_batch_delete_by_default" = "true");
   Query OK, 0 rows affected (0.01 sec)
   
   MySQL [abc]>
   MySQL [abc]> SET show_hidden_columns=true;
   Query OK, 0 rows affected (0.00 sec)
   
   MySQL [abc]> use aaa
   Database changed
   MySQL [aaa]> CREATE TABLE expamle_1 ( user_id largeint(40) NOT NULL COMMENT "用户id", username varchar(50) NOT NULL COMMENT "用户昵称" ) ENGINE=OLAP UNIQUE KEY(user_id, username) COMMENT "OLAP" DISTRIBUTED BY HASH(user_id) BUCKETS 1 PROPERTIES ( "replication_allocation" = "tag.location.default: 1", "in_memory" = "false", "storage_format" = "V2" );
   Query OK, 0 rows affected (4.47 sec)
   
   MySQL [aaa]> show create table expamle_1;
   +-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
   | Table | Create Table |
   +-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
   | expamle_1 | CREATE TABLE expamle_1 (
   user_id largeint(40) NOT NULL COMMENT "用户id",
   username varchar(50) NOT NULL COMMENT "用户昵称",
   __DORIS_DELETE_SIGN__ tinyint(4) NOT NULL DEFAULT "0" COMMENT "doris delete flag hidden column"
   ) ENGINE=OLAP
   UNIQUE KEY(user_id, username)
   COMMENT "OLAP"
   DISTRIBUTED BY HASH(user_id) BUCKETS 1
   PROPERTIES (
   "replication_allocation" = "tag.location.default: 1",
   "in_memory" = "false",
   "storage_format" = "V2"
   ) |
   +-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
   1 row in set (13.05 sec)
   
   MySQL [aaa]> create table expamle_2 like expamle_1;
   ERROR 1105 (HY000): errCode = 2, detailMessage = Failed to execute CREATE TABLE LIKE expamle_1. Reason: errCode = 2, detailMessage = Duplicate column name 'DORIS_DELETE_SIGN'
   
   
   
   i think hidden columns do not duplicate when create tabe like othertable。


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org