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

Date format works with n1ql but not analytics

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Major
    • bug-backlog
    • 6.0.0
    • analytics
    • None
    • Untriaged
    • Unknown

    Description

      I have a document that has a datetime of format "2019-01-16T16:56:31.235254Z", and a query like:

      SELECT DATE_PART_STR(start_time, "month") FROM default LIMIT 15

      When running against n1ql this returns me a list of documents of the form 

      {{{}}
      {{ "$1": 1}}
      {{ },}}

      However, when I run against analytics it does not appear to handle the format correctly and I get a list of documents that look like
      {{ {}}
      {{ "$1": null}}
      {{ },}}

       

      Attachments

        Issue Links

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

          Activity

            People

              sandeep.gupta Sandeep Gupta (Inactive)
              charles.dixon Charles Dixon
              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