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

sql_mode can't be set with non-ascii connection charset

Details

    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'

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-7635 update defaults and simplify mysqld config parameters

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          links to

          Web Link Github commit

          Activity

            Ascending order - Click to sort in descending order
            elenst Elena Stepanova added a comment -

            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).

            elenst Elena Stepanova added a comment - 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).
            nirbhay_c Nirbhay Choubey (Inactive) added a comment -

            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?

            nirbhay_c Nirbhay Choubey (Inactive) added a comment - 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?
            bar Alexander Barkov added a comment -

            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.

            bar Alexander Barkov added a comment - 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.

            People

              nirbhay_c Nirbhay Choubey (Inactive)
              nirbhay_c Nirbhay Choubey (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.