[MXS-4596] Query canonicalization does not work on scientific numbers Created: 2023-04-26  Updated: 2023-05-10  Resolved: 2023-05-10

Status: Closed
Project: MariaDB MaxScale
Component/s: Core
Affects Version/s: 6.4.6, 22.08.5, 23.02.1
Fix Version/s: 6.4.7, 22.08.6, 23.02.2

Type: Bug Priority: Major
Reporter: markus makela Assignee: Niclas Antti
Resolution: Fixed Votes: 0
Labels: None


 Description   

Can be tested with:

maxctrl classify 'select 1e10'

The result is select 1e10 when it should be select ?.

In addition, only the lowercase e is detected: MariaDB accepts both uppercase and lowercase e as the exponent character. This also appears to be a problem in 2.5 but otherwise scientific numbers are handled correctly by that version.


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