antares icon indicating copy to clipboard operation
antares copied to clipboard

Ommit "unique,autoincrement" column in copy as sql and export as sql

Open D-nov opened this issue 2 years ago • 0 comments

Describe the bug When you copy as sql (to duplicate multiple rows for example) it includes autoincremented unique columns which results in duplicate ids exception

To Reproduce Create autoincrement unique column. Insert rows, copy as sql the rows, execute query.

Expected behavior Autoincrement columns are handled by the sql and not included in the query.

Application (please complete the following information):

  • App client [e.g. MySQL]

Additional context Maybe make it optional with somekind of checkbox as including these columns might be required sometimes...

D-nov avatar Aug 01 '22 09:08 D-nov