Qualify Object Names - Not working for WHERE arguments

TomLTomL EUPosts: 7 New member
Hi,

I have a strange behaviour from Qualify Object Names.
When I use Qualify Object Names, it sometimes not working for the WHERE arguments.

I could break it down to following sample:

CREATE TABLE #temptable
(
    id INT,
    test NVARCHAR(15)
);
INSERT INTO #temptable
VALUES
(N'test');

SELECT t1.test
FROM #temptable t1
WHERE test = 'test';

DROP TABLE #temptable;

Nothing changes, when I try to qualify it. I would expect that
WHERE test = 'test' changes to WHERE t1.test = 'test'

If I comment the line with '-- id INT,', the qualify actually works.

Is this a bug, or is it a local formatting setting on my side?
I am using SSMS 18.4 and SQL Prompt 10.0.6.13013

Best regards
Tom
Tagged:

Answers

  • KarlBKarlB Cambridge Posts: 8 New member
    edited January 9, 2020 1:48PM
    Hi Tom,

    Thanks for highlighting this one and for the good detail and steps you have provided. It is strange behavior indeed and I have been able to replicate this using the same SSMS and SQL Prompt versions you are using.

    This has been referred to our developers internally so that they can review and provide further feedback.

    Good to know that you are able to comment out and continue as per your instructions in the mean time.

    Kind regards
    Karl Boldy | Redgate Software
    Have you visited our Help Center?
  • KarlBKarlB Cambridge Posts: 8 New member
    Hi Tom,

    Just to keep you updated, our development team have taken this on to fix, I'll keep track of it and let you know the outcome.

    Kind regards
    Karl Boldy | Redgate Software
    Have you visited our Help Center?
  • TomLTomL EUPosts: 7 New member
    Hi Karl,

    I really appreciate for keeping me updated.
    Hopefully they can fix it, somehow it happens a few times during a day.

    Best regards
    Tom
  • KarlBKarlB Cambridge Posts: 8 New member
    Hi Tom,

    No new update just yet I'm afraid, this one is with the developers currently. Will keep you posted.
    Kind regards
    Karl Boldy | Redgate Software
    Have you visited our Help Center?
Sign In or Register to comment.