[FORMATTING] % modulo formatting causes parse error - Githubissues

sql-formatter-org / sql-formatter

A whitespace formatter for different query languages

https://sql-formatter-org.github.io/sql-formatter/

MIT License

2.36k stars 405 forks source link

[FORMATTING] % modulo formatting causes parse error #699

Closed avishj closed 10 months ago

avishj commented 10 months ago

Input data

Which SQL and options did you provide as input?

SELECT title FROM movies WHERE year % 2 = 0;

Expected Output

SELECT
    title 
FROM 
    movies 
WHERE 
    year % 2 = 0;

Actual Output

SELECT title FROM movies WHERE year % 2 = 0;

It errors out: Unable to format SQL: Error: Parse error: Unexpected "% 2 = 0;"

Usage

How are you calling / using the library?
Called via Prettier SQL VSCode
What SQL language(s) does this apply to?
TSQL or any other which uses % for modulus operation in expressions.
Which SQL Formatter version are you using?
v1.6.0

nene commented 10 months ago

Simply configure the dialect as Transact-SQL. See the FAQ.

Also, the Prettier SQL VSCode extension is no more maintained.