[
https://issues.apache.org/jira/browse/DERBY-4000?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12660795#action_12660795
]
Dag H. Wanvik commented on DERBY-4000:
--------------------------------------
Section 5.2 of SQL 2003 lists only '<>':
<not equals operator> ::= <>
so '!=' is non-standard SQL.
> 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.0.0
> Reporter: Knut Anders Hatlen
> Priority: Minor
>
> 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.
