[DERBY-5973] Add syntax for boolean IS operator

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: SQL
• Labels: derby_triage10_11
• Urgency: Normal
• Assignee: Unassigned
• Reporter: Knut Anders Hatlen
• Created: 31/Oct/12 12:45
• Updated: 25/Jun/13 04:45

Description

The BooleanDataValue interface and the SQLBoolean class implement the boolean IS operator in their is() and isNot() methods. There is also an (unused) IsNode class for the AST. However, the operator is not exposed in the grammar, so there's no way to use it.

The boolean IS operator is defined in the SQL:2003 standard, part 2, section 6.34 <boolean value expression>.

<boolean test> ::= <boolean primary> [ IS [ NOT ] <truth value> ]

There's also Table 13 — Truth table for the IS boolean operator.

Issue Links

• is related to: DERBY-5971 Improve test coverage for SQLBoolean class