What are the challenges you face when working across database platforms? Take the survey

Issue with generating unique values by pattern

DAndres109@aol.comDAndres109@aol.com Posts: 22 Bronze 2

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


Sign In or Register to comment.