Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-26803

Aggreagtes should not be allowed inside another aggregate or group by

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 5.5.0
    • 5.5.0
    • query
    • None
    • Untriaged
    • Unknown

    Description

      SQL standard will not allow aggreagtes in group by or inside another aggregates.
      If user wants they can do in parent query. Same should follow the N1QL.

      explain select 1 from default group by sum(c1);
      explain select min(sum(c2)) from default;

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            korrigan.clark Korrigan Clark (Inactive)
            Sitaram.Vemulapalli Sitaram Vemulapalli
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty