Forum: Building VoltDB Clients

Post: Decimal column with NULL value is not being transmitted as a JSON null

Decimal column with NULL value is not being transmitted as a JSON null
junjun
Jul 19, 2010
Hello again,
When I query a table with a decimal column that is NULL, the JSON response for the data entity looks like this:
"data":[[100,"NULL"]]
where "NULL" is then parsed as a string by the JSON client.
Compare that with this one returned from a small int column (and all other number columns):
"data":[[100,null]]
Guess the decimal behavior is a bug?
Thanks!
Junjun
It's probably a bug, yes.
jhugg
Jul 19, 2010
It's probably a bug, yes. I created a ticket. Not sure if the fix will make it into 1.1 though. We'll see.
https://issues.voltdb.com/browse/ENG-648
Thanks a lot junjun.
-John
Should be fixed in r798.
jhugg
Jul 19, 2010
Should be fixed in r798. Let me know if it doesn't do what makes sense now.
Works now. Thanks, thanks.
junjun
Jul 19, 2010
Should be fixed in r798. Let me know if it doesn't do what makes sense now.


Works now. Thanks, thanks.