Skip to content

[Bug]: MERGE OUTPUT $action column incorrectly underlined as an error #20411

@gisn1

Description

@gisn1

Description

The OUTPUT clause has a special column called "$action" when used as part of a MERGE statement. The extension incorrectly flags this as a non-existent column and underlines it as an error.

Output Clause

Steps to Reproduce

Write any MERGE statement using OUTPUT $action

Affected Area

  • Connection dialog (SQL Server | Azure browse/Fabric browse)
  • Query results panel
  • Query editor
  • Object Explorer
  • Table Designer
  • Schema Compare
  • Schema Designer
  • Local SQL Server Container provisioning
  • SQL database in Fabric provisioning
  • GitHub Copilot integration
  • Query Plan Visualizer
  • Other (please describe below)

If you selected "Other", please describe the affected area

No response

Environment Information

VS Code: 1.105.1
MSSQL: 1.36.0

Confirmation

  • I have searched existing issues and couldn't find a match
  • I want to work on this issue

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions