Unable to create MergeTree Table in a session: Database _temporary_and_external_tables doesn't exist.

[pandada8]

Creating a MergeTree table results in an error with the message: Code: 81. DB::Exception: Database _temporary_and_external_tables doesn't exist. (UNKNOWN_DATABASE)

How to reproduce

• modified from readme.md example

  from chdb import session as chs
  
  sess = chs.Session()
  sess.query("CREATE DATABASE IF NOT EXISTS db_xxx ENGINE = Atomic;")
  sess.query("use db_xxx;")
  sess.query("CREATE TABLE IF NOT EXISTS db_xxx.log_table_xxx (x String, y Int) ENGINE = MergeTree ORDER BY x;")

  the use db_xxx; line doesn't seem to affect the outcome and consistently generates an error.

Expected behavior No error message. Table is created.

[lmangani]

Hello @pandada8 thanks for your report. Could you confirm your OS, Python & chdb version/architecture?

[lmangani]

Works in colab with 0.11.5 🎉

[auxten]

Todo: Support use db_xxx in chdb session.