#918 TDBCron updated SQL with "Order By" to stop random test failure

pradosoft / prado

Prado - Component Framework for PHP

Other

187 stars 70 forks source link

#918 TDBCron updated SQL with "Order By" to stop random test failure #919

Closed belisoful closed 1 year ago

belisoful commented 1 year ago

I am taking a wild swing at this one. I do hope this fixes the bug, but it's hard to tell when the bug is so spotty. I think this is more of a bug with the DB than PRADO, but hey, this should fix that quirk.

I didn't think this was necessary because.... wouldn't the DB return the table in the order of insertion?

apparently, randomly, it switches rows unless explicitly ordered

belisoful commented 1 year ago

After this is merged, we'll leave the issue open for a bit and see if the error randomly keep coming up.