starrocks icon indicating copy to clipboard operation
starrocks copied to clipboard

字段 default 值输入汉字,show create table 显示的是 Unicode编码,

Open liyanwei89 opened this issue 1 year ago • 0 comments

Steps to reproduce the behavior (Required)

建表语句: CREATE TABLE test111111 ( test3 varchar(111) NULL default '撒' COMMENT '撒', test1 Char(10) NULL default '撒' COMMENT '撒', test2 varchar NULL default '撒' COMMENT '撒', test4 Char NULL default '撒' COMMENT '撒', test5 tinyint(4) NULL COMMENT 'test1', test6 varchar(1) NULL COMMENT 'test2' ) ENGINE=OLAP DUPLICATE KEY(test3) DISTRIBUTED BY HASH(test3);

查询 show create table test111111;

Expected behavior (Required)

希望显示的建表语句中 default 中文值可以正常显示

Real behavior (Required)

mysql> show create table test111111; +------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | test111111 | CREATE TABLE test111111 ( test3 varchar(111) NULL DEFAULT "\u6492" COMMENT "撒", test1 char(10) NULL DEFAULT "\u6492" COMMENT "撒", test2 varchar(1) NULL DEFAULT "\u6492" COMMENT "撒", test4 char(1) NULL DEFAULT "\u6492" COMMENT "撒", test5 tinyint(4) NULL COMMENT "test1", test6 varchar(1) NULL COMMENT "test2" ) ENGINE=OLAP DUPLICATE KEY(test3) DISTRIBUTED BY HASH(test3) PROPERTIES ( "replication_num" = "3", "in_memory" = "false", "enable_persistent_index" = "false", "replicated_storage" = "true", "compression" = "LZ4" ); | +------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.01 sec)

StarRocks version (Required)

  • You can get the StarRocks version by executing SQL select current_version() select current_version() -> ; +-------------------+ | current_version() | +-------------------+ | 3.2.10-f61f51a | +-------------------+

liyanwei89 avatar Oct 16 '24 11:10 liyanwei89