Re: [sqlite] Feature Request: More descriptive error message to replace "Constraint Failed."

2009-11-30 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Shaun Seckman (Firaxis) wrote:
> It would be extremely useful if this
> error message could contain more information such as which constraint
> failed and even perhaps the data which caused the constraint to fail.
> Even just knowing the column names would be a huge help to debugging
> such errors.

A known issue with a ticket since January 2006:

  http://www.sqlite.org/src/tktview?name=23b2128201

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAksUa0kACgkQmOOfHg372QRicwCeLIt6Jgb9oGfcrsHhybbjIntr
rGAAn2PUV8+kvZMIaNhLlhtQpR6efGAz
=R4YZ
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] Feature Request: More descriptive error message to replace "Constraint Failed."

2009-11-30 Thread Shaun Seckman (Firaxis)
Hello everyone,

I've recently stumbled across a plethora of "Constraint
Failed" errors in my code due to a schema change that modified various
columns of tables to be unique.  It would be extremely useful if this
error message could contain more information such as which constraint
failed and even perhaps the data which caused the constraint to fail.
Even just knowing the column names would be a huge help to debugging
such errors.

 

What do you guys think?

 

-Shaun

 

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users