JDBC getPrimaryKeys() returns wrong key position
Details
| Detail name | Value |
|---|---|
| Changelog Number | 6410 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | EXASOL 6.0.0 |
| Fix Versions | Exasol 6.0.11, Exasol 6.1.beta2 |
| Resolution Date | 2018-07-12 |
Background
According to Oracle JDBC Documentation getPrimaryKeys(), should return the column sequence within a primary key in result column KEY_SEQ.
Problem
Due to a misunderstanding, Exasol returns the column ordinal position within the table, instead of within the PK.
Note
This is a fix on database side, not a problem in the driver...