BUG #1359: there is a problem in "SELECT ....GROUP BY"

From: "jingold chen" <jingold_chen(at)hotmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1359: there is a problem in "SELECT ....GROUP BY"
Date: 2004-12-26 15:55:32
Message-ID: 200412261555.iBQFtWKR025045@developer.pgadmin.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1359
Logged by: jingold chen
Email address: jingold_chen(at)hotmail(dot)com
PostgreSQL version: 8.0
Operating system: window xp home edition
Description: there is a problem in "SELECT ....GROUP BY"
Details:

I have install a postgresql 8.0 RC2 for window.
And Create a database with "Unicode"
But I send a query at "pgAdminIII 1.2":
"select recie_man,count(id) from public.case_table
group by 1 order by 2"
It return a recordset with duplicate record.
-----------
the table(case_table) definition:
CREATE TABLE public.case_table
(
id int4 NOT NULL,
caseclass char(1),
linkman char(24),
emailaddr char(32),
address text,
phone char(16),
recie_man char(64),
) WITH OIDS;
I don't know what worry in it.
Is it the postgresql 8.0 bug?
I have do the same test in postgresql 7.4 for linux
and gain the right result (It return a recordset without duplicate)

Browse pgsql-bugs by date

  From Date Subject
Next Message Tran Duc Khoa 2004-12-27 10:08:14 BUG #1360: Use PostgreSQL OLE DB Provider in VS.NET 2003
Previous Message John Summerfield 2004-12-26 12:11:53 PostgreSQL 8.0.0 Release Candidate 2 announcement