Materialized views working. A unit test defines a materialized view, which is populated as an in-memory table, and then checks that it is used in a subsequent query, and that the results are the same with and without the materialized view.