[
https://issues.apache.org/jira/browse/DERBY-5973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13493247#comment-13493247
]
Kim Haase commented on DERBY-5973:
----------------------------------
Thanks for the pointer to the Cloudscape docs, Knut. This material will be
helpful if this operator is implemented and needs to be documented.
> Add syntax for boolean IS operator
> ----------------------------------
>
> Key: DERBY-5973
> URL: https://issues.apache.org/jira/browse/DERBY-5973
> Project: Derby
> Issue Type: Improvement
> Components: SQL
> Reporter: Knut Anders Hatlen
> Priority: Minor
>
> 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.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
