Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <18020774.1159893501209.JavaMail.root@brutus>
Date: Tue, 3 Oct 2006 09:38:21 -0700 (PDT)
From: "Laura Stewart (JIRA)" <derby-dev@db.apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Updated: (DERBY-1803) [DOC] Largest TIMESTAMP value in Derby
 limitations section of reference manual is documented incorrectly
In-Reply-To: <22495794.1157132722818.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

     [ 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