db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Satheesh Bandaram (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1262) Like-predicates: % does not match tab character
Date Thu, 04 May 2006 19:41:19 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1262?page=comments#action_12377878 ] 

Satheesh Bandaram commented on DERBY-1262:
------------------------------------------

Good find. By avoiding Like optimization, the results appear to be right. Like optimizations
can be disabled by having an expression on the left, as below. But it has unwanted side effect
to prevent using of any indexes, if present.

Possible work around could be:

ij> select * from t4 where c like 'abc%';
I          |J          |C
----------------------------------

0 rows selected
ij> select * from t4 where cast(c as varchar(20)) like 'abc%';
I          |J          |C
----------------------------------
1          |1          |abc     def

1 row selected

Fixing the code issue will involve correctly generating a lessThan/greaterThan value, I think.


> 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

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