Corresponding compile-time Java type

The returned value, in radians, is in the range -pi/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 DOUBLE PRECISION number.

The returned value, in radians, is in the range -pi/2 to pi/2. The data type of the returned value is a DOUBLE PRECISION number.

Limitations

REAL value ranges:

Smallest REAL value: -3.402E+38
Largest REAL value: 3.402E+38
Smallest positive REAL value: 1.175E-37
Largest negative REAL value: -1.175E-37

These limits are different from the java.lang.Float Java +

Largest negative REAL value: -3.4028235E+38

Largest positive REAL value: 3.4028235E+38

Smallest negative normalized REAL value: -1.17549435E-38

Smallest positive normalized REAL value: 1.17549435E-38

Smallest negative denormalized REAL value: -1.4E-45

Smallest positive denormalized REAL value: 1.4E-45

These limits are the same as the java.lang.Float Java type limits.

An exception is thrown when any double value is calculated or entered that is outside of these value ranges. Arithmetic operations do not 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.

Numeric floating point constants +arithmetic in order to detect underflows.

normalizes -0.0 to +positive 0.0.

throws an exception +if an operation calculates or tries to store a value of NaN, positive infinity, +or negative infinity, as defined by the IEEE 754 Standard for Binary +Floating-Point Arithmetic and as represented with named constants in the +Java programming language (for example, Double.NaN).

Numeric floating-point constants are limited to a length of 30 characters. -- this example will fail because the constant is too long: values 01234567890123456789012345678901e0;

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

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: create table mytable (r REAL, d DOUBLE PRECISION); +in the smaller-size location. For example: +create table mytable (r REAL, d DOUBLE PRECISION, i INTEGER, de DECIMAL); 0 rows inserted/updated/deleted INSERT INTO mytable (r, d) values (3.4028236E38, 3.4028235E38); -ERROR X0X41: The number '3.4028236E38' is outside the range for -the data type REAL.

+ERROR 22003: The resulting value is outside the range for the +data type REAL.

Limitations

DOUBLE value ranges:

Smallest DOUBLE value: -1.79769E+308
Largest DOUBLE value: 1.79769E+308
Smallest positive DOUBLE value: 2.225E-307
Largest negative DOUBLE value: -2.225E-307

These limits are different from the java.lang.DoubleJava +

Largest negative DOUBLE value: -1.7976931348623157E+308

Largest positive DOUBLE value: 1.7976931348623157E+308

Smallest negative normalized DOUBLE value: -2.2250738585072014E-308

Smallest positive normalized DOUBLE value: 2.2250738585072014E-308

Smallest negative denormalized DOUBLE value: -4.9E-324

Smallest positive denormalized DOUBLE value: 4.9E-324

These limits are the same as the java.lang.Double Java type limits.

Numeric floating point constants are +you will receive an exception.

normalizes -0.0 to +positive 0.0.

Numeric floating-point constants are limited to a length of 30 characters. -- this example will fail because the constant is too long: values 01234567890123456789012345678901e0;