Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-4000

Reference manual leaves != out of list of boolean operators

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 10.5.1.1
    • Fix Version/s: 10.6.1.0
    • Component/s: Documentation
    • Labels:
      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

        Attachments

        1. DERBY-4000.diff
          1 kB
          Kim Haase
        2. rrefsqlj23075.html
          12 kB
          Kim Haase

          Activity

            People

            • Assignee:
              chaase3 Kim Haase
              Reporter:
              knutanders Knut Anders Hatlen
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: