In this blog post, you’ll learn more about the Sybase Error The materialized view cannot be changed to immediate because its SELECT list contains a SUM function over a nullable expression and it doesn’t contain a COUNT function over the same expression and the reason for receiving this error
Sybase SQL Error Message
The materialized view cannot be changed to immediate because its SELECT list contains a SUM function over a nullable expression and it doesn’t contain a COUNT function over the same expression
Reason for this Error
You attempted to change the refresh type to immediate for a materialized view whose definition contains a SUM function over a nullable expression but it doesn’t contain COUNT function over the same expression.