Database Error Messages

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

QSM-02140

agg(expr) requires correspondng SUM(expr*expr) function

Cause

The capability in question is not supported when the materialized view uses certain aggregate functions but omits an invocation of the SUM function on the square of the same argument (the argument multiplied by itself).


Action

Add the SUM function on the square of the argument.