What are the challenges you face when working across database platforms? Take the survey
Options

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,

Comments

  • Options
    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
  • Options
    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
Sign In or Register to comment.