Advantage returning wrong value on Null in Delphi Tokyo

[former_member229545]

Trying Delphi 10.2.1 Tokyo and came across an interesting bug, a simple stat,ment that returns a null value such as:

Select Cast(Null AS SQL_MONEY) Value From System.iota;

Returns a value of: -922337203685477.58, instead of Null

(Test by attaching a DBGrid to DataSOirce to AdsQuery)

Did same test with FDQuery (FireDac) using ADS driver, and it works properly.

[joachim_drr · Accepted solution]

found the bug and fixed it. See my blog for details:

https://www.jd-engineering.de/advantage-returning-wrong-value-on-null-in-delphi-tokyo/