Bug: GroupBy include all non-aggregates includes aggregate

jleachjleach Posts: 6
edited August 12, 2015 9:03AM in SQL Prompt
Not sure where the best place to report a bug is... I seem to have been directed here, so...

6.5.0.336

After typing GROUP BY and selecting "add all non-aggregated columns", the list includes an aggregate column if the column is an expression:
SUM(cpt.BilledAmount) + COALESCE(c.CaseExtendedCarryoverDollars, 0) AS TotalBilled,
· Share on Twitter

Comments

  • David PriddleDavid Priddle Posts: 218
    Hi jleach,

    Thanks for reporting this! You put it in the right place, the forums are where we keep track of issues that come in so other people with the same problems can keep track of their progress.

    We can reproduce this, and I'm looking into fixing this now.

    Best regards,

    David
    · Share on Twitter
  • David PriddleDavid Priddle Posts: 218
    Hi jleach,

    The latest version of the beta has the fix in. Please do let me know if this solves your problem!

    Best regards,

    David
    · Share on Twitter
Sign In or Register to comment.