Issue with generating unique values by pattern

The simplest way to populate your database with test data.

Issue with generating unique values by pattern

Postby » Sat May 03, 2008 1:08 am


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
Posts: 14
Joined: Sat May 03, 2008 12:25 am
Location: New York

Postby benhall » Tue May 06, 2008 2: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.

Posts: 69
Joined: Fri Dec 14, 2007 10:15 am

Return to SQL Data Generator Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests