added further tests for e.g. materialized views