Bug #7078 EOleException when query cache is enabled

• Submitted: 7 Dec 2004 14:16
• Modified: 15 Dec 2004 4:34
• Reporter: Mathieu Tremblay
• Status: Not a Bug
• Category: Connector / ODBC
• Severity: S3 (Non-critical)
• Version: MySQL 4.1.7-max
• OS: Windows (Windows XP)
• CPU Architecture: Any

[7 Dec 2004 14:16] Mathieu Tremblay

Description:
Delphi 7, ADO and MyODBC 3.51.10.

When query cache is enable in MySQL in "StartupVariable/Perfomance" thats mean (Cache size > 0), when query the Server is give a Exception.

Error: EOleException: "Multiple-step operation generated errors" 

When Cache is disabled there is no problem .

Is there something about configuration ???

How to repeat:
Using Delphi 7 ADO and MyODBD 3.51.10 and query the server with diffrerent version of querys.

[8 Dec 2004 0:45] Heikki Tuuri

Hi!

If this is a MySQL bug at all, it is probably in the ODBC module.

I am changing the category of this bug.

Regards,

Heikki

[10 Dec 2004 3:29] MySQL Verification Team

Could you please show for us your code for to try to test with
ADO and MyODBC even with another language client ?

Thank you in advance.

[15 Dec 2004 3:56] Mathieu Tremblay

I tested the system with query cache enabled for a week with all client having the same version of MyODBC and its seems to work properly...

So that was probably the source of the problem(client with different version of myODBC)...

All client: MyODBC version 3.51.10
Server:  MySQL Version 4.1.7.

Mathieu

[15 Dec 2004 4:34] MySQL Verification Team

Thank you for the update.