Sqlcheck does not show line number on which hint or antipattern is reported
KetkiT opened this issue · 0 comments
KetkiT commented
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