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

[CX] Error "Duplicate alias definitions" in GROUP BY clause

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Minor
    • 6.5.0
    • 5.5.0
    • analytics
    • Untriaged
    • Unknown
    • CX Sprint 148

    Description

      https://forums.couchbase.com/t/analytics-group-by-behaviour-duplicate-alias/17526

      Error: “Duplicate alias definitions: description” when running the following query:

      SELECT g.description AS account_name
           , p.description AS parent_account_name
        FROM `bucketname` g
        LEFT JOIN `bucketname` p 
          ON g.parent_account_name = p.name
         AND p.`type` = 'group'
       WHERE g.`type` = 'group'
       GROUP BY g.description 
           , p.description 
      

      Attachments

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

        Activity

          People

            dmitry.lychagin Dmitry Lychagin (Inactive)
            dmitry.lychagin Dmitry Lychagin (Inactive)
            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