| 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: | Whole Thread | Raw Message | 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? |