On 25 Sep 2011, at 9:46pm, Petite Abeille wrote: > On Sep 25, 2011, at 10:29 PM, Roger Binns wrote: > >>> Would there be a way, in a future version of SQLite, to provide more >>> informative constraint violation messages? Or is that just not feasible, >>> implementation wise? Or? >> >> http://www.sqlite.org/src/tktview?name=23b2128201 > > Right. That ticket is sitting there, unloved, since 2006-Jan-30 :( > > http://www.youtube.com/watch?v=rwp60eYuie0 > > Any reason for the lack of love? E.g. "If it was hard to validate, it should > be hard to understand what failed"?!?
That is the reason which has been previously given. The various constraints are combined and expressed in a way which is considerably different from the form they were specified in. Figuring out which one was violated requires a whole other procedure. You'd also have people start depending on a set of priorities of what happens of two constraints were violated by the same statement. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
