Mdbtools Versions Save

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-export:

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

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

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

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

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)

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

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 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.

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