Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

Query optimizer cannot make plan for merge statement

We get this exception from the query processor:
Msg 8618, Level 16, State 2, Procedure <procname>, Line <line#> [Batch Start Line 2]
The query processor could not produce a query plan because a worktable is required, and its
minimum row size exceeds the maximum allowable of 8060 bytes...
for a merge statement (without any group by or order by clauses). It seems like the bug appears in the OUTPUT clause, when the number of columns exceed 8.

0 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    AdminMicrosoft SQL Server (Admin, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base