Correct Handling of Current Database in Named HTTP Sessions for Temporary Table Creation

Correctly determine current database if CREATE TEMPORARY TABLE AS SELECT is queried inside a named HTTP session. This is a very rare use case. This closes #8340. #33676 (alexey-milovidov).