Uniqueness for compound keys

cb66 · March 20, 2017 8:08AM

Hello,

sorry if this is already covered elsewhere, but I can't seem to figure out how to ensure that a compound key is unique, either via the UI or in the SQL Data Generator project file. Could you give me a hint?

Thanks a lot in advance!

Eddie D · April 3, 2017 4:02PM

Hi

Thank you for your forum post.

When you view the Column generation settings in the GUI, ensure that 'set unique' check box is set.

Many Thanks
Eddie

cb66 · April 5, 2017 12:10PM

That works fine for a single column on its own, but what I need is the combination of multiple columns to be unique.

In fact, in our case, our business logic requires that some of the individual columns are not unique. In one column, we are using IDs that only allow a handful of different values, but we must produce hundreds to thousands of new random records.

Eddie D · April 5, 2017 12:35PM

Hi

Thank you for your forum post.

The root of the problem is that SDG generates each column independently of the others and therefore does not handle compound constraints correctly. I have added the details of this forum post to an existing Bug Report SDG-921, sadly I do not have an ETA as to when a bug fix version may become available.

Many Thanks
Eddie

Cory · June 13, 2017 6:06PM

This is a critically important feature to us...is there any update regarding when it might be implemented correctly?

Eddie D · June 16, 2017 9:51AM

Hi Cory,
Sadly, Bug Report SDG-921 is still open and I do not have an ETA as to when a bug fix version may become available. Sorry.

bclewis · October 18, 2021 11:44PM

Is this still an issue? Are there any workarounds for generating unique tuples with this software?

Uniqueness for compound keys

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk