Derby
  1. Derby
  2. DERBY-1803

[DOC] Largest TIMESTAMP value in Derby limitations section of reference manual is documented incorrectly

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.1.3.1
    • Fix Version/s: 10.2.1.6, 10.3.1.4
    • Component/s: Documentation
    • Labels:
      None
    • Urgency:
      Normal

      Description

      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 -----------------
      ------------------------------------------------------

      1. derby1803_html.zip
        4 kB
        Laura Stewart
      2. derby1803.diff
        2 kB
        Laura Stewart

        Activity

        Susan Cline created issue -
        Hide
        Jean T. Anderson added a comment -

        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.

        Show
        Jean T. Anderson added a comment - 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.
        Laura Stewart made changes -
        Field Original Value New Value
        Assignee Laura Stewart [ scotsmatrix ]
        Hide
        Laura Stewart added a comment -

        Updated the date/time limitations and the DATE function file.
        Included are a diff file and an html.zip file.

        Show
        Laura Stewart added a comment - Updated the date/time limitations and the DATE function file. Included are a diff file and an html.zip file.
        Laura Stewart made changes -
        Attachment derby1803.diff [ 12340600 ]
        Attachment derby1803_html.zip [ 12340601 ]
        Laura Stewart made changes -
        Derby Info [Patch Available]
        Hide
        Jean T. Anderson added a comment -

        Committed patch derby1803.diff to trunk, revision 442374 (not merged to 10.2 branch yet). Thanks, Laura!

        Show
        Jean T. Anderson added a comment - Committed patch derby1803.diff to trunk, revision 442374 (not merged to 10.2 branch yet). Thanks, Laura!
        Jean T. Anderson made changes -
        Derby Info [Patch Available]
        Resolution Fixed [ 1 ]
        Fix Version/s 10.3.0.0 [ 12310800 ]
        Status Open [ 1 ] Resolved [ 5 ]
        Laura Stewart made changes -
        Fix Version/s 10.2.1.6 [ 11187 ]
        Laura Stewart made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Gavin made changes -
        Workflow jira [ 12382869 ] Default workflow, editable Closed status [ 12798127 ]

          People

          • Assignee:
            Laura Stewart
            Reporter:
            Susan Cline
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development