SqlBeautifier
SqlBeautifier copied to clipboard
No indent?
Sometimes code doesn't get indented at all.
For example, this valid Sql statement (MySql):
select *
from setup.trans_bases t
join setup.hier_bases_total b on b.azienda=t.azienda
and b.idhier_bases=t.idhier_bases_start
and year(b.fine_validita)=9999
join setup.hier_bases_total b1 on b1.azienda=t.azienda
and b1.idhier_bases=t.idhier_bases_end
and year(b1.fine_validita)=9999
where t.idtrans_anag=7;
..after SQL Beautifier, remains the same.
My user preferences:
{
"keyword_case": "lower",
"identifier_case": "lower",
"strip_comments": false,
"indent_tabs": false,
"indent_width": 4,
"reindent": true
}
Sublime Text 3, build 3083.
Thank you!
I can confirm, but I think it isnt an actual issue, maybe just an enhancement.
If you use () it gets indented:
SELECT *
FROM setup.trans_bases t
JOIN setup.hier_bases_total b ON (b.azienda=t.azienda
AND b.idhier_bases=t.idhier_bases_start
AND year(b.fine_validita)=9999)
JOIN setup.hier_bases_total b1 ON (b1.azienda=t.azienda
AND b1.idhier_bases=t.idhier_bases_end
AND year(b1.fine_validita)=9999)
WHERE t.idtrans_anag=7;
I have the same settings and it is also not indenting my code too, even adding parenthesis as suggested above will make it work :|