How can we help you today? How can we help you today?

Exact match confusion with object names and square brackets

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)
kevriley
0

Comments

4 comments

Sort by
  • 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
    0
  • Rob C
    I have logged the bug in our bug tracking system as SDI-653. Thanks once again for bringing this to our attention.
    Rob C
    0
  • PDinCA
    Has the fix made it into the wild?

    If not, I have: 
    [ReceivedQuantity] FLOAT NULL
    Exact match highlights Receive - it shouldn't.

    OOPS!
    PDinCA
    0
  • 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.
    Rob C
    0

Add comment

Please sign in to leave a comment.