Bug? bug in executejson

[Sepehr_b]

Hi,
It seems that ExecuteJSON converts Null value in Integer fields to 0

see the following code:

Dim mT1 As Map = DBUtils.Executemap(B4XPages.MainPage.Db, $"SELECT FDId,Qty FROM FactorDetails WHERE FdId = 659947"$, Null)
Log(mT1.As(String))
Dim mT2 As Map = DBUtils.ExecuteJSON(B4XPages.MainPage.Db, $"SELECT FDId,Qty FROM FactorDetails WHERE FdId = 659947"$, Null, 0, Array As String(DBUtils.DB_INTEGER, DBUtils.DB_INTEGER))
Log(mT2.Get("root").As(String))

here is pasted from the log:
ExecuteMap: SELECT FDId,Qty FROM FactorDetails WHERE FdId = 659947
(MyMap) {fdid=659947, qty=null}
ExecuteJSON: SELECT FDId,Qty FROM FactorDetails WHERE FdId = 659947
[{FDId=659947, Qty=0}]


it should make equal maps but in the second map, the value of Qty is 0, it should be Null

 

[Erel]

This is not a bug. If you pass DB_INTEGER then it calls Result.Set.GetLong and it casts nulls to zero. This is the expected behavior.