"desc" sometimes missing from intellisense, leads to bad suggestion

[gfody]

with a fresh installation some default settings combine and lead to a bad ux:

• Editor > Suggest: Show Snippets
• Editor: Accept Suggestions On Enter

Steps to Reproduce:

1. launch ADS, connect to a big database, new query, start typing

it looks like there are moments while typing when the query is considered invalid, and if the suggestions are populated during that moment it wants to suggest sqlDropStoredProc instead of desc:

(notice when the red squiggle comes and goes)

• Azure Data Studio Version: 1.48.1
• OS Version: Windows 10 Enterprise 22H2 (19045.4651)

Does this issue occur when all extensions are disabled?: Yes

[jeradrose]

This was reported with #6197 over 5 years ago, and it's still not fixed.

As suggested there, turning off snippets will at least stop that from happening (if you don't use them). Not ideal, but like I said, this may not be getting fixed anytime soon.

It's odd that there is latency with keywords but not all other objects.

One other option: I've turned off <enter> for accepting suggestions (Settings > Text Editor > Suggestions > Accept Suggestion On Enter > off/smart), as I always use <tab> for that, and I usually hit <enter> following desc, which is what's accepting the (incorrect) suggestion.