QSM-02149
ON COMMIT with this MV requires 9.0 compatibility or higher
Cause
You have specified a materialized view that uses some combination of the following: joins aggregation filter conditions in the WHERE clause a remote relation in the FROM list a SUM(x) function without a corresponding COUNT(x) function an omitted COUNT(*) aggregate function a MIN() or MAX() aggregate function in combination with the REFRESH ON COMMIT option while running in less than 9.0 compatibility mode.
Action
Set your compatibility mode to 9.0 or higher or restructure the materialized view query.
QSM-02149
ON COMMIT with this MV requires 9.0 compatibility or higher
Cause
You have specified a materialized view that uses some combination of the following: joins aggregation filter conditions in the WHERE clause a remote relation in the FROM list a SUM(x) function without a corresponding COUNT(x) function an omitted COUNT(*) aggregate function a MIN() or MAX() aggregate function in combination with the REFRESH ON COMMIT option while running in less than 9.0 compatibility mode.
Action
Set your compatibility mode to 9.0 or higher or restructure the materialized view query.
QSM-02149
ON COMMIT with this MV requires 9.0 compatibility or higher
Cause
You have specified a materialized view that uses some combination of the following: joins aggregation filter conditions in the WHERE clause a remote relation in the FROM list a SUM(x) function without a corresponding COUNT(x) function an omitted COUNT(*) aggregate function a MIN() or MAX() aggregate function in combination with the REFRESH ON COMMIT option while running in less than 9.0 compatibility mode.
Action
Set your compatibility mode to 9.0 or higher or restructure the materialized view query.