[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:

SELECT '''''''''';

The canonical version currently is:

SELECT ?????;

The correctly "collapsed" canonical would be:

SELECT ?;

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.


Generated at Thu Feb 08 04:32:20 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.