Missing '(' in formula
- Dominant language
- No language data
- Stars
- 25
- Forks
- 8
- PR merge metrics
- No merged PRs in 30d
Description
### Documentation feedback
- Page title: Chapter 3 – Numbers
- Page URL: https://crate.io/docs/sql-99/en/latest/chapters/03.html
- Source: https://github.com/crate/sql-99/blob/master/docs/chapters/03.rst
---
Text:
Example: Try passing the expression: 1.000001 + 1.999990) * 11000 to our calculator. Our proc gives the correct result: “33000.0000000”. The compilers we tested gave the wrong result: “32999.9901000”. (Remember that in SQL all the s in this expression are DECIMAL, not floating-point, s.)
Should read:
Example: Try passing the expression: (1.000001 + 1.999990) * 11000 to our calculator. Our proc gives the correct result: “33000.0000000”. The compilers we tested gave the wrong result: “32999.9901000”. (Remember that in SQL all the s in this expression are DECIMAL, not floating-point, s.)
Entered SELECT (1.000001 + 1.999990) * 11000; in crash command line in Windows.
Output:
+-----------+
| 32999.901 |
+-----------+
| 32999.901 |
+-----------+
Should be
“33000.0000000” ????
Contributor guide
Assessment
This issue has not been assessed yet.