QSM-02037: cannot evaluate constant expression at compile time

QSM-02037: cannot evaluate constant expression at compile time
Cause: The capability in question is not supported when the materialized view uses a compile-time non-constant expression in a filter condition in the WHERE or HAVING clauses. For example, WHERE X=1 uses a compile-time constant expression in a filter condition. WHERE X=MY_PLSQL_FUNCTION() uses a compile-time non-constant expression in a filter condition.
Action: Re-phrase the query to avoid the use of a compile-time non-constant expressions in filter conditions.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02037：无法在编译时评估常量表达式,
.原因：当物质化视图在WHERE或HAVING子句中的过滤条件中使用编译时非常量表达式时，不支持所讨论的功能。例如，WHERE X = 1在过滤条件下使用编译时常量表达式。WHERE X = MY_PLSQL_FUNCTION（）在过滤条件中使用编译时非常量表达式。,
.操作：重新排序查询以避免在过滤条件下使用编译时非常数表达式。,
.

aiaiDBA

13718043309

010-86462881

QSM-02037: cannot evaluate constant expression at compile time

1 个回答

相似问题