[FORMATTING] Formatter15.4.11 inserts space in between # operator in mysql dialect

[laoli1968]

Input data

Which SQL and options did you provide as input?

select con#,obj#,rcon#,enabled,nvl(defer,0),spare2,spare3,refact from cdef$ where robj#=:1 for update

Expected Output

select con#,obj#,rcon#,enabled,nvl(defer,0),spare2,spare3,refact from cdef$ where robj#=:1 for update

Actual Output

select con #,obj#,rcon#,enabled,nvl(defer,0),spare2,spare3,refact from cdef$ where robj#=:1 for update

Usage

• How are you calling / using the library?
• What SQL language(s) does this apply to?
• Which SQL Formatter version are you using?

[nene]

This is as expected because # character starts a comment in MySQL.

MySQL documentation for identifiers also doesn't include # character as being allowed in unquoted identifiers.

Are you actually using MySQL? Or are you attempting to format some other SQL dialect as MySQL?