SQL Prompt code completion completely broken for any query after an UPDATE query with USE HINT syntax
SQL Prompt code completion is broken if you use the OPTION ( USE HINT ( ) ) syntax with an update query. To make matters worse, if you are writing a stored procedure, the code completion tools remain broken for every query following the UPDATE statement as well.
This is on SQL Prompt v22.214.171.12460 with SQL Server Management Studio v17.9.1.
Here is a repro:
CREATE OR ALTER PROCEDURE dbo.TestThis
SET NOCOUNT ON;
DECLARE @var int;
-- try to do any code completion after this statement
-- only snippets will work
SET WatchThisBreak = 1
OPTION( USE HINT( 'FORCEDEFAULTCARDINALITY_ESTIMATION' ));
AdminAdrian B (n/a, Redgate) commented
Thanks for your feedback. This sounds more like a bug, although we’re not currently aware of it.
Please could you raise a support ticket with screenshots and recreation steps at https://redgatesupport.zendesk.com ?
The Prompt Team