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

Unknown system variable 'STATEMENT'

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 3.1.19
    • 3.1.20, 3.2.2
    • General
    • None
    • Windows Server
      MariaDB 10.0.38 (64bit)
      ODBC driver 3.1.19 (32bit)

    Description

      Our .NET application uses MariaDB ODBC driver to get information from target MariaDB servers - it is monitoring software that can retrieve information from different versions of MariaDB.

      New version of ODBC driver 3.1.19 (32bit) is failing with following error when we try to execute simple DB command on older versions of MariaDB (e.g. 10.0.38 or 5.5.64).

      System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [ma-3.1.19][10.0.38-MariaDB]Unknown system variable 'STATEMENT'

      The driver is working against the latest MariaDB version (11.2.2).

      This is regression bug as it was working with ODBC driver 3.1.16.

      I believe the root cause is SET STATEMENT
      https://github.com/mariadb-corporation/mariadb-connector-odbc/blob/014e86b910e91dbce64ebb5ed7200316c3012949/ma_statement.c#L663

      This feature is available from MariaDB 10.1.2 (https://docs.w3cub.com/mariadb/set-statement/index).

      It is possible to extend following condition to check also version of target DB if SET STATEMENT command is available?
      https://github.com/mariadb-corporation/mariadb-connector-odbc/blob/014e86b910e91dbce64ebb5ed7200316c3012949/ma_statement.c#L790

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          lukas.belza Lukas Belza created issue -
          lukas.belza Lukas Belza made changes -
          Field Original Value New Value
          Description Our .NET application uses MariaDB ODBC driver to get information from target MariaDB servers - it is monitoring software that can retrieve information from different versions of MariaDB.

          New version of ODBC driver 3.1.19 (32bit) is failing with following error when we try to execute simple DB command on older versions of MariaDB (e.g. 10.0.38 or 5.5.64).
          {panel}
          System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [ma-3.1.19][10.0.38-MariaDB]Unknown system variable 'STATEMENT'
          {panel}

          The driver is working against the latest MariaDB version (11.2.2).

          This is regression bug as it was working with ODBC driver 3.1.16.



          		Our .NET application uses MariaDB ODBC driver to get information from target MariaDB servers - it is monitoring software that can retrieve information from different versions of MariaDB.

          New version of ODBC driver 3.1.19 (32bit) is failing with following error when we try to execute simple DB command on older versions of MariaDB (e.g. 10.0.38 or 5.5.64).
          {panel}
          System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [ma-3.1.19][10.0.38-MariaDB]Unknown system variable 'STATEMENT'
          {panel}

          The driver is working against the latest MariaDB version (11.2.2).

          This is regression bug as it was working with ODBC driver 3.1.16.

          I believe the root cause is SET STATEMENT
          https://github.com/mariadb-corporation/mariadb-connector-odbc/blob/014e86b910e91dbce64ebb5ed7200316c3012949/ma_statement.c#L663

          This feature is available from MariaDB 10.1.2 (https://docs.w3cub.com/mariadb/set-statement/index).


          lukas.belza Lukas Belza made changes -
          Description Our .NET application uses MariaDB ODBC driver to get information from target MariaDB servers - it is monitoring software that can retrieve information from different versions of MariaDB.

          New version of ODBC driver 3.1.19 (32bit) is failing with following error when we try to execute simple DB command on older versions of MariaDB (e.g. 10.0.38 or 5.5.64).
          {panel}
          System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [ma-3.1.19][10.0.38-MariaDB]Unknown system variable 'STATEMENT'
          {panel}

          The driver is working against the latest MariaDB version (11.2.2).

          This is regression bug as it was working with ODBC driver 3.1.16.

          I believe the root cause is SET STATEMENT
          https://github.com/mariadb-corporation/mariadb-connector-odbc/blob/014e86b910e91dbce64ebb5ed7200316c3012949/ma_statement.c#L663

          This feature is available from MariaDB 10.1.2 (https://docs.w3cub.com/mariadb/set-statement/index).


          		Our .NET application uses MariaDB ODBC driver to get information from target MariaDB servers - it is monitoring software that can retrieve information from different versions of MariaDB.

          New version of ODBC driver 3.1.19 (32bit) is failing with following error when we try to execute simple DB command on older versions of MariaDB (e.g. 10.0.38 or 5.5.64).
          {panel}
          System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [ma-3.1.19][10.0.38-MariaDB]Unknown system variable 'STATEMENT'
          {panel}

          The driver is working against the latest MariaDB version (11.2.2).

          This is regression bug as it was working with ODBC driver 3.1.16.

          I believe the root cause is SET STATEMENT
          https://github.com/mariadb-corporation/mariadb-connector-odbc/blob/014e86b910e91dbce64ebb5ed7200316c3012949/ma_statement.c#L663

          This feature is available from MariaDB 10.1.2 (https://docs.w3cub.com/mariadb/set-statement/index).

          It is possible to extend following condition to check also version of target DB if SET STATEMENT command is available?
          https://github.com/mariadb-corporation/mariadb-connector-odbc/blob/014e86b910e91dbce64ebb5ed7200316c3012949/ma_statement.c#L790
          Lawrin Lawrin Novitsky added a comment -

          The fix has been pushed.

          Technically, we do not support those old server versions that do not support SET STATEMENT. That means, that we do not test against those old server versions. Thus, even though I've fixed it now, there is no promise the code won't get lost at some point. Unlikely, though

          Lawrin Lawrin Novitsky added a comment - The fix has been pushed. Technically, we do not support those old server versions that do not support SET STATEMENT. That means, that we do not test against those old server versions. Thus, even though I've fixed it now, there is no promise the code won't get lost at some point. Unlikely, though
          Lawrin Lawrin Novitsky made changes -
          Fix Version/s 3.2.2 [ 29606 ]
          Fix Version/s 3.1.20 [ 29100 ]
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]

          People

            Lawrin Lawrin Novitsky
            lukas.belza Lukas Belza
            Votes:
            1 Vote for this issue
            Watchers:
            4 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.