for those that care bug# 1666543 is the psycho bitmap count(*) error
problem.
broke since it looks like 8.0.5 and still not fixed in 8.1.7
joe
Joe,
I saw this same problem post on lazydba just yesterday.
It was a bug that is supposedly fixed in 8.1.7, but you
know how that goes.
It
Scenario:
AIX, 8.1.6.3.
Cognos cube building going on.
select count(*) from ft_sales, shows up 0 rows, its using a bitmap index out
of the explain plan.
I force full table scan or force to use other bitmap index, or PK(normal
index) and it comes back with correct count(20+ million).
Anyone
Joe,
I saw this same problem post on lazydba just yesterday.
It was a bug that is supposedly fixed in 8.1.7, but you
know how that goes.
It apparently does not corrupt data. You probably should
look up the details on MetaClink.
Jared
On Tuesday 17 April 2001 08:00, Joseph Testa wrote: