Exact match confusion with object names and square brackets
kevriley
Posts: 129 Gold 1
Against a copy of AdventureWorks2008R2, search for
[EMP_cte].OrganizationNode
with 'Exact match' unticked : this returns 2 results uspGetEmployeeManagers and uspGetManagerEmployees, and highlights the code accordingly (even though the code actually uses [] around the object names - this is a Good Thing.
Now tick 'Exact match', and although the results are the same, there is now no highlighting
Using SQL Search 2.0.1.28, in SSMS 2008R2 (10.50.4000.0), against a SQL2008 database (compat level 100)
[EMP_cte].OrganizationNode
with 'Exact match' unticked : this returns 2 results uspGetEmployeeManagers and uspGetManagerEmployees, and highlights the code accordingly (even though the code actually uses [] around the object names - this is a Good Thing.
Now tick 'Exact match', and although the results are the same, there is now no highlighting
Using SQL Search 2.0.1.28, in SSMS 2008R2 (10.50.4000.0), against a SQL2008 database (compat level 100)
Comments
I have been able to replicate the issue using the steps you described. I'll escalate this issue to the developers.
Thanks very much for the information!
Redgate Software
Redgate Software
If not, I have: Exact match highlights Receive - it shouldn't.
OOPS!
Decide wisely...
Not yet, I'm afraid. I've added a note on our system to say that you have also hit the bug.
Apologies.
Redgate Software