db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-2526) Wrong query results due to column ordering in UNION view
Date Wed, 04 Apr 2007 23:23:32 GMT
Wrong query results due to column ordering in UNION view

                 Key: DERBY-2526
                 URL: https://issues.apache.org/jira/browse/DERBY-2526
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions:,,,
            Reporter: Bryan Pendleton

I think both select statements in the attached repro script should return 1 row, but in fact
the first statement returns 1 row and the second returns zero rows.

The only difference between the two statements is that the columns in the UNION view are listed
in a different order (bvw vs. bvw2).

This seems like a bug to me; the order of the columns in the view definition shouldn't matter,
should it? 

As Army noted on the derby-dev list, the fact that this reproduces with 10.0 means that it
is not caused by some of the 10.2 optimizer changes. Something else is going wrong.

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

View raw message