Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 10.0.2.0
    • Fix Version/s: 10.0.2.1
    • Component/s: Documentation
    • Labels:
      None
    • Environment:
      Windows 2K

      Description

      reference.pdf: page 178

      Tests whether the first operand is between the second and third operands. The second operand must be less than the third operand. Applicable only to types to which <= and >= can be applied. WHERE booking_date BETWEEN DATE'1998-02-26' AND DATE'1998-03-01'

      Syntax does not work. DATE'1998-02-26' i think is wrong.

      WHERE booking_date BETWEEN '1998-02-26' AND '1998-03-01'

      seems to work.

        Activity

        Ali Demir created issue -
        Jean T. Anderson made changes -
        Field Original Value New Value
        Assignee Jean T. Anderson [ jta ]
        Hide
        Jean T. Anderson added a comment -

        The date expressions are missing parentheses. Instead of DATE'1998-02-06', it should be DATE('1998-02-06'). Files with errors are:

        src/documentation/content/xdocs/manuals/reference/sqlj148.ihtml,sqlj232.ihtml,sqlj43.ihtml

        Show
        Jean T. Anderson added a comment - The date expressions are missing parentheses. Instead of DATE'1998-02-06', it should be DATE('1998-02-06'). Files with errors are: src/documentation/content/xdocs/manuals/reference/sqlj148.ihtml,sqlj232.ihtml,sqlj43.ihtml
        Hide
        Jean T. Anderson added a comment -

        Fixed in svn revision 56996:
        incubator/derby/site/trunk/build/site/manuals/reference/sqlj148.html
        incubator/derby/site/trunk/build/site/manuals/reference/sqlj232.html incubator/derby/site/trunk/build/site/manuals/reference/sqlj43.html
        incubator/derby/site/trunk/src/documentation/content/xdocs/manuals/reference/sqlj148.ihtml incubator/derby/site/trunk/src/documentation/content/xdocs/manuals/reference/sqlj232.ihtml incubator/derby/site/trunk/src/documentation/content/xdocs/manuals/reference/sqlj43.ihtml

        Show
        Jean T. Anderson added a comment - Fixed in svn revision 56996: incubator/derby/site/trunk/build/site/manuals/reference/sqlj148.html incubator/derby/site/trunk/build/site/manuals/reference/sqlj232.html incubator/derby/site/trunk/build/site/manuals/reference/sqlj43.html incubator/derby/site/trunk/src/documentation/content/xdocs/manuals/reference/sqlj148.ihtml incubator/derby/site/trunk/src/documentation/content/xdocs/manuals/reference/sqlj232.ihtml incubator/derby/site/trunk/src/documentation/content/xdocs/manuals/reference/sqlj43.ihtml
        Jean T. Anderson made changes -
        Resolution Fixed [ 1 ]
        Status Open [ 1 ] Resolved [ 5 ]
        Hide
        Jean T. Anderson added a comment -

        Set fixin version.

        Show
        Jean T. Anderson added a comment - Set fixin version.
        Jean T. Anderson made changes -
        Affects Version/s 10.0.2.0 [ 10920 ]
        Affects Version/s 10.0.2.1 [ 10991 ]
        Description reference.pdf: page 178

        Tests whether the first operand is between the second and third operands. The second operand must be less than the third operand. Applicable only to types to which <= and >= can be applied. WHERE booking_date BETWEEN DATE'1998-02-26' AND DATE'1998-03-01'

        Syntax does not work. DATE'1998-02-26' i think is wrong.

        WHERE booking_date BETWEEN '1998-02-26' AND '1998-03-01'

        seems to work.

        reference.pdf: page 178

        Tests whether the first operand is between the second and third operands. The second operand must be less than the third operand. Applicable only to types to which <= and >= can be applied. WHERE booking_date BETWEEN DATE'1998-02-26' AND DATE'1998-03-01'

        Syntax does not work. DATE'1998-02-26' i think is wrong.

        WHERE booking_date BETWEEN '1998-02-26' AND '1998-03-01'

        seems to work.

        Hide
        Jean T. Anderson added a comment -

        ok, really set fix version and corrected affects version.

        Show
        Jean T. Anderson added a comment - ok, really set fix version and corrected affects version.
        Jean T. Anderson made changes -
        Affects Version/s 10.0.2.0 [ 10920 ]
        Affects Version/s 10.0.2.1 [ 10991 ]
        Fix Version/s 10.0.2.1 [ 10991 ]
        Hide
        Jean T. Anderson added a comment -

        Issue does not affect DITA docs, was fixed before the new files were contributed.

        Show
        Jean T. Anderson added a comment - Issue does not affect DITA docs, was fixed before the new files were contributed.
        Jean T. Anderson made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Gavin made changes -
        Workflow jira [ 37496 ] Default workflow, editable Closed status [ 12800337 ]

          People

          • Assignee:
            Jean T. Anderson
            Reporter:
            Ali Demir
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development