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] Created: (DERBY-1262) Like-predicates: % does not match tab character
Date Thu, 27 Apr 2006 11:23:37 GMT
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  
 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:
For more information on JIRA, see:

View raw message