When creating a materialized view against a base table the materialized view does not always reflect the correct data.
Using the following test schema:
When I insert a row into the base table the materialized views are updated appropriately.
Updating the record in the base table and setting enabled to FALSE will filter the record from both materialized views.
However a further update to the base table setting enabled to TRUE should include the record in both materialzed views, however only one view (table1_mv2) gets updated.
It appears that only the view (table1_mv2) that returns the filtered column (enabled) is updated.
Additionally columns that are not part of the partiion or clustering key are not updated. You can see that the foo column has a null value in table1_mv2.