Re: Mysql Connector LEFT JOIN Bug
Posted by: Peter Brawley
Date: May 30, 2020 04:51PM

Quote

The connector must be in use hundreds of thousands of times

Exactly, the problem you're having must be local to your setup.

Quote

One statement is fine, as long as I don't append an ORDER BY. After doing this the expected resultset shrinks from over 8k rows to 1 row - only
reproducable executed via this connector.

Ah, it's responding as if you'd specified CommandBehavior.SingleRow. Did you try other CommandBehavior settings?

Does this happen if you don't override ExecuteReader?

If it's me, I add in code to ...override ExecuteReader... tracking how many rows the query returned, where their buffer is &c.



Edited 2 time(s). Last edit at 05/30/2020 04:52PM by Peter Brawley.

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.