Table has a total of 1,120,000 rows and 20 columns. When I run a select query on mysql directly like:
select * from <tablename> where UpdatedOn > '2020-10-05'
it gives the results which is about 50+ rows.
But when I run the same from MSSQL using ODBC Connection it throws "MySQL Client Out of Memory" every single time.
- The server has 8 GB RAM and no one else is using the server
- Running Select top gives the results without the error
- Running select with a single integer column like select id from ... throws a "MySQL Client out of memory"
What could be going wrong? I haven't been able to the issue.