Exact match confusion with object names and square brackets

kevriley

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)

Rob C

Hi,

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!

Rob C

I have logged the bug in our bug tracking system as SDI-653. Thanks once again for bringing this to our attention.

PDinCA

Has the fix made it into the wild?

If not, I have:

[ReceivedQuantity] FLOAT NULL

Exact match highlights Receive - it shouldn't.

OOPS!

Rob C

PDinCA wrote:

Has the fix made it into the wild?

Not yet, I'm afraid. I've added a note on our system to say that you have also hit the bug.

Apologies.