Rolf Jentsch <RJentsch(at)electronicpartner(dot)de> writes:
> With PostgreSQL 8.3.0 the following bug has been introduced with the ILIKE or
> ~~* operator:
> In a database with single-byte encoding as LATIN1 the expression
> SELECT 'a' ILIKE '%';
> returns false.
> For the single-byte case there are some places where a (signed) char
> value is compared to the return value auf tolower() which is an int.
Patch applied, thanks! It turns out there was a second bug on the very
same line: some machines have problems if the argument of tolower()
isn't explicitly cast to unsigned char ...
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Manos Tsagias||Date: 2008-03-01 11:39:11|
|Subject: BUG #4004: out of memory|
|Previous:||From: Steve Clark||Date: 2008-02-29 21:29:36|
|Subject: ecpg produces code that won't compile|