db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen" <Bernt.John...@Sun.COM>
Subject Re: [jira] Updated: (DERBY-1262) Like-predicates: % does not match tab character
Date Thu, 01 Jun 2006 11:14:57 GMT
Håvard,

I think it would be useful if you filed an ICLA (See
http://wiki.apache.org/db-derby/DerbyContributorChecklist) if you
haven't already. It will be required the day you file a large patch (I
don't know the exact definition of "large" in this context), but the
Apache "bureaucratic mill" may be somewhat slow with the registering
of ICLAs.

>>>>>>>>>>>> Håvard Mork (JIRA) wrote (2006-06-01 10:55:30):
>      [ http://issues.apache.org/jira/browse/DERBY-1262?page=all ]
> 
> Håvard Mork updated DERBY-1262:
> -------------------------------
> 
>     Attachment: 1262_4.diff
> 
> Attached new patch with corrections (thanks, Bernt)
> - using the more efficient stringbuffer.setLength for null-char padding
> - esc (0x1b) as control char in test case, to avoid potential future tab->space conversion.
> 
> 
> > Like-predicates: % does not match tab character
> > -----------------------------------------------
> >
> >          Key: DERBY-1262
> >          URL: http://issues.apache.org/jira/browse/DERBY-1262
> >      Project: Derby
> >         Type: Bug
> 
> >   Components: SQL
> >     Versions: 10.0.2.0
> >  Environment: Embedded, Solaris 10 x86
> >     Reporter: Øystein Grøvlen
> >  Attachments: 1262.diff, 1262_3.diff, 1262_4.diff
> >
> > % in like predicates does not seem to match tab character.  In the following 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	def');
> > 1 row inserted/updated/deleted
> > ij> select * from t4 where c like 'abc%';
> > I          |J          |C         
> > ----------------------------------
> > 0 rows selected
> > ij> select * from t4 where c like 'abc	%';
> > I          |J          |C         
> > ----------------------------------
> > 1          |1          |abc    def   
> > 1 row selected
> 
> -- 
> This message is automatically generated by JIRA.
> -
> If you think it was sent incorrectly contact one of the administrators:
>    http://issues.apache.org/jira/secure/Administrators.jspa
> -
> For more information on JIRA, see:
>    http://www.atlassian.com/software/jira
> 

-- 
Bernt Marius Johnsen, Database Technology Group, 
Staff Engineer, Technical Lead Derby/Java DB
Sun Microsystems, Trondheim, Norway

Mime
View raw message