Myquery1.SQL.Text := 'select *,false as pago from gastos'.
In that example the fiel pago is LargeInt (error) When in reality is Boolean
In version 5.10 working correctly in 5.20 no.
Error in version 5.20
Yes, you are right. We added mapping of boolean constants to TBooleanField in MyDAC 5.10.
But it also caused mapping of such integer constants as 1 and 0 to TBooleanField. After some deeper investigation we found out that MySQL server returns the same result for both queries 'SELECT FALSE' and 'SELECT 0', and there is no way to ascertain which of queries was executed. Therefore we had to rollback this fix in one of the subsequent builds.
But it also caused mapping of such integer constants as 1 and 0 to TBooleanField. After some deeper investigation we found out that MySQL server returns the same result for both queries 'SELECT FALSE' and 'SELECT 0', and there is no way to ascertain which of queries was executed. Therefore we had to rollback this fix in one of the subsequent builds.