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

Compression causes queries to never respond / fail.

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.0.3
    • Fix Version/s: 3.0.4
    • Component/s: General
    • Labels:
    • Environment:
      MariaDB 10.2.13 on FreeBSD 11.1, ODBC Connector 3.0.3 on Windows 10 Client

      Description

      Using compression in a DSN for the MariaDB ODBC Driver, causes the application to wait idefinitly for the query execution.

      Example code to reproduce:

      System.Data.Odbc.OdbcConnection dbConnection = new System.Data.Odbc.OdbcConnection();
      System.Data.Odbc.OdbcCommand dbCommand;
      dbConnection.ConnectionString = "Driver={MariaDB ODBC 3.0 Driver};Server=mariadb-dev;Database=TESTDB;User=TEST;Password=TEST;Option=2048";
               
      dbConnection.Open();
      dbCommand = dbConnection.CreateCommand();
      dbCommand.CommandText = "SELECT DISTINCT SCHEMA_NAME AS CATALOG_NAME FROM INFORMATION_SCHEMA.SCHEMATA"; 
      int result = dbCommand.ExecuteNonQuery();
      

      Compression works on the 10.2.13 server using mysqlclient.
      If you remove "Option=2048" from the DSN the query returns a result.
      A "select 1" (with compression set) returns ERROR [08S01] [ma-3.0.3][10.2.13-MariaDB-log]Unknown command‘

      The above code works with MariaDB 10.1.31 / ODBC 3.0.3 / with compression set.
      Is there a compatibility issue with ODBC 3.0.3 and MariaDB 10.2 ?

      I can provide any further necessary information.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Lawrin Lawrin Novitsky
                Reporter:
                Patrick Dudziak Patrick Dudziak
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: