db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-2670) %a% and %aa% match too many rows in database with collation=TERRITORY_BASED and territory=no_NO
Date Fri, 18 May 2007 12:29:16 GMT
%a% and %aa% match too many rows in database with collation=TERRITORY_BASED and territory=no_NO
-----------------------------------------------------------------------------------------------

                 Key: DERBY-2670
                 URL: https://issues.apache.org/jira/browse/DERBY-2670
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.3.0.0
            Reporter: Knut Anders Hatlen


On a database with territory=no_NO and collation=TERRITORY_BASED, I get these results from
a query which uses the LIKE predicate:

ij> select * from t where x like '%a%';
X                   
--------------------
Waagan              
Wåhan               
Wanvik              
Wågan               
ekstrabetaling      
ekstra­arbeid       
­a                  
a                   
-a                  
 a                  
B                   
C                   

12 rows selected

The last two rows ('B' and 'C') should not have been included in the result, since they do
not match the pattern '%a%'.

Similar wrong results are seen with '%aa%':

ij> select * from t where x like '%aa%';
X                   
--------------------
Waagan              
ekstraarbeid        
B                   

3 rows selected

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message