Skip to Content
0

Advantage returning wrong value on Null in Delphi Tokyo

Oct 27, 2017 at 04:00 PM

138

avatar image

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.

SQL
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Joachim Dürr Nov 01, 2017 at 12:42 PM
0
Share
10 |10000 characters needed characters left characters exceeded