[DOC] Largest TIMESTAMP value in Derby limitations section of reference manual
is documented incorrectly
--------------------------------------------------------------------------------------------------------
Key: DERBY-1803
URL: http://issues.apache.org/jira/browse/DERBY-1803
Project: Derby
Issue Type: Bug
Components: Documentation
Affects Versions: 10.1.3.1
Reporter: Susan Cline
The documentation for the Largest TIMESTAMP value in the DATE, TIME and
TIMESTAMP limitations section of the Derby limitations of the reference manual
is incorrect.
http://db.apache.org/derby/docs/dev/ref/rrefdttlimits.html
The incorrectly stated value is 9999-12-31-24.00.00.000000
The correct value should be 9999-12-31-23.59.59.999999
I tested this on a 10.1.3 and the 10.2 beta releases.
ij> create table timestamp_tab(id integer, timestamp_col timestamp);
0 rows inserted/updated/deleted
ij> insert into timestamp_tab values (2, '9999-12-31-23.59.59.999999');
1 row inserted/updated/deleted
ij> insert into timestamp_tab values (1, '9999-12-31-24.00.00.000000');
ERROR 22007: The string representation of a datetime value is out of range.
C:\derby_home\derby_10.1.3\lib>java org.apache.derby.tools.sysinfo
------------------ Java Information ------------------
Java Version: 1.4.2_09
Java Vendor: Sun Microsystems Inc.
Java home: C:\JDK\jdk1.4.2_09\jre
Java classpath: derby.jar;.;derbytools.jar;derbynet.jar;derbyclient.jar;
OS name: Windows XP
OS architecture: x86
OS version: 5.1
Java user name: slc
Java user home: C:\Documents and Settings\Administrator
Java user dir: C:\derby_home\derby_10.1.3\lib
java.specification.name: Java Platform API Specification
java.specification.version: 1.4
--------- Derby Information --------
JRE - JDBC: J2SE 1.4.2 - JDBC 3.0
[C:\derby_home\derby_10.1.3\lib\derby.jar] 10.1.3.1 - (417277)
[C:\derby_home\derby_10.1.3\lib\derbytools.jar] 10.1.3.1 - (417277)
[C:\derby_home\derby_10.1.3\lib\derbynet.jar] 10.1.3.1 - (417277)
[C:\derby_home\derby_10.1.3\lib\derbyclient.jar] 10.1.3.1 - (417277)
------------------------------------------------------
----------------- Locale Information -----------------
------------------------------------------------------
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
