[MDEV-14983] Wrong error message with SET sql_mode=sha2(ucs2_value) - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.0, 10.1, 10.2, 10.3
Fix Version/s: 10.3.37, 10.4.27, 10.5.18, 10.6.11, 10.7.7, 10.8.6, 10.9.4, 10.10.2
Component/s: OTHER
Labels:
None

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

People

Assignee:: Alexander Barkov

Reporter:: Alexander Barkov

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2018-01-18 10:16

Updated:: 2022-10-24 10:36

Resolved:: 2022-10-24 10:36

Git Integration

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