Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 25500 invoked from network); 31 May 2007 00:24:39 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 31 May 2007 00:24:39 -0000 Received: (qmail 7154 invoked by uid 500); 31 May 2007 00:24:42 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 7122 invoked by uid 500); 31 May 2007 00:24:42 -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 7113 invoked by uid 99); 31 May 2007 00:24:42 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 30 May 2007 17:24:42 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=UPPERCASE_25_50 X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: local policy includes SPF record at spf.trusted-forwarder.org) Received: from [68.142.229.96] (HELO smtp109.sbc.mail.re2.yahoo.com) (68.142.229.96) by apache.org (qpsmtpd/0.29) with SMTP; Wed, 30 May 2007 17:24:36 -0700 Received: (qmail 91037 invoked from network); 31 May 2007 00:24:09 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=sbcglobal.net; h=Received:X-YMail-OSG:Message-ID:Date:From:Reply-To:User-Agent:X-Accept-Language:MIME-Version:To:Subject:Content-Type:Content-Transfer-Encoding; b=a4t3qPTudnts2fMV70yuTVTcD1Gpt72L4z1tTVOeQk2BYOJFZR4/XcQoiI4eTNuhkzH7RkI/rbFGdxN6fO8oYkZN7L2pujAmFArdhew8EiIiTxzN/fhRlt5zJfMmkd4dmpCPZSkuSfYBt9/krSnsMDLeoeZUHR26hzWn9d2Ad7Y= ; Received: from unknown (HELO ?192.168.0.187?) (mikem_app@sbcglobal.net@71.131.215.135 with plain) by smtp109.sbc.mail.re2.yahoo.com with SMTP; 31 May 2007 00:24:09 -0000 X-YMail-OSG: VsQXDHQVM1mJUQmyq9ZFESw47a3u2YONmr27o.BlAIoOiRDI9ZP70qGr12iyky9Xo7sA2wLOIg-- Message-ID: <465E1595.6030800@sbcglobal.net> Date: Wed, 30 May 2007 17:23:49 -0700 From: Mike Matrigali Reply-To: mikem_app@sbcglobal.net User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Development Subject: more on system schema vs. user schema and character constants. Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org I am sort of confused at this point, what we expect to be working now and what should be. What is the right way to write the following query against a the system schema? Is there anyway to write the query without changing the default schema? : select COLUMNNAME from SYS.SYSCOLUMNS where SYS.SYSCOLUMNS.COLUMNNAME = 'fred'; I tried the following: ij> connect 'jdbc:derby:endb;create=true;territory=en;collation=TERRITORY_BASED' ; ij(CONNECTION1)> set schema APP; 0 rows inserted/updated/deleted ij(CONNECTION1)> select COLUMNNAME from SYS.SYSCOLUMNS where SYS.SYSCOLUMNS.COLU MNNAME = 'fred'; ERROR 42818: Comparisons between 'VARCHAR' and 'CHAR' are not supported. ij(CONNECTION1)> select COLUMNNAME from SYS.SYSCOLUMNS where COLUMNNAME = 'fred' ; ERROR 42818: Comparisons between 'VARCHAR' and 'CHAR' are not supported. ij(CONNECTION1)> select COLUMNNAME from SYS.SYSCOLUMNS where SYS.SYSCOLUMNS.COLU MNNAME = CAST('fred' as CHAR); ERROR 42818: Comparisons between 'VARCHAR' and 'CHAR' are not supported. ij(CONNECTION1)> select COLUMNNAME from SYS.SYSCOLUMNS where COLUMNNAME = CAST(' fred' as CHAR); ERROR 42818: Comparisons between 'VARCHAR' and 'CHAR' are not supported. ij(CONNECTION1)> set schema SYS; 0 rows inserted/updated/deleted ij(CONNECTION1)> select COLUMNNAME from SYS.SYSCOLUMNS where SYS.SYSCOLUMNS.COLU MNNAME = 'fred'; COLUMNNAME -------------------------------------------------------------------------------- ------------------------------------------------ 0 rows selected ij(CONNECTION1)> select COLUMNNAME from SYS.SYSCOLUMNS where COLUMNNAME = 'fred' ; COLUMNNAME -------------------------------------------------------------------------------- ------------------------------------------------ 0 rows selected ij(CONNECTION1)> select COLUMNNAME from SYS.SYSCOLUMNS where SYS.SYSCOLUMNS.COLU MNNAME = CAST('fred' as CHAR); COLUMNNAME -------------------------------------------------------------------------------- ------------------------------------------------ 0 rows selected ij(CONNECTION1)> select COLUMNNAME from SYS.SYSCOLUMNS where COLUMNNAME = CAST(' fred' as CHAR); COLUMNNAME -------------------------------------------------------------------------------- ------------------------------------------------ 0 rows selected