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:

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.