Issue with generating unique values by pattern

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

Issue with generating unique values by pattern

Postby DAndres109@aol.com » Sat May 03, 2008 2:08 am

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
DAndres109@aol.com
 
Posts: 14
Joined: Sat May 03, 2008 1:25 am
Location: New York

Postby benhall » Tue May 06, 2008 3:11 pm

Hi David,

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

Ben
benhall
 
Posts: 69
Joined: Fri Dec 14, 2007 11:15 am


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests