tracker issue : CF-3506758

select a category, or use search below
(searches all categories and all time range)
Title:

MySQL 5.6 Unable to Execute Queries

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Peter Freitag / Peter Freitag (Peter Freitag)

Created: 02/26/2013

Components: Database

Versions: 10.0

Failure Type: Non Functioning

Found In Build/Fixed In Build: Final / 285015

Priority/Frequency: Critical / All users will encounter

Locale/System: English / Platforms All

Vote Count: 4

Problem Description:

The MySQL JDBC Driver that ships with ColdFusion makes calls with SET OPTION, which has been deprecated in favor of SET (without OPTION) for some time. MySQL 5.6 removes support for SET OPTION causing most queries to break when run against it. 

See this thread on StackOverflow for more info: http://stackoverflow.com/questions/15038312/cf10-mysql-sql-select-limit-default

Steps to Reproduce:

Install MySQL 5.6 add a datasource and try to run a query against it that does not contain a LIMIT operator.

Actual Result:

Error Executing Database Query.
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=DEFAULT

Expected Result:

The query runs

Any Workarounds:

You may be able to use the MySQL JDBC driver instead, but I haven't tested this.

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3506758

Keywords:
FixTested


External Customer Info:
External Company:  
External Customer Name: pete_freitag
External Customer Email:

Attachments:

Comments:

I recently experienced the same issue when upgrading from mysql 5.1 to 5.6. My application probably uses cfquery's maxrows attributes hundreds of times. This bug is currently rendering the application useless.
Vote by External U.
16159 | February 26, 2013 06:26:02 PM GMT
Tried CF 10 with mysql 5.6 and had the same issue. I updated to a newer MySQL JDBC connector and the issue went away.
Vote by External U.
16160 | March 28, 2013 10:53:03 AM GMT
I am experiencing the same issue - it's JDBC driver problem - CF needs to be updated to 5.1.22 to resolve it.
Vote by External U.
16161 | April 17, 2013 03:12:36 PM GMT
Running into the same problem. Can't get my SQL to run. Site is being hosted by an Adobe partner. Informed them of the issue but still waiting to hear back. LOVE CF10!
Vote by External U.
16162 | July 02, 2013 11:02:55 AM GMT