Multiple Issues on the same line are hidden

BrienKing

If your SQL has multiple rule violations, it only shows one of the rules. It should show ALL the rule violations.

Tianjiao_Li

Hi @BrienKing

Thanks for posting.

It sounds a bug to us. Would you mind to send in a sample script to reproduce?

Thanks.

BrienKing

ok, it may not necessarily be a bug, but less intuitive than what I was expecting.

Do something simple like:

SELECT * FROM Customers

This will show squiggly lines under the * and "Customers".  The light bulb is position sensitive which makes it appear to hide the other issue.

Tianjiao_Li

Hi @BrienKing

I can't reproduce it in the latest Prompt, can you please upgrade and test again?

Thanks.

BrienKing

I am on the latest.  My clarification stated that it's not a bug, just not as intuitive as I was expecting.  You have to put the cursor on the issue for the Bulb to show you that specific issue.  It would be nice if the bulb also had a list of other issues (if more than one for that line).

RichardL

Hi @BrienKing

Thanks for your posts. 

You can always make suggestions for future version on our SQL Prompt Uservoice page in my link below. 

https://redgate.uservoice.com/forums/94413-sql-prompt

Have a good weekend! 

Richard Lynch.