You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Describe the bug Snowflakes RLIKE has two valid syntaxes. When formatting a Snowflake SQL script that uses the first syntax mentioned in the documentation, sqlfmt adds a whitespace between E and (.
To Reproduce
Format the following: select rlike('foo', 'bar') from dual;
Expected behavior
select rlike('foo', 'bar')
from dual
;
Actual behavior
select rlike ('foo', 'bar')
from dual
;
Additional context
sqlfmt, version 0.19.2
The text was updated successfully, but these errors were encountered:
I'm not going to tackle this right now -- because of how the lexer and parser work, it's non-trivial to distinguish between rlike('foo, bar') and rlike('foo', 'bar') when these tokens are lexed, which unfortunately determines the presence or absence of whitespace between the function or operator name and the parenthesis.
Describe the bug
Snowflakes RLIKE has two valid syntaxes. When formatting a Snowflake SQL script that uses the first syntax mentioned in the documentation, sqlfmt adds a whitespace between
E
and(
.To Reproduce
Format the following:
select rlike('foo', 'bar') from dual;
Expected behavior
Actual behavior
Additional context
sqlfmt, version 0.19.2
The text was updated successfully, but these errors were encountered: