From: SourceForge.net <no...@so...> - 2013-04-29 13:56:01
|
Bugs item #3612193, was opened at 2013-04-29 06:56 Message generated for change (Tracker Item Submitted) made by brailetrail You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3612193&group_id=132863 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: BraileTrail (brailetrail) Assigned to: Nobody/Anonymous (nobody) Summary: MySQL 5.6 does not accept "SET OPTION..." Initial Comment: MySQL 5.6 no longer accepts the syntax "SET OPTION SQL_SELECT_LIMIT=", it should now be "SET SQL_SELECT_LIMIT=". To reproduce the problem point SQLExplorer at a MySQL 5.6 instance and execute any command in an SQL Editor window, for example "use mysql" and you get the error: "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 'OPTION SQL_SELECT_LIMIT=100' at line 1" This seems to be issued by SQLExplorer before trying to execute my query and I don't believe that I have any control the SQL generated by SQLExplorer. It also seems that mysqldump sufferes from this problem: http://bugs.mysql.com/bug.php?id=67507 ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3612193&group_id=132863 |