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
DECLARE
profit NUMBER(38, 2);
revenue NUMBER(38, 2);
cost NUMBER(38, 2);
BEGIN
let profit := revenue - cost;
RETURN profit;
Expected Output
I would expect sql-formatter to honor the := symbol for Snowflake.
Actual Output
Parse error at token: = at line 6 column 13 <-- notice the space in the token.
Unexpected OPERATOR token: {"type":"OPERATOR","raw":"=","text":"=","start":91}. Instead, I was expecting to see one of the following:
A LINE_COMMENT token based on: ...
A BLOCK_COMMENT token based on: ...
A DISABLE_COMMENT token based on: ...
Etc etc.
Usage
let serverLanguage: SqlLanguage='snowflake';formattedSql=format(sqlText,{language: serverLanguage,tabWidth: 2,keywordCase: 'upper',linesBetweenQueries: 1,});
Version: "sql-formatter": "^15.4.1"
The text was updated successfully, but these errors were encountered:
Input SQL
Expected Output
I would expect sql-formatter to honor the := symbol for Snowflake.
Actual Output
Usage
Version: "sql-formatter": "^15.4.1"
The text was updated successfully, but these errors were encountered: