Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Duplicate
-
1.5.3
-
None
Description
It is reported by a customer, that cross engine join query having an upper cased INNODB table, throwing ERROR.
Here are the repro steps:
MariaDB [inno]> CREATE TABLE INNO (a int, b varchar(10));
Query OK, 0 rows affected (0.004 sec)
MariaDB [inno]> create table cs (a int, b varchar(10)) engine=columnstore;
Query OK, 0 rows affected (1.120 sec)
MariaDB [inno]> select * from cs a, INNO b where a.a=b.a;
ERROR 1815 (HY000): Internal error: fatal error runing mysql_real_query() in libmysql_client lib (1146) (Table 'inno.inno' doesn't exist)
MariaDB [inno]> select @@lower_case_table_names;
--------------------------
@@lower_case_table_names |
--------------------------
0 |
--------------------------
1 row in set (0.000 sec)
MariaDB [inno]> select @@version;
----------------
@@version |
----------------
10.5.5-MariaDB |
----------------
1 row in set (0.001 sec)
Attachments
Issue Links
- is duplicated by
-
MCOL-4144 Error when using upper case database names
- Closed