Thread

1. postgres 6.2.1 Group BY BUG

   Serj <fenix@am.ring.ru> — 1998-01-19T14:42:35Z

   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
   
   

2. Re: [QUESTIONS] postgres 6.2.1 Group BY BUG

   Bruce Momjian <maillist@candle.pha.pa.us> — 1998-02-13T20:14:42Z

   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
   
   

3. Re: [HACKERS] Re: [QUESTIONS] postgres 6.2.1 Group BY BUG

   Vadim B. Mikheev <vadim@sable.krasnoyarsk.su> — 1998-02-15T09:44:00Z

   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