MySQL Database Incomplete Results

[nvalenzu]

Hi All, 

I am having an issue where after establishing a connection to a MySQL database, the results I pull are incomplete when compared to the same query run through MySQL Workbench. The issue arose when trying to dump a table (i.e., excluded the WHERE statement) and only received 800 records. For reference there should have been thousands. So I ran the same query in Workbench and got the expected result.  

Separately, for some of the tables the query will continue to run, but never produce any results. I wanted to see if anyone had encountered this issue, or had a solution. 

Thanks!

[JoeS]

What driver are you using?

I'd look to potentially try a different driver first to see if the issue persists there.