possible bug in case comparison on index scan.

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Cc: <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: possible bug in case comparison on index scan.
Date: 2005-01-03 20:32:28
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB3412A758C@Herge.rcsinc.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-hackers-win32

I've uncovered a possible bug on that may be related to the other locale
relation issues for win32 being discussed right now. Basically, I have
a situation where a query is pulling up the wrong record based on string
case. So far, I have not been able to reproduce this in linux.

Here is the situation:
Database is initialized to the default locale which is "English_United
States.1252" (as reported by pg_controldata.exe). Databases initialized
to the 'C' locale don't have this problem. If this is just a locale
issue, I'm not concerned (just use the C locale), but just want to make
sure a btree related issue is not slipping through.

Observe:

esp=# select version();
version
------------------------------------------------------------------------
---------------------
PostgreSQL 8.0.0rc2 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
3.4.1 (mingw special)
(1 row)

esp=# prepare data9_start_nl_item_base_file_5 (character varying,
character varying, int4)
esp-# as select 1::int4, ib_sales_description_1 from
data9.item_base_file
esp-# where ib_sales_description_1 >= $1 and
esp-# (ib_sales_description_1 > $1 or ib_sales_description_2
>= $2)
esp-# order by ib_sales_description_1, ib_sales_description_2, id
esp-# limit $3;
PREPARE
esp=# execute data9_start_nl_item_base_file_5('SAT', '', 1 );
int4 | ib_sales_description_1
------+------------------------
1 | satellite
(1 row)

esp=# select 'sat' >= 'SAT';
?column?
----------
f
(1 row)

esp=# execute data9_start_nl_item_base_file_5('SAT', '', 2 );
int4 | ib_sales_description_1
------+-------------------------------
1 | satellite
1 | SATELLITE (current) AUTO DUAL
(2 rows)

Merlin

Browse pgsql-hackers by date

  From Date Subject
Next Message Martijn van Oosterhout 2005-01-03 21:05:47 Re: Can't find relation oid
Previous Message Tom Lane 2005-01-03 20:29:36 Re: [HACKERS] Bgwriter behavior

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Bruce Momjian 2005-01-04 00:17:58 Re: More SSL questions..
Previous Message Jonathan Barnhart 2005-01-03 12:16:39 Any chance of a merge module?