SQL/MX 2.x Messages Manual (H06.10+, J06.03+)

Versioning and Distribution Messages (25000 through
25399)
HP NonStop SQL/MX Messages Manual—544518-011
18-16
Cause. An attempt is made to execute a query plan or query plan fragment with a plan
version that is lower than the reporting node’s oldest supported plan version.
Effect. There are two possibilities:

Automatic recompilation is attempted (if allowed) with the current compiler. If the
recompilation succeeds, this message is returned as a warning and the query is re-
executed.

Automatic recompilation is not allowed, or failed. In that case this message is
returned as an error. The operation fails.
Recovery. Enable the default RECOMPILE_ON_PLANVERSION_ERROR using a
control query default statement and retry the operation.
SQL 25303
where:
version1 is the plan version of the affected query.
node is the name of the node that detects the incompatibility.
version2 is the MXV of the node that detects the incompatibility.
text-string-1 is additional details about the error. This is an optional parameter.
Cause. An attempt is made to execute a query plan or query plan fragment with a plan
version that is higher than the MXV of the node that executes the plan or plan
fragment.
Effect. There are two possibilities:

Automatic recompilation is attempted (if allowed) with a downrev compiler that
produces plans with a plan version that is compatible with version2. If the
recompilation succeeds, this message is returned as a warning and the query is re-
executed.

Automatic recompilation is not allowed, or failed. In that case this message is
returned as an error. The operation fails.
Recovery. Enable the default RECOMPILE_ON_PLANVERSION_ERROR via a
control query default statement and retry the operation.
Message 25303 is for R2.0 and later.
25303 The query plan version is version1; node node does not
support query plan versions higher than version2 text-string-
1.