My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.