1.0.1: Increased Connection Timeout

This is a maintenance release where we increased the waiting timeout for establishing connections to 60 seconds.
The reason is that we saw in very rare occasions that a TLS handshake can take longer than the current 10 seconds and increasing the timeout allows the connection to recover.

We also fixed a broken integration test and improved the diagnostics around it.

Bugfixes

Refactoring

• 105: Moved design and system requirements into their own subdirectory.

1.0.0: TLS Certificate Fingerprint Pinning

Summary

This release adds optional TLS certificate fingerprint pinning for database connections.

This release updates all dependencies on top of 0.2.1. We also decided to increase the version number of the driver to 1.0.0, since all basic features are now available.

We also now pin the Ubuntu version to 24.04 in the CI build.

Breaking change: Support for Exasol 7.x has been removed.

Features

• #100: Add TLS certificate fingerprint pinning.

Refactoring

• #97: Updated dependencies on 0.2.1

Bugfixes

• #100: Improved handling and error reporting for WebSocket receive timeouts.

0.2.1: Upgrade to Exasol 8.29.6

Summary

This release updates integration tests to additionally use Exasol version 8.27.0.

When running integration tests with luarocks test or busted, the environment variable EXASOL_HOST now has a default value localhost to make running tests more convenient.
If you run local tests, the Exasol DB is most likely set up to forward the default database port to the localhost anyway.

Additionally, coverage checks are now restricted to selected busted configurations. For example, it does not make sense to run with coverage on repeated tests.

Integration test now succeeds with TLS 1.3 in addition to TLS 1.2 (version 8.18.0)

Tests

• #56: Sped up repeated CI tests
• #78: Added tests with Exasol 8
• #91: Fixed failing tests with Exasol 8

0.2.0: Run inside Exasol UDF

exasol-driver-lua 0.2.0, released 2022-10-21

Code name: Run inside an Exasol UDF

Summary

In this release we added support for using exasol-driver-lua inside an Exasol user defined functions (UDF). See the user guide for detailed instructions.

Features

• #23: Added support for running inside an Exasol UDF

Documentation

• #54: Added dependency list

Refactoring

• #77: Upgrade to exaerror 2.0.1

Bugfixes

• #82: Fixed broken links and a small documentation error (let instead of local).

0.1.0: Initial Release

exasol-driver-lua 0.1.0, released 2022-06-13

Code name: Initial Release

Summary

This is the initial release of the Lua driver for Exasol. It is fully compatible with the LuaSQL API and allows you to connect to an Exasol database and execute SQL statements. You can find more information in the readme and the user guide.

Features

• #1: Setup initial project
• #5: Added support for mode "a" for cursor:fetch()
• #24: Implemented connection:setautocommit(true|false)
• #45: Implemented close() methods as defined in the LuaSQL API
• #44: Implemented cursor:getcoltypes()
• #43: Implemented cursor:getcolnames()
• #7: Allow specifying TLS options for connecting to Exasol
• #41: Implemented connection:commit()
• #42: Implemented connection:rollback()
• #6: Added tests to verify LuaSQL compatibility

Bugfixes

• #16: Fixed sporadic Websocket connection errors
• #51: Fixed wrong error message for invalid TLS parameter values
• #31: Upgraded integration tests to Exasol 7.1.10 to fix sporadic test failures

Refactoring

• #25: Migrated tests to busted
• #18: Replaced lunajson with cjson
• #17: Added unit tests
• #35: Added integration test for fetching large results with fetch size smaller than the row size
• #33: Replaced cjson.null in returned row data with luasql.exasol.NULL
• #39: Renamed entry module to luasql.exasol
• #71: Removed unnecessary exceptions for luacheck
• #15: Added integration tests for all Exasol data types
• #9: Prepared publishing to luarocks
• #10: Added integration tests for timestamps with and without local timezone

Documentation

• #17: Added requirements and design documents
• #34: Adapted documentation of error return type
• #12: Added user guide