Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

QSM-02135

agg(expr) requires correspondng AVG(expr) function

Cause

The capability in question is not supported when the materialized view uses certain aggregate functions but omits an invocation of the AVG function on the same argument.


Action

Add the AVG function to the select list.