ODBC overrides the system setting for query timeout at connect time
Details
| Detail name | Value |
|---|---|
| Changelog Number | 7224 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | EXASOL 6.0.0, Exasol 6.1.0 |
| Fix Versions | Exasol 6.0.14, Exasol 6.1.2 |
| Resolution Date | 2019-01-17 |
Background
In Exasol, the query timeout default for new sessions can be set in the whole system.
Currently ODBC begins all sessions by setting the query timeout to 0 (infinite). Unfortunately this overrides the system default.
Fix
The Exasol ODBC will not override the global value for query timeout anymore.
Workaround
Set the query timeout using ODBC functionality or run "alter session set query_timeout=..." at the beginning of your new session.