Documentation Bug

• Key: DERBY-9
• Type: Bug
• Status: Closed
• Resolution: Fixed
• Priority: Minor
• Assignee: Jean T. Anderson
• Reporter: Ali Demir
• Component/s: Documentation
• Affects Version/s: 10.0.2.0
• Fix Version/s: 10.0.2.1

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.

Comments

[Jean T. Anderson]

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

[Jean T. Anderson]

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]

Set fixin version.

[Jean T. Anderson]

ok, really set fix version and corrected affects version.

[Jean T. Anderson]

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