BUG #1695: "select distinct" makes different output

From: "philip" <philipguo(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1695: "select distinct" makes different output
Date: 2005-06-01 00:36:09
Message-ID: 20050601003609.BD392F0AC7@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1695
Logged by: philip
Email address: philipguo(at)yahoo(dot)com
PostgreSQL version: 8.0.3
Operating system: MS Windows XP sp1 and Linux Fedora core 3
Description: "select distinct" makes different output
Details:

Hi there,

I installed PostgreSQL 8.0.3 database system on both platforms MS Windows XP
(sp1) and Linux Fedora 3, and both databse settings are exactly the same
with the encoding set to 'UNICODE'. Both database systems are running well
except one thing so far has the different results from those two databases.
Here is a query as the example:

select distinct area from ht_booking.hotels;

The result from the database on Linux FC3 has no problem but the one on
Windows XP. The data output from the later have the duplicated rows. It
seems to make no difference with or without "distinct" key word. BUT, this
happens only under one condition: the data in that column contains chinese
characters.

Please feel free to question me if there is anything I can do to help with.
Thank you.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Fuhr 2005-06-01 13:45:40 Re: BUG #1692: Drop table in plpgsql
Previous Message Kevin J. Grittner 2005-05-31 21:47:21 BUG #1694: LIKE fails on column with domain after ANALYZE