Skip to content

feat: add support for negative primary keys #689

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")

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

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