ODBC Crusher Analysis of DuckDB ODBC Driver v1.4.4.0

[fdcastel]

Hi, team!

I've been working in my spare time on a small project that might be useful for improving the DuckDB ODBC driver.

What?

ODBC Crusher is an open-source testing tool designed specifically for ODBC driver developers.

It currently runs 131 comprehensive tests covering Core, Level 1, and Level 2 conformance, helping identify spec violations, crashes, and edge-case issues that real-world applications might encounter.

The duckdb-odbc results

Our team (*) recently analyzed the DuckDB ODBC driver (v1.4.4.0) and documented our findings here.

Summary: 108/123 tests passed (87.8%).

We identified 13 issues ranging from two critical crashes (descriptors and Unicode handling on Linux) to several high-priority spec conformance items. The document includes root cause analysis from your source code and specific fix suggestions.

The good news: Core statement operations, data type handling, scrollable cursors, and state management all work excellently!

We'd Love Your Feedback

This is very much a collaborative effort. I originally started it to learn more about ODBC drivers. So if you:

• Disagree with any findings (it could certainly have bugs, too!)
• Have questions about the test methodology
• Want clarification on any recommendations
• Or simply want to discuss ODBC driver development

...I'd be thrilled to hear from you!

Hope this helps make the DuckDB ODBC driver even better!

---

(*) read: me, my dog and Claude. 😄

[staticlibs]

@fdcastel

Hi, thanks for the report, this list is useful indeed! We currently have no intention to support SQL_WCHART_CONVERT, but things like auto-commit should be fixed. Going to look into this.