Share
Report
4Hello,
I am running into an issue where in my MySQL Get Rows step the number or rows returned is correct, but some rows are missing and others are duplicates. I've tried changing multiple settings individually to see if it might be one of those (List of settings changed below), but nothing worked. I've checked to make sure the table is indexed, still didn't fix the issue. Odd thing is, if I add another filter parameter to only select a row that isn't being returned in the general query, that row gets returned. So, the connector can find the items that it is missing, just not in the larger query. I'm starting to wonder if it's a flaw in the MySQL connector. Any insight would be greatly appreciated!
Setup:
Settings that have been tried:
Pagination both on and off
Maximum Get Count set to a number (5000 in screenshot) and also left as default - With pagination
Maximum Get Count set to a number (5000 in screenshot) and also left as default - Without pagination
Asynchronous pattern both on and off
Select Query with columns defined and without columns defined
Connection to MySQL DB is via the Microsoft On Premise Data Gateway. Have not had any issues with this as it does allow me to connect and do multiple queries.
All responses (
Answers (
