Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 14763 invoked from network); 23 Feb 2008 18:17:25 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 23 Feb 2008 18:17:25 -0000 Received: (qmail 27068 invoked by uid 500); 23 Feb 2008 18:17:20 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 27031 invoked by uid 500); 23 Feb 2008 18:17:20 -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 27022 invoked by uid 99); 23 Feb 2008 18:17:19 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 23 Feb 2008 10:17:19 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.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; Sat, 23 Feb 2008 18:16:34 +0000 Received: from [127.0.0.1] (bp-laptop.edgility.com [10.10.12.213]) by red.amberpoint.com (8.14.0/8.12.11) with ESMTP id m1NIGppS026111 for ; Sat, 23 Feb 2008 10:16:52 -0800 (PST) Message-ID: <47C06313.2000808@amberpoint.com> Date: Sat, 23 Feb 2008 10:16:51 -0800 From: Bryan Pendleton User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: derby-dev@db.apache.org Subject: Re: dblook fails on TERRITORY_BASED databases References: <47C055A6.3010303@republika.nl> In-Reply-To: <47C055A6.3010303@republika.nl> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org > I've created small patches for myself by replacing all related queries > in the 'tools' section with CASTs to CHARs and VARCHARs and would like > to contribute these to the community in case anyone else can confirm > this is a bug. I see the same problem with your script in my environment; this certainly seems like a bug to me. I think it would be much appreciated if you could contribute the test case and your fixes. thanks, bryan