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

Count(*) on query involving meta().expiration is not working

    XMLWordPrintable

Details

    • Bug
    • Resolution: User Error
    • Major
    • 7.0.0
    • Cheshire-Cat
    • query
    • Untriaged
    • 1
    • No

    Description

      This query is throwing error - 

       

      SELECT count(*) FROM default:test_bucket.test_scope_1.test_collection_1 WHERE meta().expiration is not null order by meta().id desc
       
       
      [
        {
          "code": 4210,
          "msg": "Expression (meta(`test_collection_1`).`id`) must depend only on group keys or aggregates.",
          "query": "SELECT count(meta().id) FROM default:test_bucket.test_scope_1.test_collection_1 WHERE meta().expiration is not null order by meta().id desc"
        }
      ]

       

       

      CBS - 7.0.0-2327

      Attachments

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

        Activity

          People

            kamini.jagtiani Kamini Jagtiani
            hemant.rajput Hemant Rajput
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty