Details
-
Bug
-
Status: Needs Feedback (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.4.0
-
None
-
None
Description
There is a byte length limit for field aliases, and if it exceeds 256, it will be truncated. For Chinese aliases, unpredictable errors may occur.
How to trigger
Create database if not exists test_0227;
use test_0227;
Create Table t1(id int key,id1 int);
insert into t1 values(1,1);
select id as '中华人民共和国万岁一中华人民共和国万岁一中华人民共和国万岁一中华人民共和国万岁一中华人民共和国万岁一中华人民共和国万岁一中华人民共和国万岁一中华人民共和国万岁一中华人民共和国万岁一中华人民共和国万岁一' from t1;
From the results, it can be seen that the Chinese alias has been truncated;
Could you please elaborate, what unpredictable are you getting that is specific to the Chinese alias? As you said, the aliases are (in general) truncated to 256 bytes, so it's predictable that this one gets truncated. Is it truncated wrongly?