bug 860500 Add ON COMMIT DROP to temporary table creation

i want this to go out in 41.0 so we stop having backfill problems.