Ofer Inbar wrote:
It appears to be an article for perl programmers not familiar with MySQL, warning them of MySQL quirks they should be aware of. If you write a perl script with DBD::MySQL and try one of the examples he gave, and check your return status to see if the statement succeeded, does it appear to have succeeded? If so, unless you're very familiar with MySQL specifically, you probably wouldn't think to look for warnings, and parse them, just to make sure that the statement that succeeded actually did what it was supposed to do. Definitely a potential pitfall that someone writing perl scripts for MySQL needs to be aware of and know how to work around. -- Cos
Or it could be seen as an article for someone used to other databases. Most other databases will throw hard errors in similar cases, not a warning, and roll back the transaction. MySQL's handling of errors in this case as warnings is really a leftover from the MyISAM days, where it was done as the perceived least bad option for error handling in a transaction-less environment. As MySQL tries to move into the full featured RDBMS world, it's pretty clearly not a feature. I hardly think (as someone else said) this is anyone with an axe to grind.
Paul -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]