Ticket #760 (assigned defect)

Opened 3 years ago

Last modified 3 years ago

Autoincrementing primary keys for sqlite3

Reported by: Jonttu Owned by: andrew
Priority: minor Milestone: 1.0
Component: databaseapi Version: 0.7.3
Keywords: sqlite3 autoincrement primary key Cc:

Description

Sqlite3 re-uses primary keys by default. If a row is deleted, the next one will use the same id. This is bad and AFAIK other dbms always increment the primary key by default.

This can be fixed for sqlite3 by explicitely giving the autoincrement keyword for the primary key column.

Change History

comment:1 Changed 3 years ago by Jonttu

comment:2 Changed 3 years ago by andrew

  • Status changed from new to assigned
  • Milestone set to 1.0
Note: See TracTickets for help on using tickets.