MDB Tools 1.0.0

MDB Tools 1.0 includes a number of new features compared to the 0.9 series. The most significant change is that mdbtools.h is now generated at build time, and its internal HAVE_ macros have been removed. This means that it is now safe for clients to compile against mdbtools.h without needing to provide the same HAVE_ICONV and HAVE_GLIB flags that were present when the library was first compiled.

In most cases, ABI and API compatibility is preserved with the 0.9 series, but see the "Install" section below.

The SQL engine has two new operators: ILIKE (case-insensitive pattern matching) and <> (not equals).

To install MDB Tools 1.0:

./configure
make
make install

Changes since 0.9.4:

Build:

• Generate platform-specific mdbtools.h at configure-time #316
• Ensure compiler supports thread-local storage
• Fix AC_PROG_LEX warning with autoconf 2.70
• Rely on autoconf to define appropriate values of _XOPEN_SOURCE and friends
• New --disable-iconv configure option (falls back to wcstombs where possible)
• Fix a build error when ./configure detected iconv, but thought it was not working
• Generating the configure script now requires autoconf 2.64 or later

Install:

• Install libmdbodbc.so and libmdbodbcW.so into ${libdir}/odbc #315
• Do not install mdb-sql if SQL support was not built #276
• Do not install libmdbsql.pc if SQL support was not built

pkg-config:

• Simplify --cflags for libmdb
• Provide correct --cflags for libmdbsql

libmdb:

• Copy date formats when cloning handles #326
• Fix incorrect reading of double values #339 #342
• Fix accidental reads of non-index data #335 #343
• New mdb_set_repid_fmt() for setting the format of Rep IDs (UUIDs) #344

SQL:

• New case-insensitive, Unicode-aware ILIKE operator #244
• New <> (not equal) operator #329
• Improved support for comparing floating-point values to integers
• Improved support for floating point literals with no fractional digits (e.g. "3.")
• Add support for querying Rep IDs

ODBC:

• Format boolean values correctly as SQL_C_CHAR #327
• Add support for the SQL_C_WCHAR (UTF-16) return type #347 #348
• The Unicode driver (libmdbodbcW.so) no longer uses iconv #332 #333
• Add support for older iODBC installations lacking odbcinst.h

mdb-export:

• Convert table names to lower case when exporting to PostgreSQL #322
• Use CREATE IF NOT EXISTS when exporting to PostgreSQL #321
• Fix issue where byte columns with values > 127 were exported as negative numbers (regression introduced in v0.9.3-beta1) #350

mdb-hexdump:

• Deprecate tool

MDB Tools 1.0.0, Beta 7

mdb-export:

• Fix issue where byte columns with values > 127 were exported as negative numbers (regression introduced in v0.9.3-beta1) #350

MDB Tools 1.0.0, Beta 6

libmdb:

• Improved support for compilers that use something other than __thread for thread-local storage

ODBC:

• Remove SQLFetchW (introduced in Beta 5) in favor of the SQL_C_WCHAR return type
• Fix an issue where Chinese characters were returned instead of ASCII using the Unicode driver on some platforms #347
• Add support for older iODBC installations lacking odbcinst.h
• Improved bounds checking

MDB Tools 1.0.0, Beta 5

Changes since Beta 4:

libmdb:

• Fix incorrect reading of double values #339 #342
• Fix accidental reads of non-index data #335 #343
• New mdb_set_repid_fmt() for setting the format of Rep IDs (UUIDs) #344

SQL:

• Improved support for comparing floating-point values to integers
• Improved support for floating point literals with no fractional digits (e.g. "3.")
• Add support for querying Rep IDs

ODBC:

• Implement SQLFetchW in the Unicode driver #347 #348

MDB Tools 1.0.0, Beta 4

Changes since Beta 3:

Build:

• New --disable-iconv configure option (falls back to wcstombs where possible)
• Fix a build error when ./configure detected iconv, but thought it was not working
• Generating the configure script now requires autoconf 2.64 or later

ODBC:

• The Unicode driver (libmdbodbcW.so) no longer uses iconv #332 #333

SQL:

• New <> (not equal) operator #329

MDB Tools 1.0.0, Beta 3

Changes since Beta 2:

Build:

• Fix AC_PROG_LEX warning with autoconf 2.70
• Rely on autoconf to define appropriate values of _XOPEN_SOURCE and friends
• Simplify configure script

libmdb:

• Restore previous MdbHandle struct layout
• Simplify pkg-config --cflags

libmdbsql:

• Provide correct pkg-config --cflags

ODBC:

• Format boolean values correctly as SQL_C_CHAR #327

mdb-schema:

• Fix incorrect treatment of CREATE TABLE and DROP TABLE #328 (Bug introduced in Beta 2)

MDB Tools 1.0.0, Beta 2

Changes since Beta 1:

Build:

• Ensure compiler supports thread-local storage

libmdb:

• Copy date formats when cloning handles #326
• Restore previous mdb_register_backend API
• Restore previous MdbBackend struct layout

MDB Tools 1.0.0, Beta 1

libmdb:

• Generate platform-specific mdbtools.h at configure-time #316

SQL:

• New case-insensitive, Unicode-aware ILIKE operator #244
• Do not install mdb-sql if SQL support was not built #276
• Do not install libmdbsql.pc if SQL support was not built

ODBC:

• Install libmdbodbc.so and libmdbodbcW.so into ${libdir}/odbc #315

mdb-export:

• Convert table names to lower case when exporting to PostgreSQL #322
• Use CREATE IF NOT EXISTS when exporting to PostgreSQL #321

mdb-hexdump:

• Deprecate tool

MDB Tools 0.9.4

MDB Tools 0.9.4 is a bug-fix release, and includes new support for brackets around table names when processing and exporting SQL.

Barring future security fixes, this is the final planned release in the 0.9 series. Future development will focus on MDB Tools 1.0.

Changes since MDB Tools 0.9.3:

libmdb:

• Write encrypted pages #305
• Improved support for big-endian platforms
• Remove obsolete AC_HEADER_STDC macro from configure.ac

SQL:

• Fix compilation on RHEL 7.9 #301
• Add brackets around table names in mdb-query output #307
• Support for brackets around table names in SQL parser
• Fix regression in 0.9.3 where COUNT(*) resulted in a parse error #318 #319

ODBC:

• Fix -Werror=array-bounds compile error #313

None of the changes in this release are considered security fixes.

MDB Tools 0.9.3

MDB Tools 0.9.3 is a bug-fix release, with a focus on build warnings and failures and improved SQL syntax support. Users of the ODBC client are encouraged to upgrade immediately, as this release addresses a segmentation fault described in #278. All others are encouraged to upgrade at their convenience.

Changes since MDB Tools 0.9.2 include:

libmdb:

• Fix build failure with emscripten #299
• Fix compilation when _XOPEN_SOURCE was already defined by the build environment #298
• Fix build failures with GLib 2.68 and later by migrating to g_memdup2 #287 #288
• Support files created with Access 2019 #260 #277
• Fix a warning when reading in binary property values #262
• Fix signed-unsigned comparison warning #269

libmdbsql:

• Allow double quoted (") database names #291
• Allow spaces in database names #292 #293
• Support negative floating point literals #274 #279
• Comparison operators behaved incorrectly when the constant was on the left #283 #285
• Improved support for file paths in CONNECT TO statements #275 #280 #282

ODBC:

• unixODBC now uses the --libdir passed at configure-time #261
• Fix a segfault in PyODBC when SQLGetTypeInfo is called on an unsupported data type #278

Docs:

• Add JET version for access 2013/2016/2019 to docs #286