Eric Bergen wrote:
With innodb as the default storage engine drizzle can handle multi row and single row inserts the same way. If it errors on a single row and rolls back the statement it should also error on mutli row and roll back the statement. I'm not sure what the standard says about null handling though. I prefer if I say not null and try to insert a null value that it error and rollback the statement.
Any exception should cause the statement to fail and roll back any previous actions within the statement...
There are also some exceptions that cause transaction rollback. The SQL standard defines "Serialization error" and a few others (?), but implementations are allowed to define their own additional ones.
Thanks, Roy _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
