Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 1.2
-
Fix Version/s: 1.2.5
-
Component/s: None
-
Labels:
-
Sprint: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`;
|