jarulraj/sqlcheck

Sqlcheck does not show line number on which hint or antipattern is reported

KetkiT opened this issue · 0 comments

Sqlcheck does not show line number on which antipattern or hint is reported . Currently it gives following format

[D:\temp_func.sql]: (LOW RISK) (QUERY ANTI-PATTERN) Spaghetti Query Alert
[Matching Expression: ]

[D:\temp_func.sql]: (LOW RISK) (QUERY ANTI-PATTERN) UNION Usage
[Matching Expression: union]

can it give line no as well ?
e.g . [D:\temp_func.sql]: (LOW RISK) (QUERY ANTI-PATTERN) UNION Usage
[Matching Expression: union] [34]

This becomes very useful when it is a huge file. With line number (starting position of the query) you can directly navigate to the specific query.

Line number are very common in all code checker , as they give better user experience .

Should line number be added here?

Thanks