SqlBeautifier icon indicating copy to clipboard operation
SqlBeautifier copied to clipboard

No indent?

Open eleftrik opened this issue 9 years ago • 2 comments

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!

eleftrik avatar Oct 02 '15 07:10 eleftrik

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;

lwrbakro avatar Dec 15 '15 16:12 lwrbakro

I have the same settings and it is also not indenting my code too, even adding parenthesis as suggested above will make it work :|

renatoargh avatar Feb 06 '17 11:02 renatoargh