SQL Prompt v7.0.0.41 merge $action

jsreynolds1

Hello,

It seems that SQL Prompt is placing brackets around a merge statement's $action and thus rendering it problematic.
Below when I do a ctrl-k-y (format sql) it slaps brackets around the $action.

        WHEN NOT MATCHED BY SOURCE AND ([FileListing].[StoreNum] = @Store
                                        AND [FileListing].[BusinessDate] BETWEEN @From AND @Thru
                                       ) THEN
            DELETE
        OUTPUT
            $action AS [Action],
            [Deleted].[FileListingID],
            [Deleted].[StoreNum],
            [Deleted].[BusinessDate],
            [Deleted].[ProductionFileID],
            [Deleted].[Bytes] AS [OriginalBytes],
            [Source].[Bytes] AS [NewBytes],
            [Deleted].[Created] AS [OldCreated],
            [Source].[Created] AS [NewCreated],
            [Deleted].[Modified] AS [OldModified],
            [Source].[Modified] AS [NewModified]

	) AS [Merger]
            WHERE   [Action] <> 'INSERT';

Best,

John

Ali D

Hi John

Thanks for raising this, we can reproduce it so we’ll start working on a fix now.
You can work around this temporarily by going into SQL Prompt > Options > Format > Actions and unticking “Add/remove square brackets”.

Thanks
Ali

Ali D

Hi

We think we've got a fix for this issue in this private build, please could you give it a try and let us know how you get on.

Thanks
Ali

jsreynolds1

I can confirm that the new build does not place brackets around $action.

Thanks,

John