Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.2
-
None
-
2019-06
Description
To reproduce:
DROP TABLE IF EXISTS `tMcol` ;
|
DROP TABLE IF EXISTS `tInno` ;
|
|
|
|
CREATE TABLE IF NOT EXISTS `tMcol`
|
(
|
`c1` tinyint NOT NULL ,
|
`c 2` char(32) NOT NULL |
)
|
ENGINE=ColumnStore
|
DEFAULT CHARSET=UTF8
|
;
|
|
|
CREATE TABLE IF NOT EXISTS `tInno`
|
(
|
`c1` tinyint NOT NULL ,
|
`c 2` char(32) NOT NULL |
)
|
ENGINE=InnoDB
|
DEFAULT CHARSET=UTF8
|
;
|
|
select * from `tMcol` m inner join `tInno` i ON `m`.`c 2` = `i`.`c 2`; |
caused the following error message
ERROR 1815 (HY000): Internal error: fatal error runing mysql_real_query() in libmysql_client lib (1064) (You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax |
Same case with 2 columnstore table works fine.
Same case without space in the column names works also fine.
DROP TABLE IF EXISTS `tMcol` ;
|
DROP TABLE IF EXISTS `tInno` ;
|
|
CREATE TABLE IF NOT EXISTS `tMcol`
|
(
|
`c1` tinyint NOT NULL ,
|
`c2` char(32) NOT NULL |
)
|
ENGINE=ColumnStore
|
DEFAULT CHARSET=UTF8
|
;
|
|
|
|
|
|
|
CREATE TABLE IF NOT EXISTS `tInno`
|
(
|
`c1` tinyint NOT NULL ,
|
`c2` char(32) NOT NULL |
)
|
ENGINE=InnoDB
|
DEFAULT CHARSET=UTF8
|
;
|
|
select * from `tMcol` m inner join `tInno` i ON `m`.`c2` = `i`.`c2`;
|