When querying a Mysql database, I only get some of the data back.
The debug node shows the correct number of result rows, but only the first 9 shows data.
Is this the intended funcionality ?
Would you be able to share a screenshot of your SQL Node configuration, SQL Query, and workflow? Having this will help me contextualize your problem, and help me help you better!
Thank you,
Heath
Thanks for those screenshots! I don’t see anything that would cause this to happen in your SQL Node configuration.
Would you be able to share a screenshot of your workflow that’s making this SQL query?
Thank you,
Heath
This workflow runs on a edge device
I would recommend downloading MySQL Workbench, connect to your database, and run the same query in it. Do you get the same response when doing this?
Thank you,
Heath
Already tested that. I get all rows from the result there.
I just found something interesting.
If I select 2 columns by name and not “*” , I get 2 resul trows back, and the rest showing “success”.
If I select 3, I get 3 back and so on.
So when I select “*” for all columns, I only receive result data from as many records as number of columns in the select statement.
That doesn’t sound right to me.
We dug into this on our end and found a bug. We’re issuing a fix right now, and I’ll be sure to update you when it’s rolled out.
I also wanted to thank you for pointing this out. You are helping us make Losant better!
Thank you,
Heath
How far away is the fix?
Was this problem only for MySQL connections?
The fix is out now. We rolled out a new version of the Edge Agent to fix this, you can read more in the Edge Agent Changelog. You will need to pull down the newest version of the Losant Edge Agent to implement this fix.
As far as we know, this problem was only for MySQL connections. If you run into this same issue with another database node, please don’t hesitate to reach out.
Thank you,
Heath