postgres 6.2.1 Group BY BUG
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
Import Notes
Reference msg id not found: 199712221749.JAA05458@f66.hotmail.com
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
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