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

N1QL query with meta() always return expiration 0, while returns correct value with meta().expiration

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Fix
    • Major
    • None
    • 7.1.6
    • query, query_tools
    • None
    • Untriaged
    • 0
    • Unknown

    Description

       

      Query with meta().expiration like:

      select meta().expiration from `bucket`.`scope`.`collection` where entity = 'example'

      returns

      [
        {
          "expiration": 1713444247
        }
      ] 

      But it doesn't return correct expiration with meta(), for example:

      select meta() from `bucket`.`scope`.`collection` where entity = 'example'

      returns

      [
        {
          "$1": {
            "cas": 1713440647734165500,
            "expiration": 0,
            "flags": 33554432,
            "id": "***",
            "keyspace": "***",
            "type": "json"
          }
        }
      ] 

       

       

       

      Attachments

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

        Activity

          People

            kamini.jagtiani Kamini Jagtiani
            m.demydov Maksym Demydov
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty