On 2007-07-06, at 21:34:52 Erwin Brandstetter wrote:
> Emil, are you sure you were connected to right database when running
> your tests?
> I have been having major problems with this bug in version pg 8.1.*, but
> I think it has been fixed in 8.2.
Yes - it was the right database.
> See the results of my tests:
Because your results were different I started to investigate problem on my
postgres.
Probably something was wrong main cluster. I made a backup of my databases,
then removed postgress server with purge. Then I installed it once again, and
recovered databases from backup. Now it works.
This server was few times upgraded from 7.x version. So I guess something went
wrong in pg_upgradecluster during one of previous upgrades.
I will close this bug right now.
Thanks for help.
> test=# select 'ı' ilike 'I';
> ?column?
> ----------
> f
I think a better test for this is:
testy=> select 'ı' ilike upper('ı');
?column?
----------
f
(1 row)
I don't know what is this i without a dot, but It seems for me like a bug.
Maybe this 'ı' letter exists only in lowercase version?
