Creating table silently failed in default database

[JakkuSakura]

Describe what's wrong
I tried to create a table in default database, and it fails without explicit error.
If I create table in non-default databases, it works as expected.

JakkuSakura/chdb-rust@2715433

Does it reproduce on the most recent release?
I'm using chdb v2.1.1

How to reproduce

1. git clone https://github.com/JakkuSakura/chdb-rust
2. git switch -d 271543383827da3ed42e4ae883c9d767d5f379f6
3. ./update_libchdb.sh --local
4. cargo test

I didn't test other chdb clients, but here's the SQL that is falling

CREATE TABLE logs (id UInt64, msg String) ENGINE = MergeTree() ORDER BY id;
INSERT INTO logs (id, msg) VALUES (1, 'test');

Message

Error: QueryError("Code: 60. DB::Exception: Table default.logs does not exist. (UNKNOWN_TABLE)")

If I add:

CREATE DATABASE demo; USE demo

Then it's working

[JakkuSakura]

Seems duplicate of #269
upgrading to v3.1.2 doesn't solve the issue

[JakkuSakura]

Sometimes USE demo is not persistent in the same session

[auxten]

This should be fixed by change the default database type. Currently it's memory engine.

[JakkuSakura]

Is it? I even specified ENGINE = MergeTree when creating tables.
Memory engine can't be persistent is another issue

[auxten]

Table and Database both have engine type. If Database is memory engine, Table with MergeTree will also not persist

[kafka1991]

After upgrading to the new ch core(#383), this issue is no longer reproducible.