You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Mike Matrigali (JIRA)" <ji...@apache.org> on 2007/05/27 20:10:16 UTC
[jira] Updated: (DERBY-2706) fix like clauses with trailing %
[ https://issues.apache.org/jira/browse/DERBY-2706?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mike Matrigali updated DERBY-2706:
----------------------------------
Description:
Results in collated databases from like clauses with trailing % seem to be matching upper and lower of specified character.
For instance:
ij(CONNECTION1)> connect 'jdbc:derby:nodb;create=true;territory=no_NO;collation=
TERRITORY_BASED';
WARNING 01J01: Database 'nodb' not created, connection made to existing database
instead.
ij(CONNECTION2)> drop table t;
0 rows inserted/updated/deleted
ij(CONNECTION2)> create table t (x varchar(20));
0 rows inserted/updated/deleted
ij(CONNECTION2)> insert into t values 'Waagan', 'Wσhan', 'Wanvik', 'Wσgan', 'eks
trabetaling', 'ekstraarbeid', 'ekstra¡arbeid', '¡a', 'a', '¡b', 'b', '-a', '-b',
' a', ' b', 'A', 'B', 'C';
ij(CONNECTION2)> select * from t where x like 'a%';
X
--------------------
¡a
a
-a
a
A
5 rows selected
ij(CONNECTION2)> select * from t where x like 'b%';
X
--------------------
¡b
b
-b
b
B
5 rows selected
ij(CONNECTION2)> select * from t where x like 'c%';
X
--------------------
C
Affects Version/s: 10.3.0.0
> fix like clauses with trailing %
> ---------------------------------
>
> Key: DERBY-2706
> URL: https://issues.apache.org/jira/browse/DERBY-2706
> Project: Derby
> Issue Type: Sub-task
> Affects Versions: 10.3.0.0
> Reporter: Mike Matrigali
>
> Results in collated databases from like clauses with trailing % seem to be matching upper and lower of specified character.
> For instance:
> ij(CONNECTION1)> connect 'jdbc:derby:nodb;create=true;territory=no_NO;collation=
> TERRITORY_BASED';
> WARNING 01J01: Database 'nodb' not created, connection made to existing database
> instead.
> ij(CONNECTION2)> drop table t;
> 0 rows inserted/updated/deleted
> ij(CONNECTION2)> create table t (x varchar(20));
> 0 rows inserted/updated/deleted
> ij(CONNECTION2)> insert into t values 'Waagan', 'Wσhan', 'Wanvik', 'Wσgan', 'eks
> trabetaling', 'ekstraarbeid', 'ekstra¡arbeid', '¡a', 'a', '¡b', 'b', '-a', '-b',
> ' a', ' b', 'A', 'B', 'C';
> ij(CONNECTION2)> select * from t where x like 'a%';
> X
> --------------------
> ¡a
> a
> -a
> a
> A
> 5 rows selected
> ij(CONNECTION2)> select * from t where x like 'b%';
> X
> --------------------
> ¡b
> b
> -b
> b
> B
> 5 rows selected
> ij(CONNECTION2)> select * from t where x like 'c%';
> X
> --------------------
> C
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.