SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

SQL/MX MXCMP Messages (2000 through 2999)
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
4-12
SQL 2051
Cause. You specified an invalid control option name or a valid option with an
invalid value.
Effect. The operation fails.
Recovery. Correct the syntax and resubmit.
SQL 2052
Cause. This error should appear only if you are running in debug mode.
Effect. None.
Recovery. None. Report the entire message to your service provider.
SQL 2053
Cause. This is an informational message that is a result of the two-pass mechanism of
the optimizer. The optimizer created a simple plan, and then while refining that plan, an
internal error occurred, so the simple plan was not improved. The simple plan is still
valid and will work.
Effect. Your query will use the original, simple plan.
Recovery. Informational message only; no corrective action is needed. This message
will be accompanied by an assertion failure message and, possibly, CONTROL
QUERY SHAPE information. However, report the entire message, and the preceding
assertion failure message, to your service provider.
This additional information will also be helpful: the DDL for the tables involved, the
query that produced this warning, and any CONTROL QUERY SHAPE and CONTROL
QUERY DEFAULT settings in effect when the error occurred.
2051 Either control option option name or value 'value'is not
valid.
2052 Optimizer internal counters: value value value value.
2053 Optimizer pass two assertion failure (failure-text) in
file file-name at line line-num.