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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
