SQL syntax to cancel executing query, phase 2 This check-in causes queries to register with the cancel broker using a nowait Seabed message, and to process the completion of the message by canceling the executing query if the cancel broker so indicates in the message reply. The check-in includes new test cases in the regression test to cancel different types of SELECT queries.
These types of queries do not yet respond to cancel: 1. Queries that are decomposed into child queries, e.g., CREATE INDEX, CREATE TABLE AS, UPDATE STATISTICS, etc; 2. UPDATE and DELETE 3. INSERT queries might work now, but haven't been tested.
Query Invalidation triggered by DDL, phase 3 This check-in allows invalidation of queries which have been prepared and are held by the EXE for execution or re-execution. It does not invalidate running queries.
When an attempt is made to (re)execute an invalidated query, a special SQLCODE, 8738, is raised and the query is sent ack to the compiler via the AQR mechanism. The check-in include a new test cases in the executor/TEST122 regression test which demonstrate the functionality.