ITADN

any join syntax with clickhouse moves up to the previous line

#706Closedcamerondavison 创建于 2025-09-26
bug
C
camerondavisoncommented
**Describe the bug** Doing any joins in clickhouse put the join keywords on the line above. I find it helpful to have the join modifier keywords on the same line. **To Reproduce** Given the follow clickhouse dialect sql ``` [tool.sqlfmt] dialect = "clickhouse" ``` ```sql select color_of_the_garden, plant_in_the_garden, place_in_the_garden from garden_full_of_flowers left any join bugs_in_the_garden on (garden_full_of_flowers.place = bugs_in_the_garden.place) ``` **Expected behavior** ```sql select color_of_the_garden, plant_in_the_garden, place_in_the_garden from garden_full_of_flowers left any join bugs_in_the_garden on (garden_full_of_flowers.place = bugs_in_the_garden.place) ``` **Actual behavior** ```sql select color_of_the_garden, plant_in_the_garden, place_in_the_garden from garden_full_of_flowers left any join bugs_in_the_garden on (garden_full_of_flowers.place = bugs_in_the_garden.place) ``` It moved the "left any" up to the line above. **Additional context** I am using this with precommit ``` - repo: https://github.com/tconbeer/sqlfmt rev: v0.27.0 hooks: - id: sqlfmt language_version: python additional_dependencies: ['.[jinjafmt]'] ```
关闭于 2025-10-17 7 条评论