Red Gate forums :: View topic - generic SQL Statement generator returning NULLs
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

generic SQL Statement generator returning NULLs

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



Joined: 30 Apr 2010
Posts: 5

PostPosted: Wed May 25, 2011 4:39 pm    Post subject: generic SQL Statement generator returning NULLs Reply with quote

I am using the "generic SQL Statement" generator to populate a column. The statement is something like

select school_id from school_profile where district_id = 44

which should return 10 distinct values, none of them NULL.

I am trying to generate 90K rows of data, so I am expecting my generated data set to have about 9K rows per distinct value. Instead, I always see about 1% NULL values, no matter what I do to the settings.

I have checked the "Loop until number of rows required is reached" checkbox. I have tried un-checking "add NULLs to data," and have also tried checking that box and setting % NULL to 0.

Am I missing something? For the moment, my workaround is to use a weighted list and enter my 10 distinct values by hand, but I would like to do something more automated if possible.

Thanks in advance for any help.
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1115
Location: My desk.

PostPosted: Thu May 26, 2011 5:17 pm    Post subject: Reply with quote

Which version are you running? I found reference to a bug that caused this behaviour, which the patch from http://www.red-gate.com/messageboard/viewtopic.php?t=11835 should help with.
Back to top
View user's profile Send private message
joplus



Joined: 30 Apr 2010
Posts: 5

PostPosted: Thu May 26, 2011 6:56 pm    Post subject: Re: Reply with quote

james.billings wrote:
Which version are you running? I found reference to a bug that caused this behaviour, which the patch from http://www.red-gate.com/messageboard/viewtopic.php?t=11835 should help with.


I'm running 1.2.0.286, which is a lower version than the patch you mention (thanks, btw). But my database is case-sensitive, so I'm not sure this patch will help. And since the disclaimer says "Note: This patch has not completed the full release test cycle, so no guarantees are expressed or implied." I'm even more wary. Have you installed this update? Did it break anything?
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1115
Location: My desk.

PostPosted: Thu May 26, 2011 6:59 pm    Post subject: Reply with quote

Well according to the bug I found, the problem was actually fixed in 1.1... so either it got re-broken in a newer version, or what you are experiencing is caused by something else.

Is it possible for you to supply the database to us for further testing?
Back to top
View user's profile Send private message
joplus



Joined: 30 Apr 2010
Posts: 5

PostPosted: Thu May 26, 2011 7:36 pm    Post subject: Re: Reply with quote

james.billings wrote:
Well according to the bug I found, the problem was actually fixed in 1.1... so either it got re-broken in a newer version, or what you are experiencing is caused by something else.

Is it possible for you to supply the database to us for further testing?


Let me check with my manager and I will get back with you shortly. Thanks again.
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1115
Location: My desk.

PostPosted: Thu May 26, 2011 7:44 pm    Post subject: Reply with quote

Sure - if you can, please mail support@red-gate.com with F0048275 in the subject line and I'll sort out the details with you.
Back to top
View user's profile Send private message
joplus



Joined: 30 Apr 2010
Posts: 5

PostPosted: Fri May 27, 2011 2:52 pm    Post subject: Re: Reply with quote

james.billings wrote:
Sure - if you can, please mail support@red-gate.com with F0048275 in the subject line and I'll sort out the details with you.


Thanks, I've sent you an email.
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