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

Nested WHERE EXISTS queries need improved testing

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.2.2.0, 10.3.2.1
    • 10.3.3.0, 10.4.1.3
    • Test
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: