Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more here.

Eduardo

My feedback

  1. 3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 50

    <=-=Apr 2 2008 5:15PM=-=>

    Erland,
    Thanks for reporting this issue. It is by design that the subquery in a coalesce is not matched between the optimizer and the algebrizer. Enabling this would involve considerable efforts and does not meet the current triage bar for SQL 2008. We assume that this does not affect many customers, however, we will consider it again for the next major release.
    A simple workaround that still uses coalesce would be to store the subquery’s result in a variable and use that in the coalesce statement.
    With best regards,
    Roman Schindlauer
    SQL Server Relational Engine

    <=-=Apr 2 2008 6:33PM=-=>

    Erland, your repro steps should indicate that having Northwind installed is a prerequisite. :-)

    <=-=Apr 3 2008 1:14PM=-=>

    I can understand that this a too tall order for SQL 2008 RTM, nevertheless it is something that should be addressed in one way or another.

    Eduardo supported this idea  · 
  2. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Azure Monitor-Application Insights » Analytics  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the valid suggestion. Your feedback is now open for the user community to upvote & comment on. This allows us to effectively prioritize your request against our existing feature backlog and also gives us insight into the potential impact of implementing the suggested feature.

    Eduardo shared this idea  · 
  3. 3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Azure Monitor-Application Insights » Analytics  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the valid suggestion. Your feedback is now open for the user community to upvote & comment on. This allows us to effectively prioritize your request against our existing feature backlog and also gives us insight into the potential impact of implementing the suggested feature.

    Eduardo shared this idea  · 
  4. 308 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    9 comments  ·  Logic Apps » Connectors  ·  Flag idea as inappropriate…  ·  Admin →
    Eduardo supported this idea  · 
  5. 109 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    8 comments  ·  Azure Portal » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Eduardo supported this idea  · 

Feedback and Knowledge Base