[Eclipsesql-bugs] [ eclipsesql-Bugs-3612193 ] MySQL 5.6 does not accept "SET OPTION..."

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

Bugs item #3612193, was opened at 2013-04-29 06:56
Message generated for change (Settings changed) made by hhilbert
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: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: BraileTrail (brailetrail)
Assigned to: Heiko Hilbert (hhilbert)
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

----------------------------------------------------------------------

Comment By: Heiko Hilbert (hhilbert)
Date: 2013-04-29 08:31

Message:
Thx for the response :-)

----------------------------------------------------------------------

Comment By: BraileTrail (brailetrail)
Date: 2013-04-29 08:03

Message:
DOH! I had edited the JDBC driver within SQLExplorer to point at the latest
jar file and it didn't make any difference, but I hadn't restart SQL
Explorer at the time.

I have just restarted  SQLExplorer and it's fine with the new driver.

Apologies.

----------------------------------------------------------------------

Comment By: Heiko Hilbert (hhilbert)
Date: 2013-04-29 07:10

Message:
This seems to be a JDBC-Driver issue. SQLExplorer calls:

stmt.setMaxRows(maxRows);

where stmt is a java.sql.Statement retrieved form the JDBC-Driver.
Check if you are using the latest Connector/J from MySql:

http://dev.mysql.com/downloads/connector/j/

As workaround you can switch off the checkbox 'Limit Rows' in SQL-Editor
toolbar and add a LIMIT clause to your sql statement.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3612193&group_id=132863