Suggestions are broken in Release 10.0.1.12389

Dave Pendleton

Suggestions are broken in several instances in 10.0.1.12389.

Suggestions are offered when a literal string is input. For example, I've just typed the string 'DB', when I hit the space bar to continue, the suggestion "dbo" is inserted in place of my typed string.


I use the AT TIME ZONE clause dozens of times a day. When I type my time zone (Central Standard Time), suggestions are offered alphabetically, and when I hit the space bar to advance to type the word "Standard", the suggestion "AUS Central Standard Time" is inserted. 


Please capitalize the word "AT" also...

This has been broken for some time, but when using the unicode cast, "N", an extra single quote is added to the end of the string. when a single quote is typed For example, when I type N' the terminating ' is added making N'' without the N present typing another ' will just advance the cursor. With the N present, another single quote is added. Furthermore, a suggestion is offered and the space bar replaces my string of N'DB' with "dbo"


This all started in some fashion with ranked suggestions which work terribly when the space bar is configured to add the suggestion, as mine is.  Get rid of this feature, even when it works, if I mistakenly select a suggestion that I don't want, it appears at the top of the list again and again from then on.

brownrobm

My problem is the prompting inside quoted literals. It is driving me crazy. I'm trying to type 'New' here. About 1/2 the time I end up with Network.


I've had this problem several years ago, but it's been gone for a while. Sad that it's cropped back up again.

mdullni1

Just want to add myself as also having the problem with the suggestions showing when entering quoted literals.  Very annoying and is slowing me down.

mdullni1

I updated to 10.0.2.12561 and I still get suggestions when entering literals in quotes.

TomW

Hi everyone,

We're aware of this issue and hope to fix it soon.

Thanks,

Tom
Team Prompt

mattbenham

I hope this is a top-priority as it really is super-annoying.  How on earth did this get past QA?

TomW

Hi everyone,

This issue is one of our top priorities and we hope to have a fix out for it very soon. We’re very sorry for the inconvenience it’s causing.

Tom
Team Prompt

TomW

We've now got a fix for this issue and we'll be shipping it out in the next release.

Tianjiao_Li

Regarding the rank of the suggestion for AT TIME ZONE, thanks for reporting this one. Whilst this is a little odd, we couldn't take it on as a priority at the moment. Apologies for the inconvenience this is causing.

Tianjiao_Li

Regarding the issue with string literal, I'm pleased to let you know the fix is shipped so please upgrade.