[MDEV-23138] Odd behavior of character_set variables set to utf16 (when allowed) Created: 2020-07-10  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Character Sets
Affects Version/s: 10.1, 10.2, 10.3, 10.4, 10.5
Fix Version/s: 10.4, 10.5

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Alexander Barkov
Resolution: Unresolved Votes: 0
Labels: upstream


 Description   

character_set_client isn't allowed to be set to utf16; but some other character_set_xxx variables are, and it can cause strange effects:

10.5 24ed08c3

MariaDB [test]> select @@character_set_connection;
+----------------------------+
| @@character_set_connection |
+----------------------------+
| utf8                       |
+----------------------------+
1 row in set (0.003 sec)
 
MariaDB [test]> set tx_isolation= 'READ-COMMITTED';
Query OK, 0 rows affected (0.000 sec)
 
MariaDB [test]> set character_set_connection=utf16;
Query OK, 0 rows affected (0.000 sec)
 
MariaDB [test]> set tx_isolation= 'READ-COMMITTED';
ERROR 1231 (42000): Variable 'tx_isolation' can't be set to the value of 'READ-COMMITTED'

or

MariaDB [test]> select @@character_set_filesystem, @@character_set_connection;
+----------------------------+----------------------------+
| @@character_set_filesystem | @@character_set_connection |
+----------------------------+----------------------------+
| binary                     | utf8                       |
+----------------------------+----------------------------+
1 row in set (0.000 sec)
 
MariaDB [test]> load data infile 'x' into table t1;
Query OK, 0 rows affected (0.000 sec)                
Records: 0  Deleted: 0  Skipped: 0  Warnings: 0
 
MariaDB [test]> set character_set_filesystem= utf16;
Query OK, 0 rows affected (0.000 sec)
 
MariaDB [test]> load data infile 'x' into table t1;
ERROR 1085 (HY000): The file '/data/bld/10.5-debug-nightly/data/test/' must be in the database directory or be readable by all
 
MariaDB [test]> set character_set_filesystem= utf8;
Query OK, 0 rows affected (0.000 sec)
 
MariaDB [test]> load data infile 'x' into table t1;
Query OK, 0 rows affected (0.000 sec)                
Records: 0  Deleted: 0  Skipped: 0  Warnings: 0


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