crate / crate/sql-99

Missing '(' in formula

Open
#74 2 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.