When using SQL and update, the primary_key ( id ) value goes back to 1 after it hits 50

benkeen / generatedata

A powerful, feature-rich, random test data generator.

https://generatedata.com

2.2k stars 611 forks source link

When using SQL and update, the primary_key ( id ) value goes back to 1 after it hits 50 #834

Closed 0deuce0 closed 1 year ago

0deuce0 commented 1 year ago

Example:

UPDATE myTable SET empid = "WWN-163687" WHERE id = 48; UPDATE myTable SET empid = "GQV-634639" WHERE id = 49; UPDATE myTable SET empid = "DDL-735258" WHERE id = 50; UPDATE myTable SET empid = "LDI-646246" WHERE id = 1; UPDATE myTable SET empid = "KKU-473544" WHERE id = 2; UPDATE myTable SET empid = "YKU-379575" WHERE id = 3;

benkeen commented 1 year ago

Gah, you're absolutely right, apologies. I'll patch it in the next release.