Red Gate forums :: View topic - Issue with generating unique values by pattern
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

Issue with generating unique values by pattern

Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
DAndres109@aol.com



Joined: 03 May 2008
Posts: 14
Location: New York

PostPosted: Sat May 03, 2008 2:08 am    Post subject: Issue with generating unique values by pattern Reply with quote

Hi,

I'm trying to generate sets of account numbers, which are either three or eight digits long.

If I use the pattern "00\d{6}|00\d" for either the RegExpGenerator or the Business->Account Number generators with the unique option unchecked, I get a random selection of account numbers that are either three or eight characters long (as expected and desired, save for the lack of uniqueness). However, if I turn on uniqueness, I only seem to be creating account numbers that are eight characters in length. I am generating 1000 rows, so there are more than enough combinations to guarantee unique values.

Can you replicate this issue on your end and is this a bug or my misunderstanding?

David Andres
Back to top
View user's profile Send private message AIM Address Yahoo Messenger
benhall



Joined: 14 Dec 2007
Posts: 98

PostPosted: Tue May 06, 2008 3:11 pm    Post subject: Reply with quote

Hi David,

I have been able to replicate this and I have added it into our bug tracking system. Thankyou for reporting this.

Ben
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