Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-830

CrossEngineSupport can not retrieve multi byte fields normally

    XMLWordPrintable

    Details

    • Sprint:
      2017-15

      Description

      When the CrossEngineSupport is enabled, we can run the SQL on two tables with different engine type(ColumnStore, MyISAM) but the results is not normal.

      CREATE TABLE `test_cs` (
      `c1` int(11) DEFAULT NULL,
      `c2` varchar(64) DEFAULT NULL
      ) ENGINE=Columnstore DEFAULT CHARSET=utf8;

      CREATE TABLE `test_myisam` (
      `c1` int(11) DEFAULT NULL,
      `c2` varchar(64) DEFAULT NULL
      ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

      insert into test.test_cs values(1, 'cs测试');
      insert into test.test_myisam values(2, 'myisam测试');

      select * from test.test_cs union select * from test.test_myisam;

      --------------+

      c1 c2

      --------------+

      2 myisam??
      1 cs测试

      --------------+
      2 rows in set (0.14 sec)

      It seems that the data of MyISAM table is not normal.

        Attachments

          Activity

            People

            Assignee:
            dleeyh Daniel Lee
            Reporter:
            kaifengchen kaifengchen
            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.