Database Error Messages

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

QSM-02139

agg(expr) requires correspondng agg(expr+expr) function

Cause

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


Action

Add the indicated aggregate function to the select list.