Bug #90732 group_concat not working with myODBC
Submitted: 3 May 2018 9:31 Modified: 1 Jul 2018 8:10
Reporter: Jernej Pecjak Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Connection Handling Severity:S1 (Critical)
Version:8.0.11 OS:Microsoft Windows (server 2016)
Assigned to: Assigned Account CPU Architecture:x86

[3 May 2018 9:31] Jernej Pecjak
Description:
When using myODBC with classic ASP and using group_concat with ADO without setting cursor to client (CursorLocation=3), there is error:

***

Provider error '80040e21'

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

***

MySql 5.7 did not have this bug.

How to repeat:
Make classic ASp page like:

Dim conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open  "Provider=MSDASQL;Driver={MySQL ODBC 5.3 Unicode Driver};server=localhost;uid=xxx;pwd=xxx;database=xxx;OPTION=16384;"

SQLStmt = "SELECT group_concat(name) as name FROM names"
set rsX = Conn.Execute(SQLStmt)

name=rsX("name")

Make database table names with column name (char) and make few entries.

The error is in the last line.

The problem is the cursor if it is set to server (default), if I set it using ADODB.Command to client (instead of using ADO), it works.

But it should work with server side cursor also.

I am using myODBC 5.3.10 32 bit, as this is the latest 32-bit version. 

Suggested fix:
Please fix the group_concat in mysql8 so it works with myODBC properly.
[3 May 2018 12:31] Jernej Pecjak
I have just reverted to mySQL 5.7.22 64-bit, I have changed nothing else in my page, connection or myODBC and now the group_concat error is gone. So this is mysql but although using mysql directly without ODBC works, but in connection with myODBC it doesn't. I have quite complext page sql wise and this seem to be the only but that I could find, but it is sever enough to revert back, as I use the group_concat on many occasions and there is no other command that could replace it.
[1 Jun 2018 8:10] Chiranjeevi Battula
Hello Jernej Pecjak,

Thank you for the bug report.
I could not repeat the issue at our end using Connector / ODBC 5.3.10 & 8.0.11, MySQL 8.0.11  with Windows 10 and it worked without any issues.
Could you please provide repeatable test case (exact steps, screenshot etc. - please make it as private if you prefer) to confirm this issue at our end?

Thanks,
Chiranjeevi.
[2 Jul 2018 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".