1.0.10: Fix vulnerability GO-2024-2963 in `net/[email protected]`

Summary

This release fixes vulnerability GO-2024-2963 in net/[email protected] by upgrading builds to the latest Go version 1.22.5.

Important: We recommend users to also upgrade to the latest Go version in order to fix this vulnerability.

Security

• #119: Fixed vulnerability GO-2024-2963 in net/[email protected]

1.0.9: Fix reading int values

Summary

This release fixes an issue when calling rows.Scan(&result) with an int value. This failed for large values like 100000000 with the following error:

sql: Scan error on column index 0, name "COL": converting driver.Value type float64 ("1e+08") to a int64: invalid syntax

Please note that reading non-integer numbers like 1.1 into a int64 variable will still fail with the following error message:

sql: Scan error on column index 0, name "COL": converting driver.Value type string ("1.1") to a int64: invalid syntax

The release also now returns the correct error from rows.Err(). Before, this only returned driver.ErrBadConn.

Bugfixes

• #113: Fixed Scan() with large integer numbers
• #111: Return correct error from rows.Err()

1.0.8: Fix inserting double values

Summary

This release fixes an issue inserting double values with a prepared statement.

Details of the fix:
The driver serializes commands to the database as JSON. When inserting values into a DOUBLE column, the database expects the JSON to contain numbers with a decimal point, e.g. 42.0. When using values like 42 or 42.0 in stmt.Exec(), the driver omitted the decimal point. This caused the query to fail with error

E-EGOD-11: execution failed with SQL error code '00000' and message 'getDouble: JSON value is not a double

Bugfixes

• #108: Fixed inserting double values with a prepared statement

Dependency Updates

Compile Dependency Updates

• Updated github.com/gorilla/websocket:v1.5.1 to v1.5.3
• Updated github.com/exasol/exasol-test-setup-abstraction-server/go-client:v0.3.6 to v0.3.9

1.0.7: Fix vulnerability CVE-2023-45288

Summary

Updated dependencies.
Fixed CVEs:

• golang.org/x/net : CVE-2023-45288

Security

• #106: Updated dependencies and fixed vulnerability

Dependency Updates

Test Dependency Updates

• Updated golang.org/x/sync:v0.6.0 to v0.7.0

1.0.6: Fix escaping of URL path

Summary

This release fixes an issue when the user specifies a URL path containing characters like ? or %. These were incorrectly escaped. We fixed this and now the URL path is used without modification when connecting to the database.

Bugfix

• #104: Fixed encoding of URL path

1.0.5: Escape connection string

Summary

This release supports using ; in the connection string. When using the builder like this, it will automatically escape the semicolon:

connectionString := exasol.NewConfig("<username>", "<password>").
                           Host("<host>").
                           Port(8563).
                           ClientName("My Client; Version abc").
                           String()

When using the connection string directly, you need to escape ; with a \:

connectionString := `exa:localhost:1234;user=sys;password=exasol;clientname=My Client\; Version abc`

Additionally this release also support specifying an URL path when creating the WebSocket connection to the database. This is only required in special situations and should not be used when connecting to an Exasol database.

Features

• #103: Added support for URL Path when connecting

Dependency Updates

Compile Dependency Updates

• Updated golang:1.20 to 1.21
• Updated github.com/gorilla/websocket:v1.5.0 to v1.5.1
• Updated github.com/stretchr/testify:v1.8.4 to v1.9.0
• Updated github.com/exasol/exasol-test-setup-abstraction-server/go-client:v0.3.4 to v0.3.6

Test Dependency Updates

• Updated go.uber.org/goleak:v1.2.1 to v1.3.0
• Updated golang.org/x/sync:v0.4.0 to v0.6.0

1.0.4: Fixed `IMPORT LOCAL CSV FILE`

Summary

This release fixes the detection of IMPORT LOCAL CSV FILE. Before, the Go driver also detected this inside strings which broke e.g. running the following INSERT statement:

insert into table1 values ('import into {{dest.schema}}.{{dest.table}} ) from local csv file ''{{file.path}}'' ');

Thanks to @cyrixsimon and @ssteinhauser for reporting this.

Bugfixes

• #98: Fixed detection of IMPORT LOCAL CSV FILE

Dependency Updates

Compile Dependency Updates

• Updated github.com/exasol/exasol-test-setup-abstraction-server/go-client:v0.3.3 to v0.3.4

v1.0.3: Reduce log verbosity

Summary

This release reduces log verbosity.

Features

• #97: Reduced log verbosity (contributed by @sabitor)

Dependency Updates

Test Dependency Updates

• Updated golang.org/x/sync:v0.3.0 to v0.4.0

1.0.2: Improve Test Coverage

Summary

This release refactors the websocket communication code to allow unit testing and improve test coverage.

The release also upgrades the required Go version from 1.19 to 1.20.

Refactoring

• #95: Improved unit test coverage

Dependency Updates

Compile Dependency Updates

• Updated golang:1.19 to 1.20

1.0.1: Add query timeout

Summary

This release adds support for specifying the query timeout in seconds when connecting to an Exasol database. The default timeout is 0, i.e. no timeout.

The release also adds integration tests with Exasol v8. Exasol version 7.0 is deprecated and no longer supported.

Features

• #92: Added tests with Exasol v8
• #89: Added query timeout to DSN

Dependency Updates

Compile Dependency Updates

• Updated github.com/exasol/error-reporting-go:v0.1.1 to v0.2.0

Test Dependency Updates

• Updated golang.org/x/sync:v0.1.0 to v0.3.0
• Updated github.com/stretchr/testify:v1.8.2 to v1.8.4
• Updated github.com/exasol/exasol-test-setup-abstraction-server/go-client:v0.3.2 to v0.3.3