Expected Behavior
CSV - table with unique index and PK on identity column should prefer the unique index, or allow primaryKeys attribute to override existing PK
Actual Behavior
primary key is used, and we cannot override. Will need to think about which way is best
Obevo Version where this issue was observed
6.3.0, though it exists beforehand
Steps to reproduce the behavior
Create table w/ PK on identity column and unique index
Test this out in CSV loading unit test
Ensure that we can detect identity columns in the metadata test
Use Case 2 related to this:
table exists with primary key and unique index on separate columns
CSV file is defined without the PK identity column, but with the unique index columns
In DB2, it looks like any updates on the column will fail
Ideally, we should allow overriding the PK column. But in case users don't, we should handle this elegantly. Maybe ignoring the identity PK as mentioned above would be good