[BUGS] BUG #1695: "select distinct" makes different output

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[BUGS] BUG #1695: "select distinct" makes different output

Philip-36

The following bug has been logged online:

Bug reference:      1695
Logged by:          philip
Email address:      [hidden email]
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.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [hidden email] so that your
      message can get through to the mailing list cleanly
Reply | Threaded
Open this post in threaded view
|

Re: [BUGS] BUG #1695: "select distinct" makes different output

Magnus Hagander
> The following bug has been logged online:
>
> Bug reference:      1695
> Logged by:          philip
> Email address:      [hidden email]
> 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.

Whare are your database encoding and locale in the two different
installations?

//Magnus

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
Reply | Threaded
Open this post in threaded view
|

Re: [BUGS] BUG #1695: "select distinct" makes different output

Tom Lane-2
In reply to this post by Philip-36
"philip" <[hidden email]> writes:
> 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'.

Windows' support for UNICODE is kind of broken I'm afraid :-(.  You
should use a different encoding on that platform, at least until we
figure out an end-run around the OS' limitations.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [hidden email] so that your
      message can get through to the mailing list cleanly