db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r1449749 - in /db/derby/docs/trunk/src/ref: rreffuncasin.dita rreffuncatan.dita rrefnumericlimits.dita rrefsqlj14122.dita rrefsqlj20204.dita rrefsqljdoubleprecision.dita
Date Mon, 25 Feb 2013 15:32:01 GMT
Author: chaase3
Date: Mon Feb 25 15:32:01 2013
New Revision: 1449749

URL: http://svn.apache.org/r1449749
Log:
DERBY-6083  Update minimum/maximum floating-point values to align with DERBY-3398 fixes

Modified 6 Reference Manual topics.

Patch: DERBY-6083-2.diff

Modified:
    db/derby/docs/trunk/src/ref/rreffuncasin.dita
    db/derby/docs/trunk/src/ref/rreffuncatan.dita
    db/derby/docs/trunk/src/ref/rrefnumericlimits.dita
    db/derby/docs/trunk/src/ref/rrefsqlj14122.dita
    db/derby/docs/trunk/src/ref/rrefsqlj20204.dita
    db/derby/docs/trunk/src/ref/rrefsqljdoubleprecision.dita

Modified: db/derby/docs/trunk/src/ref/rreffuncasin.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rreffuncasin.dita?rev=1449749&r1=1449748&r2=1449749&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rreffuncasin.dita (original)
+++ db/derby/docs/trunk/src/ref/rreffuncasin.dita Mon Feb 25 15:32:01 2013
@@ -30,8 +30,7 @@ limitations under the License.
 you want. The specified number must be a <xref href="rrefsqljdoubleprecision.dita#rrefsqljdoubleprecision">DOUBLE
 PRECISION</xref> number.  <ul>
 <li>If the specified number is NULL, the result of this function is NULL. </li>
-<li>If the specified number is zero (0), the result of this function is zero
-with the same sign as the specified number.</li>
+<li>If the specified number is zero (0), the result of this function is zero.</li>
 <li>If the absolute value of the specified number is greater than 1, an exception
 is returned that indicates that the value is out of range (SQL state 22003).</li>
 </ul></p><p>The returned value, in radians, is in the range -<term>pi</term>/2

Modified: db/derby/docs/trunk/src/ref/rreffuncatan.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rreffuncatan.dita?rev=1449749&r1=1449748&r2=1449749&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rreffuncatan.dita (original)
+++ db/derby/docs/trunk/src/ref/rreffuncatan.dita Mon Feb 25 15:32:01 2013
@@ -30,8 +30,7 @@ limitations under the License.
 that you want. The specified number must be a <xref href="rrefsqljdoubleprecision.dita#rrefsqljdoubleprecision">DOUBLE
 PRECISION</xref> number.  <ul>
 <li>If the specified number is NULL, the result of this function is NULL. </li>
-<li>If the specified number is zero (0), the result of this function is zero
-with the same sign as the specified number.</li>
+<li>If the specified number is zero (0), the result of this function is zero.</li>
 </ul></p><p>The returned value, in radians, is in the range -<term>pi</term>/2
 to <term>pi</term>/2. The data type of the returned value is a DOUBLE PRECISION
 number.</p> </section>

Modified: db/derby/docs/trunk/src/ref/rrefnumericlimits.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefnumericlimits.dita?rev=1449749&r1=1449748&r2=1449749&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefnumericlimits.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefnumericlimits.dita Mon Feb 25 15:32:01 2013
@@ -42,27 +42,27 @@ limitations under the License.
 </thead>
 <tbody>
 <row>
-<entry colname="colspec0">Smallest INTEGER</entry>
+<entry colname="colspec0">Largest negative INTEGER</entry>
 <entry colname="colspec1">-2,147,483,648</entry>
 </row>
 <row>
-<entry colname="colspec0">Largest INTEGER</entry>
+<entry colname="colspec0">Largest positive INTEGER</entry>
 <entry colname="colspec1">2,147,483,647</entry>
 </row>
 <row>
-<entry colname="colspec0">Smallest BIGINT</entry>
+<entry colname="colspec0">Largest negative BIGINT</entry>
 <entry colname="colspec1">-9,223,372,036,854,775,808</entry>
 </row>
 <row>
-<entry colname="colspec0">Largest BIGINT</entry>
+<entry colname="colspec0">Largest positive BIGINT</entry>
 <entry colname="colspec1">9,223,372,036,854,775,807</entry>
 </row>
 <row>
-<entry colname="colspec0">Smallest SMALLINT</entry>
+<entry colname="colspec0">Largest negative SMALLINT</entry>
 <entry colname="colspec1">-32,768</entry>
 </row>
 <row>
-<entry colname="colspec0">Largest SMALLINT</entry>
+<entry colname="colspec0">Largest positive SMALLINT</entry>
 <entry colname="colspec1">32,767</entry>
 </row>
 <row>
@@ -70,36 +70,52 @@ limitations under the License.
 <entry colname="colspec1">31</entry>
 </row>
 <row>
-<entry colname="colspec0">Smallest DOUBLE</entry>
-<entry colname="colspec1">-1.79769E+308</entry>
+<entry colname="colspec0">Largest negative DOUBLE</entry>
+<entry colname="colspec1">-1.7976931348623157E+308</entry>
 </row>
 <row>
-<entry colname="colspec0">Largest DOUBLE</entry>
-<entry colname="colspec1">1.79769E+308</entry>
+<entry colname="colspec0">Largest positive DOUBLE</entry>
+<entry colname="colspec1">1.7976931348623157E+308</entry>
 </row>
 <row>
-<entry colname="colspec0">Smallest positive DOUBLE</entry>
-<entry colname="colspec1">2.225E-307</entry>
+<entry colname="colspec0">Smallest negative normalized DOUBLE</entry>
+<entry colname="colspec1">-2.2250738585072014E-308</entry>
 </row>
 <row>
-<entry colname="colspec0">Largest negative DOUBLE</entry>
-<entry colname="colspec1">-2.225E-307</entry>
+<entry colname="colspec0">Smallest positive normalized DOUBLE</entry>
+<entry colname="colspec1">2.2250738585072014E-308</entry>
+</row>
+<row>
+<entry colname="colspec0">Smallest negative denormalized DOUBLE</entry>
+<entry colname="colspec1">-4.9E-324</entry>
 </row>
 <row>
-<entry colname="colspec0">Smallest REAL</entry>
-<entry colname="colspec1">-3.402E+38</entry>
+<entry colname="colspec0">Smallest positive denormalized DOUBLE</entry>
+<entry colname="colspec1">4.9E-324</entry>
 </row>
 <row>
-<entry colname="colspec0">Largest REAL</entry>
-<entry colname="colspec1">3.402E+38</entry>
+<entry colname="colspec0">Largest negative REAL</entry>
+<entry colname="colspec1">-3.4028235E+38</entry>
 </row>
 <row>
-<entry colname="colspec0">Smallest positive REAL</entry>
-<entry colname="colspec1">1.175E-37</entry>
+<entry colname="colspec0">Largest positive REAL</entry>
+<entry colname="colspec1">3.4028235E+38</entry>
 </row>
 <row>
-<entry colname="colspec0">Largest negative REAL</entry>
-<entry colname="colspec1">-1.175E-37</entry>
+<entry colname="colspec0">Smallest negative normalized REAL</entry>
+<entry colname="colspec1">-1.17549435E-38</entry>
+</row>
+<row>
+<entry colname="colspec0">Smallest positive normalized REAL</entry>
+<entry colname="colspec1">1.17549435E-38</entry>
+</row>
+<row>
+<entry colname="colspec0">Smallest negative denormalized REAL</entry>
+<entry colname="colspec1">-1.4E-45</entry>
+</row>
+<row>
+<entry colname="colspec0">Smallest positive denormalized REAL</entry>
+<entry colname="colspec1">1.4E-45</entry>
 </row>
 </tbody>
 </tgroup>

Modified: db/derby/docs/trunk/src/ref/rrefsqlj14122.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj14122.dita?rev=1449749&r1=1449748&r2=1449749&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj14122.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj14122.dita Mon Feb 25 15:32:01 2013
@@ -30,16 +30,26 @@ IEEE floating-point notation. </p></sect
 <section><title>Corresponding compile-time Java type</title> <p><i>java.lang.Float</i></p>
</section>
 <section><title>JDBC metadata type (java.sql.Types)</title> <p>REAL</p>
</section>
 <section><title>Limitations</title> <p>REAL value ranges:</p>
<ul>
-<li>Smallest REAL value: -3.402E+38</li>
-<li>Largest REAL value: 3.402E+38</li>
-<li>Smallest positive REAL value: 1.175E-37</li>
-<li>Largest negative REAL value: -1.175E-37</li>
-</ul> <p>These limits are different from the <codeph>java.lang.Float</codeph>
Java
+<li>Largest negative REAL value: -3.4028235E+38</li>
+<li>Largest positive REAL value: 3.4028235E+38</li>
+<li>Smallest negative normalized REAL value: -1.17549435E-38</li>
+<li>Smallest positive normalized REAL value: 1.17549435E-38</li>
+<li>Smallest negative denormalized REAL value: -1.4E-45</li>
+<li>Smallest positive denormalized REAL value: 1.4E-45</li>
+</ul> <p>These limits are the same as the <codeph>java.lang.Float</codeph>
Java
 type limits.</p> <p>An exception is thrown when any double value is calculated
 or entered that is outside of these value ranges. Arithmetic operations <b>do
 not</b> round their resulting values to zero. If the values are too small,
 you will receive an exception. The arithmetic operations take place with double
-arithmetic in order to detect under flows.</p> <p>Numeric floating point constants
+arithmetic in order to detect underflows.</p>
+<p><ph conref="../conrefs.dita#prod/productshortname"></ph> normalizes
-0.0 to
+positive 0.0.</p>
+<p><ph conref="../conrefs.dita#prod/productshortname"></ph> throws an exception
+if an operation calculates or tries to store a value of NaN, positive infinity,
+or negative infinity, as defined by the <cite>IEEE 754 Standard for Binary 
+Floating-Point Arithmetic</cite> and as represented with named constants in the
+Java programming language (for example, <codeph>Double.NaN</codeph>).</p>
+<p>Numeric floating-point constants
 are limited to a length of 30 characters. <codeblock>-- this example will fail because
the constant is too long: 
 <b>values 01234567890123456789012345678901e0;</b></codeblock></p>
<p>When
 mixed with other data types in expressions, the resulting data type follows

Modified: db/derby/docs/trunk/src/ref/rrefsqlj20204.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj20204.dita?rev=1449749&r1=1449748&r2=1449749&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj20204.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj20204.dita Mon Feb 25 15:32:01 2013
@@ -24,31 +24,33 @@ data type</title>
 <refbody>
 <section><p>An attempt to put a floating-point type of a larger storage size
 into a location of a smaller size fails only if the value cannot be stored
-in the smaller-size location. For example:   <codeblock><b>create table mytable
(r REAL, d DOUBLE PRECISION);</b>
+in the smaller-size location. For example:
+<codeblock><b>create table mytable (r REAL, d DOUBLE PRECISION, i INTEGER, de
DECIMAL);</b>
 0 rows inserted/updated/deleted
 <b>INSERT INTO mytable (r, d) values (3.4028236E38, 3.4028235E38);</b>
-ERROR X0X41: The number '3.4028236E38' is outside the range for
-the data type REAL.</codeblock></p></section>
+ERROR 22003: The resulting value is outside the range for the
+data type REAL.</codeblock></p></section>
 <section><p>You can store a floating point type in an INTEGER column; the
-fractional part of the number is truncated. For example:   <codeblock><b><ph>INSERT
INTO mytable(integer_column) values (1.09e0);</ph>
+fractional part of the number is truncated. For example:
+<codeblock><b><ph>INSERT INTO mytable (i) VALUES (1.09e0);</ph></b>
 1 row inserted/updated/deleted
-<ph>SELECT integer_column
-FROM mytable;</ph>
+<b><ph>SELECT i FROM mytable;</ph></b>
 I
 ---------------
-1</b></codeblock></p></section>
+1</codeblock></p></section>
 <section><p>Integer types can always be placed successfully in approximate
 numeric values, although with the possible loss of some precision.</p></section>
 <section><p>Integers can be stored in decimals if the DECIMAL precision is
-large enough for the value. For example:   <codeblock><b>ij&gt; <ph>insert
into mytable (decimal_column)
-VALUES (55555555556666666666);</ph>
-ERROR X0Y21: The number '55555555556666666666' is outside the
-range of the target DECIMAL/NUMERIC(5,2) datatype.</b></codeblock></p></section>
+large enough for the value. For example:
+<codeblock><b><ph>INSERT INTO mytable (de) VALUES (55555555556666666666);</ph></b>
+ERROR 22003: The resulting value is outside the range for the
+data type DECIMAL/NUMERIC(5,2).</codeblock></p></section>
 <section><p>An attempt to put an integer value of a larger storage size into
 a location of a smaller size fails if the value cannot be stored in the smaller-size
-location. For example:   <codeblock><b><ph>INSERT INTO mytable (int_column)
values 2147483648;</ph>
+location. For example:
+<codeblock><b><ph>INSERT INTO mytable (i) VALUES 2147483648;</ph></b>
 ERROR 22003: The resulting value is outside the range for the 
-data type INTEGER.</b></codeblock></p></section>
+data type INTEGER.</codeblock></p></section>
 <section> <note>When truncating trailing digits from a NUMERIC value, <ph
 conref="../conrefs.dita#prod/productshortname"></ph> rounds down.</note></section>
 </refbody>

Modified: db/derby/docs/trunk/src/ref/rrefsqljdoubleprecision.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljdoubleprecision.dita?rev=1449749&r1=1449748&r2=1449749&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljdoubleprecision.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljdoubleprecision.dita Mon Feb 25 15:32:01 2013
@@ -30,15 +30,25 @@ using IEEE floating-point notation. </p>
 alternately</p> <codeblock><b>DOUBLE</b></codeblock> <p>DOUBLE
can be used
 synonymously with DOUBLE PRECISION.</p> </refsyn>
 <section><title>Limitations</title> <p>DOUBLE value ranges:</p>
<ul>
-<li>Smallest DOUBLE value: -1.79769E+308</li>
-<li>Largest DOUBLE value: 1.79769E+308</li>
-<li>Smallest positive DOUBLE value: 2.225E-307</li>
-<li>Largest negative DOUBLE value: -2.225E-307</li>
-</ul> <p>These limits are different from the <codeph>java.lang.Double</codeph>Java
+<li>Largest negative DOUBLE value: -1.7976931348623157E+308</li>
+<li>Largest positive DOUBLE value: 1.7976931348623157E+308</li>
+<li>Smallest negative normalized DOUBLE value: -2.2250738585072014E-308</li>
+<li>Smallest positive normalized DOUBLE value: 2.2250738585072014E-308</li>
+<li>Smallest negative denormalized DOUBLE value: -4.9E-324</li>
+<li>Smallest positive denormalized DOUBLE value: 4.9E-324</li>
+</ul> <p>These limits are the same as the <codeph>java.lang.Double</codeph>
Java
 type limits.</p> <p>An exception is thrown when any double value is calculated
 or entered that is outside of these value ranges. Arithmetic operations <b>do
 not</b> round their resulting values to zero. If the values are too small,
-you will receive an exception. </p> <p>Numeric floating point constants are
+you will receive an exception. </p>
+<p><ph conref="../conrefs.dita#prod/productshortname"></ph> normalizes
-0.0 to
+positive 0.0.</p>
+<p><ph conref="../conrefs.dita#prod/productshortname"></ph> throws an exception
+if an operation calculates or tries to store a value of NaN, positive infinity,
+or negative infinity, as defined by the <cite>IEEE 754 Standard for Binary 
+Floating-Point Arithmetic</cite> and as represented with named constants in the
+Java programming language (for example, <codeph>Double.NaN</codeph>).</p>
+<p>Numeric floating-point constants are
 limited to a length of 30 characters. <codeblock>-- this example will fail because
the constant is too long: 
 <b>values 01234567890123456789012345678901e0;</b></codeblock></p>
</section>
 <section><title>Corresponding compile-time Java type</title> <p><i>java.lang.Double</i></p>
</section>



Mime
View raw message