From derby-dev-return-39144-apmail-db-derby-dev-archive=db.apache.org@db.apache.org Wed Mar 21 11:55:56 2007 Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 22436 invoked from network); 21 Mar 2007 11:55:55 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 21 Mar 2007 11:55:55 -0000 Received: (qmail 71986 invoked by uid 500); 21 Mar 2007 11:56:02 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 71947 invoked by uid 500); 21 Mar 2007 11:56:02 -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 71917 invoked by uid 99); 21 Mar 2007 11:56:02 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 21 Mar 2007 04:56:02 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 21 Mar 2007 04:55:53 -0700 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 69885714046 for ; Wed, 21 Mar 2007 04:55:33 -0700 (PDT) Message-ID: <30149397.1174478133428.JavaMail.jira@brutus> Date: Wed, 21 Mar 2007 04:55:33 -0700 (PDT) From: =?utf-8?Q?=C3=98ystein_Gr=C3=B8vlen_=28JIRA=29?= To: derby-dev@db.apache.org Subject: [jira] Closed: (DERBY-1262) Like-predicates: % does not match tab character In-Reply-To: <24341387.1146137017647.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-1262?page=3Dcom.atlassia= n.jira.plugin.system.issuetabpanels:all-tabpanel ] =C3=98ystein Gr=C3=B8vlen closed DERBY-1262. ---------------------------------- > Like-predicates: % does not match tab character > ----------------------------------------------- > > Key: DERBY-1262 > URL: https://issues.apache.org/jira/browse/DERBY-1262 > Project: Derby > Issue Type: Bug > Components: SQL > Affects Versions: 10.0.2.0 > Environment: Embedded, Solaris 10 x86 > Reporter: =C3=98ystein Gr=C3=B8vlen > Fix For: 10.1.3.1, 10.2.1.6 > > Attachments: 1262.diff, 1262_3.diff, 1262_4.diff, 1262_5.diff, 12= 62_6.diff > > > % in like predicates does not seem to match tab character. In the follow= ing example all whitespace in character literals is the tab character: > ij> create table t4(i integer primary key, j integer, c varchar(10)); > 0 rows inserted/updated/deleted > ij> insert into t4 values (1, 1, 'abc=09def'); > 1 row inserted/updated/deleted > ij> select * from t4 where c like 'abc%'; > I |J |C =20 > ---------------------------------- > 0 rows selected > ij> select * from t4 where c like 'abc=09%'; > I |J |C =20 > ---------------------------------- > 1 |1 |abc def =20 > 1 row selected --=20 This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.