Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
1.0.9, 1.0.10
-
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
- relates to
-
MCOL-1372 Support lower_case_table_names=0 for cross engine joins
-
- Closed
-