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

Nested WHERE EXISTS queries need improved testing

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.2.2.0, 10.3.2.1
    • Fix Version/s: 10.3.3.0, 10.4.1.3
    • Component/s: Test
    • Labels:
      None

      Description

      DERBY-3301 reported an error in subquery flattening of nested WHERE EXISTS clauses, or WHERE EXISTS subqueries. The query returned the wrong number of rows.

      There is currently some tests for WHERE EXISTS, but none for nested WHERE EXISTS clauses.
      See DERBY-3301 for a full sql repro.

        Attachments

        1. d3349-1.stat
          0.1 kB
          Thomas Nielsen
        2. d3349-1.diff
          5 kB
          Thomas Nielsen
        3. d3349-2.diff
          6 kB
          Thomas Nielsen
        4. d3349-3.diff
          8 kB
          Thomas Nielsen

          Issue Links

            Activity

              People

              • Assignee:
                thomanie Thomas Nielsen
                Reporter:
                thomanie Thomas Nielsen
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: