Bug #615: Bug in ilke and ~~* Sql expression

Torsten Krmer (tk(at)kreakom(dot)de) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
Bug in ilke and ~~* Sql expression

Long Description
i tried to do a select on some columns case insensitive.
some charachters like .. the ilike,~~*,upper made mistakes

Sample Code
select upper('GaStstttEn');
upper
-------------
GASTSTTTEN
(1 row)

select upper('GaStstttEn');
upper
-------------
GASTSTTTEN
(1 row)

select data_content from feature where data_content ~~* 'GaStstttEn';
=>
data_content
--------------
Gaststtten
(1 row)

select data_content from feature where data_content ~~* 'GaStstttEn';
=>
data_content
--------------
(0 rows)

select data_content from feature where upper(data_content)=upper('GaStstttEn');
=>
data_content
--------------
Gaststtten
(1 row)

select data_content from feature where upper(data_content)=upper('GaStstttEn');
=>
data_content
--------------
(0 rows)

No file was uploaded with this report