Closed tconbeer closed 1 month ago
Describe the bug interval is sort of a word operator, but is being parsed as a function.
interval
To Reproduce select '2024-03-19' + interval (case when false then 1 else 0 end) day
select '2024-03-19' + interval (case when false then 1 else 0 end) day
Expected behavior no-op
Actual behavior select '2024-03-19' + interval(case when false then 1 else 0 end) day
select '2024-03-19' + interval(case when false then 1 else 0 end) day
Additional context What is the output of sqlfmt --version? 0.21.3
sqlfmt --version
What is the output of pip list (or pipx list if you installed using pipx)?
pip list
pipx list
Describe the bug
intervalis sort of a word operator, but is being parsed as a function.To Reproduce
select '2024-03-19' + interval (case when false then 1 else 0 end) dayExpected behavior no-op
Actual behavior
select '2024-03-19' + interval(case when false then 1 else 0 end) dayAdditional context What is the output of
sqlfmt --version? 0.21.3What is the output of
pip list(orpipx listif you installed using pipx)?