"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"
| Item |
Description |
|
SQLCode
|
-1327L
|
|
Constant
|
UPDATABLE_MATVIEW_COUNT_NULL_EXPR
|
|
SQLState
|
42WCE
|
|
ODBC 2 State
|
ERROR
|
|
ODBC 3 State
|
ERROR
|
|
Sybase Error Code
|
3009
|
|
Severity Code
|
15
|
Probable cause
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.