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

Spider table with charset utf32/utf16/ucs2 tries to set client charset to unsupported value

    XMLWordPrintable

Details

    Description

      --source plugin/spider/spider/include/init_spider.inc
       
      SET spider_same_server_link= on;
      eval create server s foreign data wrapper mysql options (host "127.0.0.1", database "test", user "root", port $MASTER_MYPORT);
       
      CREATE TABLE t (a INT);
      CREATE TABLE t_spider (a INT) ENGINE=SPIDER COMMENT = "wrapper 'mysql', srv 's', table 't'" CHARSET utf32;
      SELECT * FROM t_spider;
       
      # Cleanup
       
      DROP TABLE t_spider, t;
      DROP SERVER s;
       
      --source plugin/spider/spider/include/deinit_spider.inc
      

      10.4 3e3cfa89

      mysqltest: At line 8: query 'SELECT * FROM t_spider' failed: 1231: Variable 'character_set_client' can't be set to the value of 'utf32'
      

      At this point Spider tries to run SET NAMES utf32 (hopelessly of course).

      Note that the test case sets an explicit character set for the Spider table for simplicity; in reality, it would rather be either a database charset, or a system-wide character-set-server. The result is the same anyway.

      Attachments

        Activity

          People

            ycp Yuchen Pei
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.