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

[CX] Correct message but different from n1ql:"asterix:floor expects a numeric input type, but gets STRING"

    XMLWordPrintable

Details

    • Untriaged
    • Unknown

    Description

      Query issued:
      select name from default_shadow where floor(job_title) > 5;

      Above query gives correct message since job_title is a string for CBAS:
      "msg": "asterix:floor expects a numeric input type, but gets STRING"

      But gives no results in case of n1ql since N1QL never gives error, it gives missing if the input is invalid.
      According to Sitaram, that is the decision made due to NOSQL.

      Attachments

        Issue Links

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

          Activity

            People

              dmitry.lychagin Dmitry Lychagin (Inactive)
              Prerna.Manaktala Prerna Manaktala (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