Repository navigation
bug: lastId < 0 when id INTEGER PRIMARY KEY #687
Description
Plugin version:
8.0.1
Platform(s):
web
Current behavior:
when I run a query where PRIMARY KEY is, for example, -1, it gives the error "Run: RunSQL: lastId < 0"
Expected behavior:
return -1 as lastId
Steps to reproduce:
- create table users
- try to insert row with negative id
Related code:
CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, user_name TEXT);
INSERT INTO `users` (`id`,`user_name`) VALUES(-1, "Admin")Other information:
SQLite itself has no problem with this
Capacitor doctor:
npx cap doctor
💊 Capacitor Doctor 💊
Latest Dependencies:
@capacitor/cli: 8.3.0
@capacitor/core: 8.3.0
@capacitor/android: 8.3.0
@capacitor/ios: 8.3.0
Installed Dependencies:
@capacitor/cli: 8.1.0
@capacitor/core: 8.1.0
@capacitor/android: 8.1.0
@capacitor/ios: 8.1.0
[success] Android looking great! 👌
[success] iOS looking great! 👌
Activity
robingenz commentedon Mar 27, 2026
Thank you! This is the expected behaviour in this plugin for now. Feel free to submit a feature request to add support for negative primary keys, but this isn’t a bug.