[MXS-1137] Cache: Handle variables Created: 2017-02-10 Updated: 2017-03-02 Resolved: 2017-03-02 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | cache |
| Affects Version/s: | None |
| Fix Version/s: | 2.1.1 |
| Type: | Task | Priority: | Major |
| Reporter: | Johan Wikman | Assignee: | Johan Wikman |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Epic Link: | Cache Improvements |
| Sprint: | 2017-29 |
| Description |
|
The cache key is effectively the entire SELECT statement. However, the value of any variables used in the select is not considered. For instance, if a variable is used in the WHERE clause of the select, a subsequent identical select will return the wrong result, if the value of the variable has been changed in between. The value of variables should either be tracked or then if variables are used, the statement should not be cached. |