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

Possible Bug with fields called propertyname

First of all, REALLY LIKE THE PRODUCT.

however, I thought you might like to know about this one.

It seems like an edge condition that might have gotten through the system.

Here is the situation

Run the following SQL Script
CREATE TABLE test(PropertyName VARCHAR(30));

after the table has been created type the following sql
SELECT COUNT(*),propertyname
FROM [test]
GROUP BY p

after you type the final "p" let the intellisence pop up to display "propertynane" as the suggested entry.
Hit enter or tab, what ever is configured to insert the suggested text.

When I do this an Unhandled .Net exception is thrown. I am, however, able to continue using SQL Prompt without restarting.

2k5 Sql Management Studio sp 1 on Windows XP sp2

ADDENDA:
further examination seems to indicate that the "incorrect case" of the field in the select clause might be the culprit and not necessarily a field called "propertyname"
Was able to reproduce the same with a field called "userid"
Thanks,
kepr00
0

Comments

1 comment

  • Tilman
    Hi Steve,

    Thanks for reporting this. I wasn't able to reproduce the problem in the latest version of the product, so let's hope it has been fixed already.

    Regards,

    Tilman
    Tilman
    0

Add comment

Please sign in to leave a comment.