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

Executable Comment Syntax which results in empty command gives 'You have an error in your SQL syntax'

    XMLWordPrintable

Details

    Description

      We use query with executable comments like this

      /*!80019 SELECT * FROM information_schema.applicable_roles ORDER BY host, user */

      It worked, when we were using mariadb-connector-odbc-3.1.16-win32.
      It returned for MariaDB empty result.

      After upgrade ODBC to version 3.1.19
      we get for the same query error like this

       Error Message:
      		 
         System.Data.Odbc.OdbcException : ERROR [42000] [ma-3.1.19][11.1.2-MariaDB-1:11.1.2+maria~ubu2204]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
      		 
        Stack Trace:
      		 
           at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
      		 
         at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
      		 
         at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
      		 
         at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
      		 
         at System.Data.Odbc.OdbcCommand.ExecuteReader()

      Attachments

        Activity

          People

            Lawrin Lawrin Novitsky
            tomas.vladik Tomas Vladik
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.