Details
-
Improvement
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
10.5.1.1
-
None
Description
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
where x != 2;
X
-----------
1
3
2 rows selected
ij> select * from (values 1,2,3)v where x <> 2;
X
-----------
1
3
2 rows selected