Skip to content

feat: add support for negative primary keys #689

@devioarts

Description

@devioarts

Is your feature request related to a problem? Please describe:

Sometimes i need to insert record with negative primary ID, but plugin says "Run: RunSQL: lastId < 0", SQLite itself has no problem with this. Its frustrating because I cant use primary key and need to control data manualy.

Describe the solution you'd like:

Will be nice to have possibility to insert negative primary ID

Describe alternatives you've considered:

For now I'm creating table without primary ID and checkign data manualy, to not have duplicate entries

Additional context:

CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, user_name TEXT);
INSERT INTO `users` (`id`,`user_name`) VALUES(-1, "Admin")

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions