SQlite3 multi-column UNIQUE INDEX not having expected effect

QuestionsSQlite3 multi-column UNIQUE INDEX not having expected effect
sethbeckerman5 Staff asked 4 years ago

I have a unique constraint on one of my tables:

You can see it is part of the db definition here:

But for some reason it is still allowing multiple entries which share all of their values. Notice the last three items below:

Am I misunderstanding what a multi-column unique index is supposed to do? In not, why did SQLite allow me to add items that break these rules?


View on Stack Overflow