Uploaded image for project: 'MariaDB Connector/ODBC'
  1. MariaDB Connector/ODBC
  2. ODBC-391

With lower_case_table_names=2 server the driver may not read indexes in SQLStatistics

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 3.1.19, 3.2.1
    • General
    • 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

          Activity

            People

              Lawrin Lawrin Novitsky
              Lawrin Lawrin Novitsky
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.