Re: 6.9.7.0 causes MySql syntax error in param query
Posted by: Mathieu van Loon
Date: October 08, 2015 08:21AM

Same here with 6.9.7 on Win 10 with MySQL 5.7.8-rc-log.

In my case i'm having issues with queries that follow the form


...
AND
something=1


if AND is followed by a newline and there are tabs (whitespace) before "something", then the query will fail with "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". If I replace the tab characters with spaces, the query succeeds.

For us this is a fatal issue with 6.9.7 and we will revert to an older version.

Options: ReplyQuote


Subject
Written By
Posted
Re: 6.9.7.0 causes MySql syntax error in param query
October 08, 2015 08:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.