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

NEGINFIF function with "-Inf" returns error on 4.6, 5.0

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • bug-backlog
    • 4.6.0, 5.0.0
    • secondary-index
    • None
    • Triaged
    • Unknown

    Description

      Someone in the Couchbase Gitter channel was querying why the following N1QL where clause works in 4.5 and no longer does in 4.6+
      "WHERE expires_at > NEGINFIF($time, "-inf")"

      The error they receive on 4.6+ is
      "Error evaluating scanCount(). - cause: json: unsupported value: +Inf from xxx:9101 - cause: json: unsupported value: +Inf from xxx:9101"

      They updated their query to the following, but want to know why the previous query stopped:
      "WHERE expires_at > IFNULL($time, false)"

      Also, is there a correct way to deal with Infinity? eg is there a keyword that can be used?

      Attachments

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

        Activity

          People

            prataprc Pratap Chakravarthy (Inactive)
            mike.goldsmith Michael Goldsmith
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty