BUG: Original table name is offered in UPDATE alias

AlzaAlza Posts: 2 Bronze 1
Original (non-aliased) fields are listed in Prompt when using UPDATE alias FROM table AS alias.
DECLARE @Table TABLE
  (
    Field INT
  );

UPDATE
  T
SET
  T.Field = $CURSOR$
FROM
  @Table AS T;

You can't use non-aliased @Table name, but Prompt is still suggesting it:

7pjx5i2hrstu.png

Latest SQL Prompt 8.x, but bug was introduces somewhere in 7.x

Comments

Sign In or Register to comment.