Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
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
Attachments
Issue Links
- causes
-
ODBC-370 No primary keys in Access linked tables - even if autonumber
- Closed
- is caused by
-
MDEV-31472 Wrong results in queries to I_S for table/schema having capitals in the name
- Confirmed