| Author |
Message |
joplus
Joined: 30 Apr 2010
Posts: 5
|
 Posted: Wed May 25, 2011 4:39 pm Post subject: generic SQL Statement generator returning NULLs |
 |
|
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 |
|
 |
james.billings
Joined: 16 Jun 2010
Posts: 842
Location: My desk.
|
|
| Back to top |
|
|
joplus
Joined: 30 Apr 2010
Posts: 5
|
| Posted: Thu May 26, 2011 6:56 pm Post subject: Re: |
|
|
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 |
|
|
james.billings
Joined: 16 Jun 2010
Posts: 842
Location: My desk.
|
| Posted: Thu May 26, 2011 6:59 pm Post subject: |
|
|
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 |
|
|
joplus
Joined: 30 Apr 2010
Posts: 5
|
| Posted: Thu May 26, 2011 7:36 pm Post subject: Re: |
|
|
| 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 |
|
|
james.billings
Joined: 16 Jun 2010
Posts: 842
Location: My desk.
|
| Posted: Thu May 26, 2011 7:44 pm Post subject: |
|
|
| 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 |
|
|
joplus
Joined: 30 Apr 2010
Posts: 5
|
| Posted: Fri May 27, 2011 2:52 pm Post subject: Re: |
|
|
| 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 |
|
|
|
