SQL/MX 3.1 Messages Manual (H06.23+, J06.12+)

Versioning and Distribution Messages (25000
through 25399)
HP NonStop SQL/MX Release 3.1 Messages Manual—663849-001
19-22
Where version2 is the MXV of the node that detects the incompatibility.
Cause. You attempted to execute a query plan fragment with a plan version that is
later 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 supported or failed. This message is returned as an
error. The operation fails.
Recovery. Recompile the plan or module with a supported version compiler that
generates plans that are compatible with all involved nodes.
SQL 25307
Where version1 is the plan version of the affected query plan.
Where node is the node that attempts to execute the query.
Where MXV1 is the MXV of the affected node.
Cause. The affected node runs a GA version of SQL/MX and is incompatible with a
query plan generated by a non-GA version.
Effect. The request fails.
Recovery. Compile the query with a compiler version that is compatible with the MXV.
SQL 25308
Where version1 is the plan version of the affected query plan.
Where MXV1 is the MXV of the affected node.
Cause. The affected node runs a non-GA version of SQL/MX and is compatible only
with query plans generated by its own version.
Effect. The operation fails.
Recovery. Compile the query with a compiler version that is compatible with the MXV.
25307 The query plan can only be executed by a node with
SQL/MX Software Version (MXV) version1, the MXV of node is
MXV1.
25308 The query plan has plan version version1. The local
SQL/MX software version (MXV) can execute query plans with
plan version MXV1 only.