I am trying to create test data, by creating a schema based on the database schema of the TPC-C benchmark. I also added some indexes, but now I encountered a weird warning from SQL Data Generator:
Warning: Duplicates may be inserted. Set unique is not selected for any columns in unique constraint PK_STOCK item/warehouse
This unique constraint is a composite primary key, consisting of two fields:
- Code: Select all
constraint PK_Stock PRIMARY KEY CLUSTERED(item, warehouse)
As far as I understand it, this means that the combination of the two fields is unique. So, why would I need to select unique for either of the two fields? Am I missing something, or is this a bug?