David Brodbeck wrote:
The client software ought to be range-checking the data before sending
it to
the database. If the client isn't even doing that kind of minimal-effort
check, how likely is it to be checking for exceptions?
That's not to say that an error or exception is a bad idea, but MySQL may be
constrained here by what the SQL standard says to do; I'm not sure.
I'm not sure what the sql standard says on the matter, but Oracle, DB2
and Postgres would through an exception. In fact, there is a page on
MySQL "gotachs" to document MySQL behaviour when it differs
significnatly from other databases (like the first datetime field in a
table getting a value if none is provided during insert).
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]