[MXS-4434] SET STATEMENT variables are not ignored when statements are classified Created: 2022-12-07 Updated: 2022-12-13 Resolved: 2022-12-07 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | qc_sqlite |
| Affects Version/s: | 22.08 |
| Fix Version/s: | 22.08.4 |
| Type: | Bug | Priority: | Major |
| Reporter: | Johan Wikman | Assignee: | Johan Wikman |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Sprint: | MXS-SPRINT-172 |
| Description |
|
Currently the statement
is classified like QUERY_TYPE_READ|QUERY_TYPE_GSYSVAR_WRITE, which will cause it to be sent to all servers. However, as the variable changes caused by SET STATEMENT are effective only for the duration of the specified statement, they should simply be ignored and the whole statement classified as QUERY_TYPE_READ. |