turso icon indicating copy to clipboard operation
turso copied to clipboard

`INSERT` does not add duplicate rows

Open penberg opened this issue 1 year ago • 1 comments

SQLite:

sqlite> CREATE TABLE users (id INT, username TEXT);
sqlite> INSERT INTO users VALUES (1, 'penberg');
sqlite> INSERT INTO users VALUES (1, 'penberg');
sqlite> SELECT * FROM users;
1|penberg
1|penberg

Limbo:

limbo> INSERT INTO users VALUES (1, 'penberg');
limbo> INSERT INTO users VALUES (1, 'penberg');
limbo> SELECT * FROM users;
|penberg
limbo>

penberg avatar Aug 01 '24 17:08 penberg

Seems it will work as expected when this PR is merged

seonWKim avatar Aug 16 '24 13:08 seonWKim

This works as expected on the main branch. @penberg this can be closed

arpit-saxena avatar Sep 29 '24 20:09 arpit-saxena