How do I set unique constraint over multiple column when any one can be null in sqlite?
e.g. I have made unique("col1","col2","col3") and tried with insert into tablename values("abc","def",null)
twice it hase inserted both rows. The unique constraint is not working when third column is null.