Data Generation NEXTVAL does not publish from 1 in Datamaker

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Using the following function in any numeric column:

@nextval(td1,1)@

Although set to 1, it always publishes into the database with a 2 to start.

 

Does 'nextval' actually have a starting value of 1?

 

Environment

Test Data Manager (TDM)- Datamaker 4.2 / TDM Portal

Resolution

When creating a new nextval starting with 1, in the process of resolving the expression to check its validity, it gets incremented to 2.

 

Additional Information

https://docops.ca.com/ca-test-data-manager/4-2/en/reference/data-generation-functions-and-parameters