amotl
commented
2 years ago Dear John,
thank you for your feedback on this topic and apologies for the late reply. The content within this repository is a verbatim copy of the SQL-99 Complete, Really book. In order to reproduce its original content, we will probably not make any changes to it.
However, we could think about adding a custom errata section if that would fit your bill. Please submit a respective pull request if you think that would improve the situation.
Entered SELECT (1.000001 + 1.999990) * 11000; in crash command line in Windows.
This book reflects the SQL-99 standard, not the specific behavior of CrateDB. We are currently in the progress of improving the situation with the published SQL-99 book by giving it a more distinct look in order to avoid any confusion between CrateDB SQL and SQL-99. We will let you know as soon as this has been concluded.
On the other hand, I would like to encourage you to create an issue over at https://github.com/crate/crate if you think you discovered a bug within CrateDB.
With kind regards, Andreas.
jlb555555
Documentation feedback
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 thes 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 thes 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” ????