[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: |
|
||||||||
| 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; MariaDB [(none)]> use SURESH MariaDB [SURESH]> create table foo (a int) engine=columnstore; MariaDB [SURESH]> select * from foo;
----------------
---------------- 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 |