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
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 |
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? |