I am trying to select some with lock and use select for update with where clause. Should I check in my service that this where actually worked? I mean, is this right order?

• Raw is selected using where clause
• Waiting for lock (in another transaction raw changed and where clause is wrong now)
• Acquire lock and return rows

And how can I check this behaviour?

CodePudding user response：

The query is guaranteed to return only rows that satisfy the WHERE condition.