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

CrossEngineSupport can not retrieve multi byte fields normally

    XMLWordPrintable

Details

    • 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

            dleeyh Daniel Lee (Inactive)
            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.