Creating temporary table as select puts the whole session in TOI/NBO not allowing to kill any query

Description

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:

Environment

None

AFFECTED CS IDs

CS0053132

Activity

Show:

Details

Assignee

Reporter

Labels

Needs QA

Yes

Affects versions

Priority

Smart Checklist

Created February 28, 2025 at 3:03 PM
Updated 3 days ago