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

Wrong error message with SET sql_mode=sha2(ucs2_value)

Details

    Description

      SET sql_mode=sha2(CONVERT('a' USING ucs2),0);


      ERROR 1231 (42000): Variable 'sql_mode' can't be set to the value of '〲㉡㘹㜹收摡户慡㕡攴挳攵攴㕦㝥㤷㜱ㄲ愷收㌵㤳㠲つ扥挱散㜳㡡㈴昹㍣'

      The error message looks wrong. The expected message would be:

      ERROR 1231 (42000): Variable 'sql_mode' can't be set to the value of '022a6979e6dab7aa5ae4c3e5e45f7e977112a7e63593820dbec1ec738a24f93c'

      Attachments

        Activity

          bar Alexander Barkov added a comment -

          The problem is not repeatable any more starting from 10.3 (I didn't check earlier versions).
          It seems to be fixed by some of earlier commits. Adding an MTR test only.

          bar Alexander Barkov added a comment - The problem is not repeatable any more starting from 10.3 (I didn't check earlier versions). It seems to be fixed by some of earlier commits. Adding an MTR test only.

          People

            bar Alexander Barkov
            bar Alexander Barkov
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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