MYSQL ODBC Connector 8.0 GROUP_CONCAT Error
(Doc ID 2639547.1)
Last updated on FEBRUARY 16, 2020
Applies to:
MySQL Connectors - Version 8.0 and laterInformation in this document applies to any platform.
Symptoms
On : 8.0 version, Connector/ODBC
ACTUAL BEHAVIOR
---------------
When the Prepared SQL statement has a GROUP_CONCAT function, some of the fields return 0 as value.
EXPECTED BEHAVIOR
-----------------------
Any prepared statement should return the correct values no matter what functions are used.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Install the Connector/ODBC 8.0 version
2. Create a prepared statement that includes a BLOB/TEXT style field, plus a fixed length field (e.g. INT)
3. Run the query and check the results for the fixed length.
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot trust the values being returned.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |