2.0.2
Fixed
update,delete,incrementanddecrementwith anorderByand alimitoroffsetnow touch the records that order selects. Before, when no index served the order, they picked records by key instead.- A limited write through several keys, such as
whereIn('id', [1, 2, 3]).limit(1).delete(), now stops at the limit instead of touching every match.
Upgrading
Ordered writes with a limit or offset may now change or delete different records than they did in 2.0.1. Check any code that relied on the old behavior.