[MDEV-14983] Wrong error message with SET sql_mode=sha2(ucs2_value) Created: 2018-01-18  Updated: 2022-10-24  Resolved: 2022-10-24

Status: Closed
Project: MariaDB Server
Component/s: OTHER
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

Type: Bug Priority: Major
Reporter: Alexander Barkov Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
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'



 Comments   
Comment by Alexander Barkov [ 2022-10-24 ]

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.

Generated at Thu Feb 08 08:17:48 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.