Reshift dialect doesn't understand CONVERT function

[pdebelak]

Search before asking

• I searched the issues and found no similar issues.

What Happened

The redshift dialect thinks the data type identifier in the CONVERT function (see CAST and CONVERT docs) is a column identifier which can cause spurious lint errors.

Expected Behaviour

The CONVERT function is correctly parsed with a data type identifier and a column identifier.

Observed Behaviour

The CONVERT function is parsed as having two column identifier arguments.

How to reproduce

You can see the L027 rule failure is due to integer being parsed as a column identifier, not a data type identifier.

$ echo 'SELECT
    sellers.name,
    CONVERT(integer, sales.pricepaid) AS price
FROM sales
LEFT JOIN sellers ON sales.sellerid = sellers.sellerid
WHERE sales.salesid = 100;' | sqlfluff lint --dialect redshift -
== [stdin] FAIL                                                                                                                            
L:   3 | P:  13 | L027 | Unqualified reference 'integer' found in select with
                       | more than one referenced table/view.
All Finished 📜 🎉!

Dialect

Redshift

Version

sqlfluff, version 1.1.0
Python 3.9.13

Configuration

None

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

[pdebelak]

Fixed in #3653