db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Øystein Grøvlen (JIRA) <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1262) Like-predicates: % does not match tab character
Date Wed, 24 May 2006 10:15:30 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1262?page=comments#action_12413100 ] 

Øystein Grøvlen commented on DERBY-1262:
----------------------------------------

Patch looks good, but I am not expert on this code.  I would very much like this to be fixed
in 10.1.3 so it would be nice if someone with more experience with this code could look at
it.  

One minor comment:
- Why are the old versions of greaterEqualStringFromParameter() and greaterEqualStringFromParameterWithEsc()
kept?  Do you need them anymore? Seems like they are only called from one location.

> 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
>
> % 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


Mime
View raw message