Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 30277 invoked from network); 4 Apr 2007 23:09:52 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 4 Apr 2007 23:09:52 -0000 Received: (qmail 15732 invoked by uid 500); 4 Apr 2007 23:09:59 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 15697 invoked by uid 500); 4 Apr 2007 23:09:59 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 15688 invoked by uid 99); 4 Apr 2007 23:09:59 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Apr 2007 16:09:59 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (herse.apache.org: local policy) Received: from [63.82.107.6] (HELO red.amberpoint.com) (63.82.107.6) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Apr 2007 16:09:51 -0700 Received: from [127.0.0.1] (bpendleton-dsk2.edgility.com [10.10.11.13]) by red.amberpoint.com (8.14.0/8.12.11) with ESMTP id l34N9UDK000828 for ; Wed, 4 Apr 2007 16:09:30 -0700 (PDT) Message-ID: <4614302A.6050205@amberpoint.com> Date: Wed, 04 Apr 2007 16:09:30 -0700 From: Bryan Pendleton User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: derby-dev@db.apache.org Subject: Re: Possible wrong results bug involving column order in UNION view References: <46142374.1060401@amberpoint.com> <46142EE7.3080503@gmail.com> In-Reply-To: <46142EE7.3080503@gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org > Is this something you might be looking at more? Either way, can you > file a Jira for tracking? Thanks Army! I'll file it in Jira. I just wanted to make sure I wasn't missing something simple. I'm interested in looking at it more, but I don't have any theories yet, so I guess I'll have to start by developing a plan of attack. The first thing that occurs to me is to verify that we get the same query plan with each view. Does that seem like a good approach? Thanks for the quick response. bryan