diff options
| author | tim@threads.polyesthetic.msg <> | 2001-04-05 15:21:19 -0400 |
|---|---|---|
| committer | tim@threads.polyesthetic.msg <> | 2001-04-05 15:21:19 -0400 |
| commit | 252ab34892dcf59a5befa4708e393680cd7063c9 (patch) | |
| tree | 9f3312eceb9ce94d1943132a54c5cbf3591e5095 | |
| parent | e6765fdcc86cb7689e7725f6d5b581aaac250060 (diff) | |
| download | mariadb-git-252ab34892dcf59a5befa4708e393680cd7063c9.tar.gz | |
Clear up how ROUND() works (i.e., not the way you think).
| -rw-r--r-- | BitKeeper/etc/logging_ok | 2 | ||||
| -rw-r--r-- | Docs/manual.texi | 7 |
2 files changed, 8 insertions, 1 deletions
diff --git a/BitKeeper/etc/logging_ok b/BitKeeper/etc/logging_ok index 1c3bdac2b9f..6656b1b43ac 100644 --- a/BitKeeper/etc/logging_ok +++ b/BitKeeper/etc/logging_ok @@ -1 +1 @@ -heikki@donna.mysql.fi +tim@threads.polyesthetic.msg diff --git a/Docs/manual.texi b/Docs/manual.texi index d30601fc3b7..db44051ecf5 100644 --- a/Docs/manual.texi +++ b/Docs/manual.texi @@ -16449,6 +16449,13 @@ mysql> select ROUND(1.58); -> 2 @end example +Note that the behavior of @code{ROUND()} when the argument +is half way between two integers depends on the C library +implementation. Some round to the nearest even number, +always up, always down, or always towards zero. If you need +one kind of rounding, you should use a well-defined function +like @code{TRUNCATE()} or @code{FLOOR()} instead. + @findex ROUND() @item ROUND(X,D) Returns the argument @code{X}, rounded to a number with @code{D} decimals. |