[
https://issues.apache.org/jira/browse/DERBY-4000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kim Haase updated DERBY-4000:
-----------------------------
Attachment: rrefsqlj23075.html
DERBY-4000.diff
This is low-hanging fruit -- I'm attaching DERBY-4000.diff and
rrefsqlj23075.html (Boolean expressions), with a note added to the table row on
comparison operators. We don't have much precedent for talking about
nonstandard items, so I hope this language is acceptable.
I also added a missing space after a comma in the note on LIKE expressions.
> Reference manual leaves != out of list of boolean operators
> -----------------------------------------------------------
>
> Key: DERBY-4000
> URL: https://issues.apache.org/jira/browse/DERBY-4000
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.5.1.1
> Reporter: Knut Anders Hatlen
> Priority: Minor
> Attachments: DERBY-4000.diff, rrefsqlj23075.html
>
>
> Table 1, SQL Boolean Operators, at
> <URL:http://db.apache.org/derby/docs/dev/ref/rrefsqlj23075.html> lists the
> comparison operators <, =, >, <=, >=, <>. Derby also accepts !=, which I
> believe has the same meaning as <>. The != operator should be documented
> along with the other operators. (I haven't checked whether != is standard
> SQL.)
> ij> select * from (values 1,2,3)v(x) where x != 2;
> X
> -----------
> 1
> 3
> 2 rows selected
> ij> select * from (values 1,2,3)v(x) where x <> 2;
> X
> -----------
> 1
> 3
> 2 rows selected
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
