Repository: trafodion Updated Branches: refs/heads/master 930de57fe -> 40cd13b8a
[TRAFODION-3141] Correct Syntax Descriptions of *Float* in *Trafodion SQL Reference Manual* Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/dbcd54ac Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/dbcd54ac Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/dbcd54ac Branch: refs/heads/master Commit: dbcd54acb8b85d44751c6e95845d6fd87c89ef06 Parents: ab6805d Author: liu.yu <[email protected]> Authored: Fri Jul 13 11:32:32 2018 +0800 Committer: liu.yu <[email protected]> Committed: Fri Jul 13 11:32:32 2018 +0800 ---------------------------------------------------------------------- docs/sql_reference/src/asciidoc/_chapters/introduction.adoc | 2 +- .../src/asciidoc/_chapters/sql_functions_and_expressions.adoc | 4 ++-- .../src/asciidoc/_chapters/sql_language_elements.adoc | 6 +++--- 3 files changed, 6 insertions(+), 6 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/trafodion/blob/dbcd54ac/docs/sql_reference/src/asciidoc/_chapters/introduction.adoc ---------------------------------------------------------------------- diff --git a/docs/sql_reference/src/asciidoc/_chapters/introduction.adoc b/docs/sql_reference/src/asciidoc/_chapters/introduction.adoc index 63e9310..3779177 100644 --- a/docs/sql_reference/src/asciidoc/_chapters/introduction.adoc +++ b/docs/sql_reference/src/asciidoc/_chapters/introduction.adoc @@ -339,7 +339,7 @@ For more information about numeric data type for Hive and Trafodion, see the tab | `float` | `real` | `decimal (precision, scale)` | `decimal (precision, scale)`^1^ + `numeric (precision, scale)`^2^ -| `double` | `float(54)` +| `double` | `float` |=== 1. If p is less than or equal to 18, decimal (precision, scale) is mapped to decimal (precision, scale). http://git-wip-us.apache.org/repos/asf/trafodion/blob/dbcd54ac/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc ---------------------------------------------------------------------- diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc b/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc index f84eec0..625952f 100644 --- a/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc +++ b/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc @@ -8270,7 +8270,7 @@ result table is empty, STDDEV returns NULL. [[float54_and_double_precision_data]] ==== FLOAT(54) and DOUBLE PRECISION Data -Avoid using large FLOAT(54) or DOUBLE PRECISION values as arguments to +Avoid using large FLOAT(52) or DOUBLE PRECISION values as arguments to STDDEV. If SUM(x * x) exceeds the value of 1.15792089237316192e77 during the computation of STDDEV(x), a numeric overflow occurs. @@ -9929,7 +9929,7 @@ result table is empty, VARIANCE returns NULL. [[float54_and_double_precision_data]] ==== FLOAT(54) and DOUBLE PRECISION Data -Avoid using large FLOAT(54) or DOUBLE PRECISION values as arguments to +Avoid using large FLOAT(52) or DOUBLE PRECISION values as arguments to VARIANCE. If SUM(x * x) exceeds the value of 1.15792089237316192e77 during the computation of VARIANCE(x), then a numeric overflow occurs. http://git-wip-us.apache.org/repos/asf/trafodion/blob/dbcd54ac/docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc ---------------------------------------------------------------------- diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc b/docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc index 72a6052..7e8bd63 100644 --- a/docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc +++ b/docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc @@ -385,7 +385,7 @@ depending on precision | LARGEINT | Binary integer; signed only | -2^63^ to +(2^63^)-1; stored in 8 bytes |Numeric (extended numeric precision)^7^ | NUMERIC (precision 19 to 128) | Binary integer; signed or unsigned | Stored as multiple chunks of 16-bit integers, with a minimum storage length of 8 bytes. -.3+| Floating point number^7^ | FLOAT[(_precision_)] | Floating point number; precision designates from 1 through 52 bits of precision | +/- 2.2250738585072014e-308 through +/-1.7976931348623157e+308; stored in 8 bytes +.3+| Floating point number^7^ | FLOAT[(_precision_)] | Floating point number (64 bits); precision designates from 1 through 52 bits of precision | +/- 2.2250738585072014e-308 through +/-1.7976931348623157e+308; stored in 8 bytes | REAL | Floating point number (32 bits) | +/- 1.17549435e-38 through +/ 3.40282347e+38; stored in 4 bytes | DOUBLE PRECISION | Floating-point numbers (64 bits) with 1 through 52 bits of precision (52 bits of binary precision and 1 bits of exponent) | +/- 2.2250738585072014e-308 through +/-1.7976931348623157e+308; stored in 8 bytes | Decimal number^6^ | DECIMAL (1,_scale_) to DECIMAL (18,_scale_) | Decimal number with optional scale; stored as ASCII characters; signed or unsigned for 1 to 9 digits; signed required for 10 or more digits @@ -1052,12 +1052,12 @@ The default is DECIMAL (9,0) SIGNED. + specifies an approximate numeric column. The column stores floating-point numbers and -designates from 1 through 54 bits of _precision_. +designates from 1 through 52 bits of _precision_. The range is from +/- 2.2250738585072014e-308 through +/-1.7976931348623157e+308 stored in 8 bytes. + An IEEE FLOAT _precision_ data type is stored as an IEEE DOUBLE, that is, in 8 bytes, with the specified precision. + -The default _precision_ is 54. +The default _precision_ is 52. * `REAL` +
