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

SELECT statement topic in Reference Manual should reflect current WHERE clause behavior

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.4.2.0
    • Fix Version/s: 10.5.1.1
    • Component/s: Documentation
    • Labels:
      None

      Description

      Currently, according to DERBY-4045, SELECT statements do not allow WHERE clauses in subqueries if the SELECT statement is used for an updatable ResultSet. This behavior may need to change, but in the meantime the documentation should reflect the current situation. The SELECT statement topic in the Reference Manual is rrefsqlj41360.dita.

      1. DERBY-4049.diff
        0.6 kB
        Kim Haase
      2. rrefsqlj41360.html
        8 kB
        Kim Haase

        Issue Links

          Activity

          Hide
          chaase3 Kim Haase added a comment -

          Attaching DERBY-4049.diff and rrefsqlj41360.html. This patch adds a bullet item to the list of requirements for updatable cursors and updatable result sets.

          Show
          chaase3 Kim Haase added a comment - Attaching DERBY-4049 .diff and rrefsqlj41360.html. This patch adds a bullet item to the list of requirements for updatable cursors and updatable result sets.
          Hide
          knutanders Knut Anders Hatlen added a comment -

          Thanks for fixing this, Kim. +1 to commit.

          Show
          knutanders Knut Anders Hatlen added a comment - Thanks for fixing this, Kim. +1 to commit.
          Hide
          chaase3 Kim Haase added a comment -

          Thanks very much, Knut Anders.

          Committed patch DERBY-4049.diff to documentation trunk at revision 741149.

          Show
          chaase3 Kim Haase added a comment - Thanks very much, Knut Anders. Committed patch DERBY-4049 .diff to documentation trunk at revision 741149.
          Hide
          chaase3 Kim Haase added a comment -

          Change has appeared in Latest Alpha Manuals, so closing.

          Show
          chaase3 Kim Haase added a comment - Change has appeared in Latest Alpha Manuals, so closing.

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development