Creating temporary table as select puts the whole session in TOI/NBO not allowing to kill any query
General
Escalation
General
Escalation
Description
Environment
None
AFFECTED CS IDs
CS0053132
Activity
Show:
Details
Details
Assignee
Unassigned
UnassignedReporter

Labels
Needs QA
Yes
Affects versions
Priority
Smart Checklist
Open Smart Checklist
Smart Checklist

Open Smart Checklist
Created February 28, 2025 at 3:03 PM
Updated 3 days ago
Temporary tables are isolated to a single cluster member, so I think they should never be handled via TOI.
Now, a regular temporary table does not cause problems:
However, when the table is created via
CREATE TEMPORARY TABLE ... as SELECT
, from now on, the session is in constant TOI and nothing can be killed. Not even if the tmp table is dropped: