[MDEV-11685] sql_mode can't be set with non-ascii connection charset Created: 2016-12-29  Updated: 2017-02-10  Resolved: 2017-01-11

Status: Closed
Project: MariaDB Server
Component/s: Character Sets
Affects Version/s: 5.5, 10.0, 10.1, 10.2.3, 10.2
Fix Version/s: 5.5.55, 10.0.29, 10.1.21, 10.2.4

Type: Bug Priority: Major
Reporter: Nirbhay Choubey (Inactive) Assignee: Nirbhay Choubey (Inactive)
Resolution: Fixed Votes: 0
Labels: upstream

Issue Links:
Relates
relates to MDEV-7635 update defaults and simplify mysqld c... Closed

 Description    

MariaDB [test]> set sql_mode = 'NO_ENGINE_SUBSTITUTION';
 
Query OK, 0 rows affected (0.00 sec)
 
 
 
MariaDB [test]> set character_set_connection=utf32;
 
Query OK, 0 rows affected (0.00 sec)
 
 
 
MariaDB [test]> set sql_mode = 'NO_ENGINE_SUBSTITUTION';
 
ERROR 1231 (42000): Variable 'sql_mode' can't be set to the value of 'NO_ENGINE_SUBSTITUTION'



 Comments   
Comment by Elena Stepanova [ 2017-01-03 ]

Same for utf16, utf16le, ucs2.
I expect it has something to do with the fact that they can't be used as a client character set, but I'll leave it to the character set expert bar to provide a proper explanation (or to confirm it's a bug, if it is).

Comment by Nirbhay Choubey (Inactive) [ 2017-01-09 ]

bar Based on our discussion, I have committed a fix for this issue.
http://lists.askmonty.org/pipermail/commits/2017-January/010405.html
Can you review it please?

Comment by Alexander Barkov [ 2017-01-11 ]

http://lists.askmonty.org/pipermail/commits/2017-January/010414.html is OK to push.
One small thing: Please move the ucs2 test from ctype_ucs2_def.test to ctype_ucs.test.

Generated at Thu Feb 08 07:51:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.