mozilla/datazilla — pull request #70 by jeads (2012-10-11 21:18:54+00:00)
Title: added ORDER BY clause to unsafe UPDATE

In SQL an UPDATE with a LIMIT but no ORDER BY clause is unsafe because the query may produce different results each time it is applied even on identical data sets. In the case of this particular query it doesn't cause a real problem but it does produce an annoying warning message in the log.