SQL Data Generator, Table generation settings

Testuser

We are testung SQL Data Generator
A question to the Option "When data is invalid:"  -> "Skip row"

We have a table with two columns of which at least one column must have a NOT NULL value. (Check Contraint)

valid:

x, NULL

NULL, y

x, y

The generator generates data that are correct, including those that are not permitted (a NULL in each column)

When generating data with the "Skip row" option, the hard error is reported:

    The INSERT statement conflicted with the CHECK constraint ...

    The statement has been terminated.

I would now have expected that the correct generated test sets would at least be inserted.

How is the "Skip row" option to be understood?

Jessica R

Thanks for your post!

I believe the name of this option may be misleading, but to help me investigate, are you able to share the CREATE script for your table so I can try to reproduce this locally?

Testuser

The create ccript and the project file are in the ZIP-File.
Thanks!

Jessica R

Thank you @Testuser and apologies for the delay! I am able to reproduce this and it looks like the "skip row" option only applies in certain situations, though I don't have much clarity on this myself. I have logged a request for further investigation with reference SDG-1324.