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