Skip to content

Improve handling of CSV static data load where identity column with separate unique index involved #106

@shantstepanian

Description

@shantstepanian

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

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions