Torsten Krämer (tk@kreakom.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('GaStstÄttEn');
upper
-------------
GASTSTÄTTEN
(1 row)
select upper('GaStstättEn');
upper
-------------
GASTSTäTTEN
(1 row)
select data_content from feature where data_content ~~* 'GaStstättEn';
=>
data_content
--------------
Gaststätten
(1 row)
select data_content from feature where data_content ~~* 'GaStstÄttEn';
=>
data_content
--------------
(0 rows)
select data_content from feature where upper(data_content)=upper('GaStstättEn');
=>
data_content
--------------
Gaststätten
(1 row)
select data_content from feature where upper(data_content)=upper('GaStstÄttEn');
=>
data_content
--------------
(0 rows)
No file was uploaded with this report