4 ms·
Wow, what a bunch of MySQL apologist fluff, and half-hearted attempts to prove the authors own point. For example: "PostgreSQL rolls back the entire transactio
by bsg75 13y ago
Wow, what a bunch of MySQL apologist fluff, and half-hearted attempts to prove the authors own point. For example:
"PostgreSQL rolls back the entire transaction when it encounters a syntax error. MySQL only cancels the statement.
Now, PostgreSQL is within its rights -- the standard says that an implementor may do an "implicit rollback" for an error."
may do an implicit rollback - the standards do not even apply to this argument.
You could replace PostgreSQL in this post with any of MSSQL, Oracle, DB2, or similar, and find standards that are applied in one but not the other.