[MXS-1974] select ... for update should route to all Created: 2018-07-12 Updated: 2018-07-12 Resolved: 2018-07-12 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | readwritesplit |
| Affects Version/s: | 2.2.11 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | dapeng huang | Assignee: | Unassigned |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | None | ||
| Description |
|
`select ... for update` will hold x locks preventing write on target rows, but with readwrite split it not works; so we need route it to all; and `start transaction` and `commit` should route to all too; |
| Comments |
| Comment by markus makela [ 2018-07-12 ] |
|
SELECT FOR UPDATE should be routed where the current transaction is routed. This is already routed to the master where it matters for transaction execution. As the documentation states, it has no effect outside of a transaction. |
| Comment by markus makela [ 2018-07-12 ] |
|
This is expected and desired behavior, closing as Not a Bug. |