Red Gate forums :: View topic - % null Doesn't Provide Expected Results
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 1
SQL Data Generator 1 forum

% null Doesn't Provide Expected Results

Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
DanielEgleston



Joined: 05 Mar 2010
Posts: 3
Location: Cleveland, OH

PostPosted: Fri Mar 05, 2010 8:05 pm    Post subject: % null Doesn't Provide Expected Results Reply with quote

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!
Back to top
View user's profile Send private message
DanielEgleston



Joined: 05 Mar 2010
Posts: 3
Location: Cleveland, OH

PostPosted: Mon Mar 08, 2010 3:49 am    Post subject: Cause of Issue Found Reply with quote

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.
Back to top
View user's profile Send private message
Linda Hawksworth



Joined: 25 Jun 2007
Posts: 192

PostPosted: Mon Mar 08, 2010 10:48 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group