[MXS-4952] Doubled quotes inside quoted strings do not collapse correctly when canonicalizing query strings Created: 2024-01-23 Updated: 2024-01-29 Resolved: 2024-01-29 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | Core |
| Affects Version/s: | 6.4.13, 22.08.11, 23.02.8, 23.08.4 |
| Fix Version/s: | 24.02.0 |
| Type: | Bug | Priority: | Minor |
| Reporter: | markus makela | Assignee: | markus makela |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Description |
|
For a query like this:
The canonical version currently is:
The correctly "collapsed" canonical would be:
This is because there's only one SQL value in the string. The practical effects of this are fairly minimal and the effects of this usually are mainly in less efficient use of the qc_cache. For the QLA filter, it might be a more of a nuisance as the same logical query might end up with a different canonical query string. |