Title:
Unknown table variables in information_schema ColdFusion10 + MySQL 5.5 Enterprise
| View in TrackerStatus/Resolution/Reason: Closed/Deferred/ThirdParty
Reporter/Name(from Bugbase): / ext-user (Nimit Sharma)
Created: 07/26/2012
Versions: 10.0
Failure Type: Non Functioning
Found In Build/Fixed In Build: 282462 /
Priority/Frequency: Normal / All users will encounter
Locale/System: English / Mac 10 All,Win 2008 Server R2 64 bit
Vote Count: 1
Problem: Unknown table variables in information_schema ColdFusion10 + MySQL 5.5 Enterprise
Environment:
Product : ColdFusion 10 Standard
Database: MySQL 5.5 Enterprise
Method:
1. Create a datasource with MySQL 5.5 Enterprise using MySQL(DataDirect) driver.
2. Create a test.cfm page using below mentioned code :
<cfquery name="getmysqlvars" datasource="fixq">
SHOW VARIABLES;
</cfquery>
<cfdump var="#getmysqlvars#">
Result: Error Executing Database Query - Unknown table variables in information_schema
Expected:It should display all the variables listed.
Workaround:
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3296986
External Customer Info:
External Company:
External Customer Name:
External Customer Email:Attachments:
Comments: