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

Running queries - Maria ODBC 3.2.3 and MySql 5.7

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 3.2.4
    • General
    • None

    Description

      After upgdade of Maria ODBC to version 3.2.3 we are getting following error messages for multiple queries using Mysql 5.7.

      Previous ODBC version 3.1.2, was working without problem.

      SELECT *
      FROM information_schema.collations
      INNER JOIN information_schema.character_sets USING (character_set_name)
      ORDER BY collation_name , character_set_name, ErrorMessage: ERROR [42000] [ma-3.2.3]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE @@sql_mode LIKE '%ansi_quotes%'' at line 1
      

      Could be related to EOL of MySql 5.7 - October 21, 2023?

      Attachments

        Activity

          People

            Lawrin Lawrin Novitsky
            Lukas Osadsky Lukas Osadsky
            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.