IO Error: Failed to run query "START TRANSACTION": UDAL - Unknown command

[zhangzhangyaa]

What happens?

i want to use duckdb connect wrapped mysql called teledb, first attach , second use mysql_db, then it reported errors.
does duckdb have a option do not exec "start transaction"?

To Reproduce

attach 'connection info' as mysql_db (type mysql);
use mysql_db;

OS:

linux

MySQL Version:

5.7

DuckDB Version:

0.10.1

DuckDB Client:

cli

Full Name:

zhangzhang

Affiliation:

personal

Have you tried this on the latest main branch?

• I agree

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

• I agree

[driv]

I'm having a similar issue with another mysql compatible DB that does not support transactions. Is it possible to disable transactions when connecting to mysql in DuckDB?