BUG #1695: "select distinct" makes different output
От | philip |
---|---|
Тема | BUG #1695: "select distinct" makes different output |
Дата | |
Msg-id | 20050601003609.BD392F0AC7@svr2.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #1695: "select distinct" makes different output
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 1695 Logged by: philip Email address: philipguo@yahoo.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.
В списке pgsql-bugs по дате отправления: