Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-36186

Fields with Chinese aliases may encounter unpredictable errors

Details

    • Bug
    • Status: Needs Feedback (View Workflow)
    • Major
    • Resolution: Unresolved
    • 11.4.0
    • None
    • Server
    • 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;

      Attachments

        Activity

          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?

          elenst Elena Stepanova added a comment - 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?

          People

            Unassigned Unassigned
            Mike_and_pig LvXiangjie
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.