search

PabloRMira / sql_formatter

A Python based SQL formatter
https://pablormira.github.io/sql_formatter/
Apache License 2.0
43 stars 10 forks source link

Extra white space in CASE WHEN statements #160

Open bw-tech opened 3 years ago

bw-tech commented 3 years ago

Describe the bug

CASE WHEN statements that are longer than 82 characters create new lines that are severely indented.

To Reproduce

Have a CASE WHEN statement with the WHEN clause being 82 characters are longer.

Expected behavior

Not having the new formatted lines being indented beyond the previous lines.

I think the issues is the reformat_too_long_line method in core.py. Looks like there could be issues with the out_list list.

PabloRMira commented 3 years ago

Could you please provide a complete example to reproduce?

See https://github.com/PabloRMira/sql_formatter/issues/161 for an example

Then I could add it to the tests :-)