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

N1QL: Allow expressions from the LETTING clause also in select with group by

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 4.5.0
    • 4.5.0
    • query
    • None
    • 4.5.0-1812
    • Untriaged
    • Yes

    Description

      Query executed:
      explain SELECT join_mo, sum_test from default WHERE join_mo>7 group by join_mo letting sum_test = sum(test_rate)

      Gives error:
      "msg": "Expression must be a group key or aggregate: `sum_test`"

      We should allow expressions from the LETTING clause.

      Attachments

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

        Activity

          People

            gerald Gerald Sangudi (Inactive)
            Prerna.Manaktala Prerna Manaktala (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