Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[bug] Unique index (Primary Key) is not working in the example. #530

Closed
uds5501 opened this issue Dec 21, 2024 · 1 comment
Closed

[bug] Unique index (Primary Key) is not working in the example. #530

uds5501 opened this issue Dec 21, 2024 · 1 comment
Labels
bug Something isn't working compat

Comments

@uds5501
Copy link

uds5501 commented Dec 21, 2024

Extending the example given in the readme, I attempted the following -

Limbo v0.0.10
Enter ".help" for usage hints.
limbo> CREATE TABLE users (id INT PRIMARY KEY, username TEXT);
limbo> INSERT INTO users VALUES (1, 'alice');
limbo> INSERT INTO users VALUES (1, 'abra'); // should've failed.
limbo> select * from users;
1|alice
1|abra

This should've failed to insert (1, 'abra') due to unique constraint but it didn't.
Would be happy to pick the fix if it's indeed an error btw :)

@penberg penberg added bug Something isn't working compat labels Dec 21, 2024
@jussisaurio
Copy link
Collaborator

Duplicate of #472

@jussisaurio jussisaurio marked this as a duplicate of #472 Dec 21, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working compat
Projects
None yet
Development

No branches or pull requests

3 participants