Derby
  1. Derby
  2. DERBY-5628

Wrong syntax description in DELETE statement doc

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.9.1.0
    • Component/s: Documentation
    • Labels:
      None

      Description

      In the description of the DELETE statement in the reference manual, the syntax description gives this:
      :

      { DELETE FROM table-Name [[AS] correlation-Name] [WHERE clause] | DELETE FROM table-Name WHERE CURRENT OF }

      The last line is wrong. It should read

      DELETE FROM table-Name WHERE CURRENT OF clause. It is already a link to the clause.

      1. rrefsqlj35981.html
        4 kB
        Kim Haase
      2. DERBY-5628.diff
        1.0 kB
        Kim Haase

        Activity

        Hide
        Kim Haase added a comment -

        Changes have appeared in Latest Alpha Manuals.

        Show
        Kim Haase added a comment - Changes have appeared in Latest Alpha Manuals.
        Hide
        Kim Haase added a comment -

        Thank you, Dag!

        Committed patch DERBY-5628.diff to documentation trunk at revision 1336804.

        Show
        Kim Haase added a comment - Thank you, Dag! Committed patch DERBY-5628 .diff to documentation trunk at revision 1336804.
        Hide
        Dag H. Wanvik added a comment -

        Looks good to me. +1

        Show
        Dag H. Wanvik added a comment - Looks good to me. +1
        Hide
        Kim Haase added a comment -

        Attaching DERBY-5628.diff and rrefsqlj35981.html, with modifications to some links in the DELETE statement topic:

        M src/ref/rrefsqlj35981.dita

        Thanks in advance for any comments.

        Show
        Kim Haase added a comment - Attaching DERBY-5628 .diff and rrefsqlj35981.html, with modifications to some links in the DELETE statement topic: M src/ref/rrefsqlj35981.dita Thanks in advance for any comments.
        Hide
        Kim Haase added a comment -

        Oh, good point. Poking around I see that we do usually just put "clause" and not the syntax. Dag is right, we can just say "WHERE CURRENT OF clause".

        And yes, I should add links to the syntax of table-Name and correlation-Name. Thanks, Knut.

        Show
        Kim Haase added a comment - Oh, good point. Poking around I see that we do usually just put "clause" and not the syntax. Dag is right, we can just say "WHERE CURRENT OF clause". And yes, I should add links to the syntax of table-Name and correlation-Name. Thanks, Knut.
        Hide
        Knut Anders Hatlen added a comment -

        And should table-Name and correlation-Name be turned into links to their respective topics?

        Show
        Knut Anders Hatlen added a comment - And should table-Name and correlation-Name be turned into links to their respective topics?
        Hide
        Knut Anders Hatlen added a comment -

        Should [WHERE clause] be changed to [WHERE Boolean expression] too (and point to the WHERE clause topic)?

        Show
        Knut Anders Hatlen added a comment - Should [WHERE clause] be changed to [WHERE Boolean expression] too (and point to the WHERE clause topic)?
        Hide
        Kim Haase added a comment -

        Thanks, Dag, I'll fix that. Actually, I guess it should say "WHERE CURRENT OF cursor-name" because that's the correct syntax, but should point to the clause topic (which then links to the cursor-name syntax topic).

        Show
        Kim Haase added a comment - Thanks, Dag, I'll fix that. Actually, I guess it should say "WHERE CURRENT OF cursor-name" because that's the correct syntax, but should point to the clause topic (which then links to the cursor-name syntax topic).

          People

          • Assignee:
            Kim Haase
            Reporter:
            Dag H. Wanvik
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development