RE: Problems w/ materialized view.....

There appear to be about 7 bugs logged since August of this year that relate
to views returning wrong results. The ones related to outer joins, function
based indexes, and to case statements (if the underlying problem could also
apply to a decode) seem most likely:

I understand the implications of the different points in time, and that =
this could happen if DML is occurring on any of the underlying tables.

That's not the case. I can repeatedly select from the view and get the =
exact same number of rows and I can repeatedly drop and re-create the =
m-view
and select exactly the same number of rows from it every time.

This is weird.

I'm now thinking it's not actually an m-view problem, but a view =
problem. I can also demonstrate the problem this way: