Alex Kasko

@marhar You are correct, there is something wrong with attaching to MySQL catalog (the same works for me with Postgres): ``` $ ./duckdb DuckDB v1.3.1 (Ossivalis) 2063dda3e6 Enter ".help" for...

@RajMishraa The problem is specific to auto-commit mode, that is enabled in JDBC by default. If auto-commit is disabled with `conn.setAutoCommit(false)` (or in DBeaver settings) - then DuckLake scans work...

@Tishj The same thing happens in ODBC with auto-commit enabled: ``` DataSource.Error: ODBC: ERROR [HY000] ODBC_DuckDB->SingleExecuteStmt Not implemented Error: Scanning a DuckLake table after the transaction has ended - this...

This backtrace of the problematic call may be useful: ``` ducklake.duckdb_extension!duckdb::DuckLakeFunctionInfo::GetTransaction(duckdb::DuckLakeFunctionInfo * const this) (/home/alex/projects/duck/ducklake/src/storage/ducklake_scan.cpp:98) ducklake.duckdb_extension!duckdb::DuckLakeMultiFileList::GetFilesForTable(duckdb::DuckLakeMultiFileList * const this) (/home/alex/projects/duck/ducklake/src/storage/ducklake_multi_file_list.cpp:461) ducklake.duckdb_extension!duckdb::DuckLakeMultiFileList::GetFiles(duckdb::DuckLakeMultiFileList * const this) (/home/alex/projects/duck/ducklake/src/storage/ducklake_multi_file_list.cpp:569) ducklake.duckdb_extension!duckdb::DuckLakeMultiFileList::GetFile(duckdb::DuckLakeMultiFileList * const this, duckdb::idx_t...

Can confirm that this problem is fixed now, running DuckDB commit `51070f2fb6` with the latest `9c21561228` DuckLake.

@feanor12 > Does that mean one has to implement a catalog? It needs to implement the Storage Extension, see example in [duckdb-postgres](https://github.com/duckdb/duckdb-postgres/blob/e58cd1dfed98a04ce3e928d5b941e5e2c533ba12/src/postgres_extension.cpp#L163). Unfortunately this functionality is not yet exposed in...