Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

DeserializeJSON - numbers with lots of trailing zeroes casting to string

Description

Lucee's deserializer seems to get tripped up on numbers in JSON that have lots of zeroes in them.

For example,

will get cast to a string ("1234.00000000") in Lucee when deserialized, while

will properly get cast to a number (1234).

The reason that this is an issue is that we're using Lucee to deserialize JSON that's created by SQL Server, which outputs numeric values with all the trailing zeroes when using something like numeric(22,8).

We're working around this by hacking the JSON text generated by SQL server and taking out the trailing zeros, but it's a nasty code smell.

Environment

None

Activity

Show:

Pothys - MitrahSoft 17 February 2023 at 10:51

I’ve checked this ticket with the lucee fixed version 6.0.0.340-SNAPSHOT. Now the issue was solved

Zac Spitzer 17 February 2023 at 01:21

Michael Offner 16 February 2023 at 14:55

Pothys - MitrahSoft 11 November 2019 at 12:12

I've added a fix for this ticket

Pull Request: https://github.com/lucee/Lucee/pull/788

Pothys - MitrahSoft 29 August 2018 at 15:44

I've added test case for this ticket & Confirmed the issue happened on lucee while numbers with zeroes (above 5 digits). In ACF returns as expected value.

Pull request : https://github.com/lucee/Lucee/pull/565

Fixed

Details

Assignee

Reporter

Priority

Labels

Fix versions

New Issue warning screen

Before you create a new Issue, please post to the mailing list first https://dev.lucee.org

Once the issue has been verified, one of the Lucee team will ask you to file an issue

Sprint

Created 27 August 2018 at 21:29
Updated 17 February 2023 at 10:53
Resolved 17 February 2023 at 10:53