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.
SQL syntax to cancel executing query, phase 1 This check-in implements the command "control query cancel qid <qid>". The command will send a cancel message to the MXSSMP cancel broker, but since the master executor is not yet sending a query started message, no query will be canceled, and if the message is successful SQLCODE -8026 will be raised. The change also validates the cancel command. produces new EXPLAIN and SHOWPLAN output and handles errors, as shown in a new regression test.