Re: [sqlite] Feature request: Report constraint name(s) in error message
Roger Binns wrote: >> when a named constraint is violated, the name of the constraint which >> actually failed is not included in the error message. > >There has been a ticket about this for over 3 years, and also includes a >patch to fix it: > > http://www.sqlite.org/cvstrac/tktview?tn=1648 Thanks, the ticked escaped my notice. Given that there is a patch suggestion already, let's hope that it will eventually make it into the SQLite core. Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Feature request: Report constraint name(s) in error message
Ralf Junker wrote: > when a named constraint is violated, the name of the constraint which > actually failed is not included in the error message. There has been a ticket about this for over 3 years, and also includes a patch to fix it: http://www.sqlite.org/cvstrac/tktview?tn=1648 Roger ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Feature request: Report constraint name(s) in error message
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