Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 52936 invoked from network); 2 Aug 2007 15:06:31 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 2 Aug 2007 15:06:31 -0000 Received: (qmail 43320 invoked by uid 500); 2 Aug 2007 15:06:31 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 43106 invoked by uid 500); 2 Aug 2007 15:06:30 -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 43097 invoked by uid 99); 2 Aug 2007 15:06:30 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 Aug 2007 08:06:30 -0700 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.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; Thu, 02 Aug 2007 15:06:25 +0000 Received: from [127.0.0.1] (bp-laptop.edgility.com [10.10.11.199] (may be forged)) by red.amberpoint.com (8.14.0/8.12.11) with ESMTP id l72F5uiM017476 for ; Thu, 2 Aug 2007 08:05:57 -0700 (PDT) Message-ID: <46B1F2D4.7020107@amberpoint.com> Date: Thu, 02 Aug 2007 08:05:56 -0700 From: Bryan Pendleton User-Agent: Thunderbird 1.5.0.12 (Windows/20070509) MIME-Version: 1.0 To: derby-dev@db.apache.org Subject: Re: [jira] Commented: (DERBY-2962) Change functional tests to use casts for System table queries to avoid conversion errors when run with TERRITORY_BASED collation References: <21234629.1186063913409.JavaMail.jira@brutus> In-Reply-To: <21234629.1186063913409.JavaMail.jira@brutus> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org > ij> select SQL_TEXT from syscs_diag.statement_cache where CAST(SQL_TEXT AS LONG VARCHAR) LIKE '%932432%'; ... > Kathey, was it intentional to include an extra space in the above mentioned statement (between "TEXT" and "AS")? > I think if the second space is removed, the result will contain one row instead of two, and we won't see this diff any longer... Why does the extra space affect the number of rows in the result? Isn't that space just whitespace and discarded by the SQL parser? thanks, bryan