> What if I need to make FOR UPDATE for a query with a limit clause? Limit > seems not to allow plain string as an argument. Am I in trouble? :)
With the existing workaround possibilities, yes. The last thing you could try is to make nested selects. I don't know if MySQL will like that. But you could have the inner select apply the LIMIT and the outer select apply the FOR UPDATE. Or vice versa. If that doesn't work and if this is urgent, I recommend patching AbstractResultProviderSelectQuery.toSQLReference() for this. That's the single central place, where a SELECT statement's SQL is created...
