You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Susan Cline (JIRA)" <de...@db.apache.org> on 2006/09/01 19:45:22 UTC
[jira] Created: (DERBY-1803) [DOC] Largest TIMESTAMP value in Derby
limitations section of reference manual is documented incorrectly
[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
[jira] Updated: (DERBY-1803) [DOC] Largest TIMESTAMP value in Derby
limitations section of reference manual is documented incorrectly
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1803?page=all ]
Laura Stewart updated DERBY-1803:
---------------------------------
Derby Info: [Patch Available]
> [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
> Assigned To: Laura Stewart
> Attachments: derby1803.diff, derby1803_html.zip
>
>
> 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
[jira] Commented: (DERBY-1803) [DOC] Largest TIMESTAMP value in
Derby limitations section of reference manual is documented incorrectly
Posted by "Jean T. Anderson (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1803?page=comments#action_12432235 ]
Jean T. Anderson commented on DERBY-1803:
-----------------------------------------
Also the largest numeric value documented for a DATE is incorrect:
http://db.apache.org/derby/docs/dev/ref/rrefdatefunc.html
The description says "The argument must be a date, timestamp, a positive
number less than or equal to 3,652,059". In fact the largest number is 2932897 :
ij> values date (2932897);
1
----------
9999-12-31
1 row selected
ij> values date (2932898);
ERROR 22008: '2932898' is an invalid argument to the date function.
> [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
[jira] Closed: (DERBY-1803) [DOC] Largest TIMESTAMP value in Derby
limitations section of reference manual is documented incorrectly
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1803?page=all ]
Laura Stewart closed DERBY-1803.
--------------------------------
> [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
> Assigned To: Laura Stewart
> Fix For: 10.2.1.6, 10.3.0.0
>
> Attachments: derby1803.diff, derby1803_html.zip
>
>
> 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
Re: [jira] Updated: (DERBY-1803) [DOC] Largest TIMESTAMP value in
Derby limitations section of reference manual is documented incorrectly
Posted by "Jean T. Anderson" <jt...@bristowhill.com>.
Laura Stewart (JIRA) wrote:
> [ http://issues.apache.org/jira/browse/DERBY-1803?page=all ]
>
> Laura Stewart updated DERBY-1803:
> ---------------------------------
>
> Attachment: derby1803.diff
> derby1803_html.zip
>
> Updated the date/time limitations and the DATE function file.
> Included are a diff file and an html.zip file.
I'll review this one.
-jean
[jira] Updated: (DERBY-1803) [DOC] Largest TIMESTAMP value in Derby
limitations section of reference manual is documented incorrectly
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1803?page=all ]
Laura Stewart updated DERBY-1803:
---------------------------------
Attachment: derby1803.diff
derby1803_html.zip
Updated the date/time limitations and the DATE function file.
Included are a diff file and an html.zip file.
> [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
> Assigned To: Laura Stewart
> Attachments: derby1803.diff, derby1803_html.zip
>
>
> 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
[jira] Assigned: (DERBY-1803) [DOC] Largest TIMESTAMP value in
Derby limitations section of reference manual is documented incorrectly
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1803?page=all ]
Laura Stewart reassigned DERBY-1803:
------------------------------------
Assignee: Laura Stewart
> [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
> Assigned To: Laura Stewart
>
> 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
[jira] Resolved: (DERBY-1803) [DOC] Largest TIMESTAMP value in
Derby limitations section of reference manual is documented incorrectly
Posted by "Jean T. Anderson (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1803?page=all ]
Jean T. Anderson resolved DERBY-1803.
-------------------------------------
Fix Version/s: 10.3.0.0
Resolution: Fixed
Derby Info: (was: [Patch Available])
Committed patch derby1803.diff to trunk, revision 442374 (not merged to 10.2 branch yet). Thanks, Laura!
> [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
> Assigned To: Laura Stewart
> Fix For: 10.3.0.0
>
> Attachments: derby1803.diff, derby1803_html.zip
>
>
> 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
[jira] Updated: (DERBY-1803) [DOC] Largest TIMESTAMP value in Derby
limitations section of reference manual is documented incorrectly
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1803?page=all ]
Laura Stewart updated DERBY-1803:
---------------------------------
Fix Version/s: 10.2.1.6
> [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
> Assigned To: Laura Stewart
> Fix For: 10.2.1.6, 10.3.0.0
>
> Attachments: derby1803.diff, derby1803_html.zip
>
>
> 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