Bug in rename alias within a stored proc if select list calls a function

jbrune

A bug that's a bit tough to find. The Rename Alias / Variable (F2) functionality does not work if there is a function in the select list and it's with a proc.

For example:

CREATE PROCEDURE dbo.MyProc
AS
BEGIN
    SELECT
        CommonModule.MyFunction(),
        _MyT.MyColumn
    FROM
        MyTable _MyT

END

You won't be able to Rename _MyT unless you comment out the "MyFunction()" line or the "CREATE PROCEDURE" line.

jbrune

Oh, I'm on version 8.0.2.1508.

James R

Hi @jbrune,

Thanks for noticing this! We've managed to reproduce this here, we'll hopefully investigate this week.

Regards,
James