CONVERT() - data type is wrongfully parsed as a column

[wheredevel]

SELECT CONVERT(int, a) FROM A

Actual Behavior

int - Column

Expected Behavior

int - ColDataType

Steps to Reproduce the Problem

Specifications

Note

This is fixed and PR pending.

[wumpz]

I would say it's by design. Jsqlparser is only a parser and cannot differ between column, identifier, typename, ... Why not leave it like it is and do the semantics later. Maybe we should rename Column to DBidentifier.

[wumpz]

It is the special definition of the convert function that could be very different on other dB systems.

[wheredevel]

Well, if we had a way to indicate the dialect the parser ahead - that would solve it.
For now, we just need it to parse this MSSQL dialect properly. (MySQL's is similar.)
So, we implemented this.