Aller au contenu principal

INVALID_DEFAULT_VALUE error condition

SQLSTATE: 42623

Failed to execute <statement> command because the destination column or variable <colName> has a DEFAULT value <defaultValue>,

DATA_TYPE​

which requires <expectedType> type, but the statement provided a value of incompatible <actualType> type.

NON_DETERMINISTIC​

which contains a non-deterministic expression.

NOT_CONSTANT​

which is not a constant expression whose equivalent value is known at query planning time.

SUBQUERY_EXPRESSION​

which contains subquery expressions.

UNRESOLVED_EXPRESSION​

which fails to resolve as a valid expression.