[ODBC-391] With lower_case_table_names=2 server the driver may not read indexes in SQLStatistics Created: 2023-06-05  Updated: 2023-06-13  Resolved: 2023-06-13

Status: Closed
Project: MariaDB Connector/ODBC
Component/s: General
Affects Version/s: None
Fix Version/s: 3.1.19, 3.2.1

Type: Bug Priority: Major
Reporter: Lawrin Novitsky Assignee: Lawrin Novitsky
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
causes ODBC-370 No primary keys in Access linked tabl... Closed
is caused by MDEV-31472 Wrong results in queries to I_S for t... Confirmed

 Description   

If the server has lower_case_table_names=2, table name is not lower case, and application uses this not lower case name(or simply takes it form SQLTables results) in SQLStatistics parameter, that will cause driver not to return any indexes for it. In particular that affects Microsoft Access, and it won't see any index in such a table at such server. It's caused by what is seen atm as server bug, but can be workarounded/fixed in the driver anyway



 Comments   
Comment by Lawrin Novitsky [ 2023-06-05 ]

The pushed fix was incomplete

Generated at Thu Feb 08 03:28:21 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.