Derby
  1. Derby
  2. DERBY-4049

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

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major 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. rrefsqlj41360.html
        8 kB
        Kim Haase
      2. DERBY-4049.diff
        0.6 kB
        Kim Haase

        Issue Links

          Activity

          Hide
          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
          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
          Knut Anders Hatlen added a comment -

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

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

          Thanks very much, Knut Anders.

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

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

          Change has appeared in Latest Alpha Manuals, so closing.

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

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development