SQLite
View Ticket
Not logged in
Ticket UUID: 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: (text/x-fossil-wiki)
The [http://www.rfc-editor.org/rfc/rfc7159.txt|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.