Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
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
You can easy start any version of MySQL using docker:
docker run -d -p 3306:3306 -e MYSQL_ROOT_PASSWORD=Supercalifragilisticexpialidocious mysql:5.7
|
Your suggested other variant of SQL syntax is passing without issue on 5.7
The fix has been pushed, but connector is not tested against this eol'ed mysql version
No, looks like the bug in the our driver. This query is used during session initialization, but looks like 5.7 does not support this syntax.
Can you try o run the query as I don't have 5.7 by hand because of the EOL
SELECT 1 WHERE @@sql_mode LIKE '%ansi_quotes%'
well, the error you get suggests it is no good syntax for 5.7. Maybe then try
SELECT 1 FROM DUAL WHERE @@sql_mode LIKE '%ansi_quotes%'