[MCOL-4287] Database name is upper cased, SIMPLE select for that DB tables ERRORs. Created: 2020-09-01  Updated: 2021-04-26  Resolved: 2020-09-01

Status: Closed
Project: MariaDB ColumnStore
Component/s: MDB Plugin
Affects Version/s: 1.5.3
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: suresh ramagiri Assignee: Unassigned
Resolution: Duplicate Votes: 1
Labels: None

Issue Links:
Duplicate
duplicates MCOL-4144 Error when using upper case database ... Closed

 Description   

One of the customers reported that, on the MariaDB columnstore 10.5.5. The simple SELECT query error as "ERROR 1815 (HY000): Internal error: IDB-1000: '<tablename>' and '<tablename>' are not joined."

It is observed that if a database name is upper cased, and a table created in that database simple SELECT throws above noted error.

Repro step:

MariaDB [(none)]> create database SURESH;
Query OK, 1 row affected (0.002 sec)

MariaDB [(none)]> use SURESH
Database changed

MariaDB [SURESH]> create table foo (a int) engine=columnstore;
Query OK, 0 rows affected (0.325 sec)

MariaDB [SURESH]> select * from foo;
ERROR 1815 (HY000): Internal error: IDB-1000: 'foo' and 'foo' are not joined.
MariaDB [SURESH]> select @@version;
----------------

@@version

----------------

10.5.5-MariaDB

----------------
1 row in set (0.000 sec)

Thank You.



 Comments   
Comment by David Hall (Inactive) [ 2020-09-01 ]

Until fixed, use lower_case_table_names = 0 in your columnstore.cnf file or set lower_case_table_names = 0

Comment by David Hall (Inactive) [ 2020-09-01 ]

Duplicates MCOL-4144

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