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

Odd behavior of character_set variables set to utf16 (when allowed)

Details

    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
      

      Attachments

        Activity

          elenst Elena Stepanova created issue -
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          Labels upstream
          elenst Elena Stepanova made changes -
          Priority Major [ 3 ] Minor [ 4 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 111096 ] MariaDB v4 [ 142080 ]
          ralf.gebhardt Ralf Gebhardt made changes -
          Fix Version/s 10.2 [ 14601 ]
          julien.fritsch Julien Fritsch made changes -
          Fix Version/s 10.3 [ 22126 ]
          julien.fritsch Julien Fritsch made changes -
          Fix Version/s 10.4 [ 22408 ]
          bar Alexander Barkov made changes -
          Fix Version/s 10.5.28 [ 29952 ]
          Fix Version/s 10.6.21 [ 29953 ]
          Fix Version/s 10.11.11 [ 29954 ]
          Fix Version/s 11.2.7 [ 29955 ]
          Fix Version/s 11.4.5 [ 29956 ]
          Fix Version/s 11.6.2 [ 29908 ]
          Fix Version/s 11.7.1 [ 29913 ]
          Fix Version/s 11.5.2 [ 29838 ]
          Fix Version/s 10.5 [ 23123 ]
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 11.2.7 [ 29955 ]

          People

            bar Alexander Barkov
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.