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

ColumnStore Tables can't join with InnoDB tables that contain uppercase characters

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • 1.0.9, 1.0.10
    • Icebox
    • ExeMgr, MDB Plugin
    • None
    • Centos 7

    Description

      It's possible I've got something misconfigured, but I've looked and haven't found anything that seems to fit. It's also possible I'm trying to do something that isn't supported, if so I apologize.

      When trying to join a ColumSstore table with an InnoDB table that contains an uppercase character the join fails - it looks like it's because it lowercases the table name when trying to do the join. With a setting of

      lower_case_table_names = 0
      lower_case_file_system = OFF

      and these queries

      CREATE TABLE IF NOT EXISTS data.example_columnstore_table (
      `Blah` VARCHAR(255) NOT NULL
      ) ENGINE=columnstore;

      CREATE TABLE IF NOT EXISTS data.ExampleInnoDBTable (
      `Blah` VARCHAR(255) NOT NULL
      ) ENGINE=INNODB;

      INSERT INTO data.ExampleInnoDBTable (`Blah`) VALUES ("1");
      INSERT INTO data.example_columnstore_table (`Blah`) VALUES ("1");
      SELECT * FROM data.example_columnstore_table JOIN data.ExampleInnoDBTable USING (`Blah`);

      it gives an error of "Internal error: fatal error executing query in crossengine client lib(17)(17)"

      and in the debug log

      Aug 17 10:30:10 db ExeMgr[6710]: 10.193649 |304741|0|0| D 16 CAL0041: Start SQL statement: SELECT * FROM data.example_columnstore_table JOIN data.ExampleInnoDBTable USING (`Blah`); ||
      Aug 17 10:30:10 db joblist[6710]: 10.208007 |0|0|0| I 05 CAL0000: QUERY to foreign engine: SELECT Blah FROM exampleinnodbtable
      Aug 17 10:30:10 db joblist[6710]: 10.208566 |304741|0|0| C 05 CAL0000: fatal error executing query in crossengine client lib(17)(17)

      Joining a lower case InnoDB table and an uppercase InnoDB table does work in this environment

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              mattminix Matthew Minix
              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.