Re: BUG #5290: Simple loop with insert into and check to avoid duplicate values fails

On Jan 21, 6:17 pm, mi(dot)(dot)(dot)(at)radev(dot)net ("Milen A. Radev") wrote:
> [...]
>
> For the test I changed all regional settings to "Polish (Poland)",
> restarted the machine, created a new cluster and a new database (using
> the commands from the last mail from Heikki).
>
> A side-note: tested exactly the same function but on "Bulgarian
> (Bulgaria)" system locale and cluster and database created with
> "Bulgarian_Bulgaria.1251" locale - no errors.
>
> --
> Milen A. Radev

Strange (?), but when I substituted equality to like in this line:

select id into wordId from spb_word where word like w; --
was: ... word = w;

there is no error with polish locale.

(WW)