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...