db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-3080) With TERRITORY_BASED collation, when multiple characters map to a single collation element '_' matches a single collation element rather than a single character
Date Tue, 18 Sep 2007 16:12:43 GMT
With TERRITORY_BASED collation, when multiple characters map to a single collation element
'_'  matches a single collation element rather than a single character
-----------------------------------------------------------------------------------------------------------------------------------------------------------------

                 Key: DERBY-3080
                 URL: https://issues.apache.org/jira/browse/DERBY-3080
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.3.1.4, 10.4.0.0
            Reporter: Kathey Marsden


'_' matches a single collation element rather than a single character if multiple characters
have a single collation element.  Below is an example with norwegian aa  This occurs also
with the patch for DERBY-2967 which addresses the case of matching of a  single character
having more than one collation element.


ij> connect 'jdbc:derby:wombat;create=true;territory=no_NO;collation=TERRITORY_BASED';
ij> drop table t;
0 rows inserted/updated/deleted
ij> create table t (vc varchar(30));
0 rows inserted/updated/deleted
ij> insert into t values('middleaavalue');
1 row inserted/updated/deleted
-- The query below should match
ij> select * from t where vc like 'middle__value';
VC
------------------------------

0 rows selected
-- The query below should not match.
ij>  select * from t where vc like 'middle_value';
VC
------------------------------
middleaavalue


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