SQLite

View Ticket
Login
2017-04-08
18:18 Fixed ticket [b93be872]: JSON extension accepts invalid numeric values plus 5 other changes (artifact: 39c0f43a user: drh)
18:18
Disallow leading zeros on numeric constants in JSON. Fix for ticket [b93be8729a895a528e2] (check-in: 204e72f0 user: drh tags: trunk)
17:54 New ticket [b93be872] JSON extension accepts invalid numeric values. (artifact: 72ad25bf user: drh)

Ticket Hash: b93be8729a895a528e2849fca99f716cc80cec91
Title: JSON extension accepts invalid numeric values
Status: Fixed Type: Code_Defect
Severity: Important Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2017-04-08 18:18:32
Version Found In:
User Comments:
drh added on 2017-04-08 17:54:19:

The JSON spec says that numeric values may not have leading zeros. The value can consist of a single zero or a zero before the decimal point, but otherwise the first digit must be between 1 and 9. The SQLite JSON extension does not enforce this and allows numeric values with an unlimited number of leading zeros.