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

expression cannot be chained in letting clause

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Blocker
    • 6.5.0
    • 6.5.0
    • query
    • None
    • Untriaged
    • Unknown

    Description

      load gamesim-sample

      run this query:

       select level from `gamesim-sample` where level is not missing group by level letting b=1,c=b+1

      give back this error:

      "Expression must be a group key or aggregate: (`b` + 1)"

      We should be able to chain expressions in letting clause independent of group keys

      same thing happens if b is not an expression but a field:

      select level from `gamesim-sample` where level is not missing group by level letting b=level,c=b+1

      gives same error

      Attachments

        Issue Links

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

          Activity

            People

              bingjie.miao Bingjie Miao
              korrigan.clark Korrigan Clark (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty