Uniqueness for compound keys

cb66

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

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

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

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

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

Eddie D

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

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