[DERBY-2670] %a% and %aa% match too many rows in database with collation=TERRITORY_BASED and territory=no_NO

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.3.1.4
• Fix Version/s: 10.3.1.4
• Component/s: SQL
• Assignee: Mike Matrigali
• Reporter: Knut Anders Hatlen
• Created: 18/May/07 12:28
• Updated: 27/May/07 19:10
• Resolved: 25/May/07 23:49

Description

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

Issue Links

• relates to: DERBY-2698 caching collation elements in WorkHorseForCollatorDatatypes may improve performance.