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

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

          causes

          Bug - A problem which impairs or prevents the functions of the product. ODBC-370 No primary keys in Access linked tables - even if autonumber

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31472 Wrong results in queries to I_S for table/schema having capitals in the name

          • Major - Major loss of function.
          • Confirmed

          Activity

            Ascending order - Click to sort in descending order
            Lawrin Lawrin Novitsky created issue -
            Lawrin Lawrin Novitsky made changes -
            Field Original Value New Value
            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. It's caused by what is seen atm as server bug, but can be workarounded in the driver any way 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
            Lawrin Lawrin Novitsky made changes -
            Component/s General [ 14302 ]
            Fix Version/s 3.1.19 [ 28903 ]
            Fix Version/s 3.2.1 [ 28908 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            Lawrin Lawrin Novitsky made changes -
            Lawrin Lawrin Novitsky added a comment -

            The pushed fix was incomplete

            Lawrin Lawrin Novitsky added a comment - The pushed fix was incomplete
            Lawrin Lawrin Novitsky made changes -
            Resolution Fixed [ 1 ]
            Status Closed [ 6 ] Stalled [ 10000 ]
            Lawrin Lawrin Novitsky made changes -
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            Lawrin Lawrin Novitsky made changes -

            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.