% null Doesn't Provide Expected Results

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

% null Doesn't Provide Expected Results

Postby DanielEgleston » Fri Mar 05, 2010 8:05 pm

I want to populate a column for e-mail address with values where nearly all of the data is null. So, I entered a % null value of 90. In both the preview and generated data, nearly all of the records contain a non-null e-mail address. It appears tht the % null attribute isn't giving me the results I expect.

Has anyone had a problem with the % null value?

Thanks in advance!
DanielEgleston
 
Posts: 3
Joined: Fri Mar 05, 2010 7:56 pm
Location: Cleveland, OH

Cause of Issue Found

Postby DanielEgleston » Mon Mar 08, 2010 3:49 am

I found the cause of the issue, which leads me to make an enhancement request. The issue was that I had the Set Unique checkbox checked. I assumed, since the % null textbox was still enabled, that the Set Unique checkbox only applied to the non-null values.

To prevent confusion, I would suggest removing the % null textbox from the UI when the Set Unique checkbox is checked. Or, which I would prefer, is make the Set Unique checkbox apply to non-null values only.
DanielEgleston
 
Posts: 3
Joined: Fri Mar 05, 2010 7:56 pm
Location: Cleveland, OH

Postby Linda Hawksworth » Mon Mar 08, 2010 10:48 am

Thanks for your comments regarding SQL Data Generator. I have logged this issue in our tracking system with reference SDG-896. It will be considered for a future release of SQL Data Generator although we have no timescales for this at present.
Linda Hawksworth
 
Posts: 192
Joined: Mon Jun 25, 2007 11:32 am


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests