Releases: mdbtools/mdbtools
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 towcstombs
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
andlibmdbodbcW.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 theSQL_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:
MDB Tools 1.0.0, Beta 4
Changes since Beta 3:
Build:
- New
--disable-iconv
configure option (falls back towcstombs
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:
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
andDROP 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
andlibmdbodbcW.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