db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "A B (JIRA)" <j...@apache.org>
Subject [jira] Resolved: (DERBY-2370) EXISTS may return the wrong value for sub-queries involving set operations
Date Tue, 22 May 2007 21:25:17 GMT

     [ https://issues.apache.org/jira/browse/DERBY-2370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

A B resolved DERBY-2370.

    Resolution: Fixed
    Derby Info: [Existing Application Impact, Release Note Needed]  (was: [Existing Application

Marking issue resolved (again).  I'll wait a few days before closing it in case there are
comments on the release note...

> EXISTS may return the wrong value for sub-queries involving set operations
> --------------------------------------------------------------------------
>                 Key: DERBY-2370
>                 URL: https://issues.apache.org/jira/browse/DERBY-2370
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions:
>            Reporter: Dyre Tjeldvoll
>         Assigned To: A B
>             Fix For:
>         Attachments: d2370_engine_v1.patch, d2370_tests_v1.patch, d2370_v1.stat, d2370_writeup_v1.html,
releaseNote.html, repro.sql
> It seems like EXISTS on a SELECT returning zero rows returns false (as
> expected), but EXISTS on INTERSECT of two disjunct sets returns true,
> e.g EXISTS (values 1 intersect values 2).
> Yip Ng wrote on derby-dev:
> I believe its probably got to do with the EXISTS subquery transforming
> the original RCL to
> a TRUE boolean value for the INTERSECT.  So during row comparison at
> execution time
> for INTERSECT processing since true == true(thus intersects), so it
> will always return 'BAD'.  Likewise,
> select * from ( values 'OK' ) as T where exists (values 1 except values 2);
> This supposedly should return 'OK' but because of the boolean
> transformation mentioned
> above for EXISTS subquery, it will return no rows for EXCEPT
> processing.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message