Transaction restarts

When the system restarts a transaction because of a state change, S-Blade restart, or other reasons, the SPUPad UDXs are affected.

A SELECT statement can be restarted if it is not in a multi-statement transaction and no results are returned yet. A multi-statement transaction that is between statements can be restarted if it has not modified any data so far.

For a single-select query, there are no implications other than making sure that any SPUPads that might have been created are properly freed. For the multi-statement select, if any of the UDXs in the statements use the SPUPad, they are written to ensure that they error and exit if the SPUPad does not exist.