Hi,
when a named constraint is violated, the name of the constraint which actually
failed is not included in the error message.
Example 1:
create table con (
a text constraint must_not_be_null not null);
insert into con values (null);
Returns error "con.a may not be null".
Example 2:
create table con (
a text
constraint must_not_be_null check (a not null));
insert into con values (null);
Returns error "constraint failed".
Especially with many constraints in place, constraint names can be really
helpful to fulfill the constraint. In this regard, error message 2 in
particular is not helpful at all in fixing the violation.
It would therefore be nice if error messages could include the name of the
constraint that failed.
Also nice to have: If multiple constraints fail at the same time, mention all
failing constraints and their names in a single error message.
Ralf
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
