HI

I found some bug:
When I select from table (select A,B,count(*) INTO table tmp1 FROM AAA
group by A,B; ) in 
big table some touples are duplicated ;(,

 A,	B,	count(*)
321	1	3	\	?
321	1	2	/  	?
321	2	5
...........

PS: I use linux 2.0.33 and solaris 2.5.1 and  postgres 6.2.1v7

-- 
SY, Serj

Mon, 19 Jan 1998 17:42:35 +0300
Serj <fenix@am.ring.ru>
postgres 6.2.1 Group BY BUG
Can you try this in the current 6.3 beta and tell us if it is fixed?


> HI
> 
> I found some bug:
> When I select from table (select A,B,count(*) INTO table tmp1 FROM AAA
> group by A,B; ) in 
> big table some touples are duplicated ;(,
> 
>  A,	B,	count(*)
> 321	1	3	\	?
> 321	1	2	/  	?
> 321	2	5
> ...........
> 
> PS: I use linux 2.0.33 and solaris 2.5.1 and  postgres 6.2.1v7
> 
> -- 
> SY, Serj
> 
> 


-- 
Bruce Momjian
maillist@candle.pha.pa.us

Fri, 13 Feb 1998 15:14:42 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [QUESTIONS] postgres 6.2.1 Group BY BUG
Bruce Momjian wrote:
> 
> Can you try this in the current 6.3 beta and tell us if it is fixed?
> 
> > HI
> >
> > I found some bug:
> > When I select from table (select A,B,count(*) INTO table tmp1 FROM AAA
> > group by A,B; ) in
> > big table some touples are duplicated ;(,
> >
> >  A,   B,      count(*)
> > 321   1       3       \       ?
> > 321   1       2       /       ?
> > 321   2       5

I didn't fix GROUP BY yet.

Vadim

Sun, 15 Feb 1998 16:44:00 +0700
"Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
Re: [HACKERS] Re: [QUESTIONS] postgres 6.2.1 Group BY BUG