Using duckdb-node-blocking Table not found

[andyPengtian]

What happens?

Using duckdb-node-blocking to open the database was successful, but tables are not visible and queries fail.

To Reproduce

import * as arrow from 'apache-arrow';
import * as duckdb from '@duckdb/duckdb-wasm';
import * as duckdb_blocking from '@duckdb/duckdb-wasm/dist/duckdb-node-blocking';
import path from "node:path";
import { DuckDBAccessMode } from "@duckdb/duckdb-wasm";

const DUCKDB_BUNDLES = {
            mvp: {
                mainModule: path.resolve(DUCKDB_DIST, './duckdb-mvp.wasm'),
                mainWorker: '',
            },
            eh: {
                mainModule: path.resolve(DUCKDB_DIST, './duckdb-eh.wasm'),
                mainWorker: '',
            },
        }
       
            const logger = new duckdb.ConsoleLogger(duckdb.LogLevel.DEBUG);
            const db = await duckdb_blocking.createDuckDB(DUCKDB_BUNDLES, logger, duckdb_blocking.NODE_RUNTIME);
            await db.instantiate();
            db.open({
                path:  "./test.db", // from https://blobs.duckdb.org/data/test.db
                accessMode: DuckDBAccessMode.READ_WRITE
            });
            const conn = db.connect();
            conn.query("select * from t");

error :    Catalog Error: Table with name t does not exist!
    Did you mean "pg_tables"?

    LINE 1: select * from t
                          ^
// show tables;
result : []
// SELECT * FROM information_schema.schemata;
result: [
        {"catalog_name": "system", "schema_name": "information_schema", "schema_owner": "duckdb", "default_character_set_catalog": null, "default_character_set_schema": null, "default_character_set_name": null, "sql_path": null},
        {"catalog_name": "system", "schema_name": "main", "schema_owner": "duckdb", "default_character_set_catalog": null, "default_character_set_schema": null, "default_character_set_name": null, "sql_path": null},
        {"catalog_name": "system", "schema_name": "pg_catalog", "schema_owner": "duckdb", "default_character_set_catalog": null, "default_character_set_schema": null, "default_character_set_name": null, "sql_path": null},
        {"catalog_name": "temp", "schema_name": "main", "schema_owner": "duckdb", "default_character_set_catalog": null, "default_character_set_schema": null, "default_character_set_name": null, "sql_path": null},
        {"catalog_name": "test", "schema_name": "main", "schema_owner": "duckdb", "default_character_set_catalog": null, "default_character_set_schema": null, "default_character_set_name": null, "sql_path": null}
      ]

Browser/Environment:

node v22.19.0

Device:

mac arm64

DuckDB-Wasm Version:

1.30.0

DuckDB-Wasm Deployment:

duckdb-node

Full Name:

andy zhao

Affiliation:

SteelSQL team