[MCOL-1998] Cross engine JOINs table name error Created: 2018-12-06  Updated: 2021-01-16  Resolved: 2021-01-16

Status: Closed
Project: MariaDB ColumnStore
Component/s: MariaDB Server
Affects Version/s: 1.2.1
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Matthias Dr. Döring Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: beginner-friendly
Environment:

Windows



 Description   

Hello,

the following cross engine select throws an error:

SELECT * FROM columnstoretable as cs JOIN `l-cells` as idb ON cs.key_id = idb.key_id

l-cells is an innoDB table. If the hyphen is removed the error vanishes.

I get the error:

"fatal error reading result from crossengine client lib (1064). The same SELECT für two innoDB tables works without problems. Are there any documented restrictions for the naming of tables in cross engine joins?

Best regards
Matthias



 Comments   
Comment by Roman [ 2019-03-15 ]

Greetings,
At this moment the table names should contain only alpha-numerical chars to work for sure.

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