MySQL: Bug with rules LT02, LT05

[gualtfor]

Search before asking

• I searched the issues and found no similar issues.

What Happened

I have a query in MySQL and when apply the line sqlfluff fix extraction_notification.sql --rules CP01 --dialect ansi appear an error with LT02 y LT05

Expected Behaviour

There are not critical errors

Observed Behaviour

CRITICAL [LT02] Applying rule LT02 to 'C:\\Users\\Documents\\extraction_notification.sql' threw an Exception: can't multiply sequence by non-int of type 'str' TypeError: can't multiply sequence by non-int of type 'str'

CRITICAL [LT05] Applying rule LT05 to 'C:\\Users\\Documents\\extraction_notification.sql' threw an Exception: can't multiply sequence by non-int of type 'str' TypeError: can't multiply sequence by non-int of type 'str'

How to reproduce

the steps are:
1- Run the syntax:
sqlfluff fix extraction_notification.sql --rules CP01 --dialect ansi

2- check the query:
SELECT noti.public_id AS 'public_id', co.name AS 'empresa', inv.reference_number AS 'referencia' FROM core.notification noti INNER JOIN core.customer co ON noti.customer_id = co.customer_id LEFT JOIN core.invoice inv ON inv.invoice_id = noti.object_related_id AND noti.object_related = 'invoice'

Dialect

mysql

Version

sqlfluff, version 3.0.6

Configuration

[sqlfluff]
dialect = ansi

[sqlfluff:indentation]
tab_space_size = 4,
indented_joins = True,
indented_using_on = False,
template_blocks_indent = True

[sqlfluff:rules:capitalisation.keywords]
capitalisation_policy = upper

Are you willing to work on and submit a PR to address the issue?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct