[MCOL-2225] cross engine join with space in column names in on condition cause fatal error Created: 2019-03-08  Updated: 2020-08-25  Resolved: 2019-07-05

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.2
Fix Version/s: 1.2.5

Type: Bug Priority: Major
Reporter: Richard Stracke Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: join

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`;



 Comments   
Comment by Andrew Hutchings (Inactive) [ 2019-06-26 ]

Commit in engine and regression suite.

For QA: Test in description and in regression suite (working_tpch1_compareLogOnly/misc).

Comment by Daniel Lee (Inactive) [ 2019-07-05 ]

Build verified: 1.2.5-1 nightly

erver commit:
f44f7d9
engine commit:
4e477ab

Reproduced issue in 1.2.1-h

Generated at Thu Feb 08 02:34:40 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.