sql-formatter-org / sql-formatter / 11523256048

96%

push

github

Add support for decimal values without leading digits (#794)

Encountered issue while handling decimal values without leading digits
(for example .00457). Lexer was breaking, updated number token regex to
support the similar cases and added a corresponding test case.

Sample SQL query: `SELECT employee_id FROM employees WHERE salary > .456
* 1000000 AND bonus < .0000239 * salary;`
```
An Unexpected Error Occurred
Parse error at token: 456 at line 1 column 51 Unexpected NUMBER token: {"type":"NUMBER","raw":"456","text":"456","start":50}
```

547 of 616 branches covered (88.8%)

Branch coverage included in aggregate %.

1241 of 1261 relevant lines covered (98.41%)

13692.27 hits per line