I am currently using MyDAC 9.0.1 with Delphi 10.2 - get that cleared up.
We've come across an odd issue with MyDAC and MySQL 5.5. When running the below query, we get an 'odd' result:
Code: Select all
select min(starttime) as starttime, max(endtime) as endtime from tbl;
When run as two separate queries, I am seeing '8:07:05 AM' and '10:27:30 PM'.
Both fields in question are 'time' fields.
Has anyone seen this before? Do we know if the update to 9.1 fixes this?
So you are aware, this does NOT happen against a MySQL 5.7 database; it also does not happen with the FireDAC components.
I built a small app to connect using FireDAC, then MyDAC and run the same queries against the same database and FireDAC returns the expected results, only MyDAC seems to be returning the incorrect values.
Any help will be greatly appreciated!