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

Internal error if LIMIT is based on an equation

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Minor
    • 6.0.0
    • 6.0.0
    • analytics
    • Enterprise Edition 6.0.0 build 1305
    • Untriaged
    • Centos 64-bit
    • No
    • CX Sprint 112

    Description

      I have 5 documents in KV, in the format [key --> \{Json document}]

      dav --> {"name":"dave","age":19,"gender":"Male","salary":50000}
      eva --> {"name":"evan","age":25,"gender":"Female","salary":100000}
      joh --> {"name":"john","age":44,"gender":"Male","salary":500000}
      sof --> {"name":"sofiya","age":20,"gender":"Female","salary":70000}
      tanz --> {"name":"tanzeem","age":31,"gender":"Male","salary":10000}

      For the below query LIMIT is not pushed to data scan

      select * from ds limit 1000/500

      Note: The same query works on N1QL. Refer : https://developer.couchbase.com/documentation/server/current/n1ql/n1ql-language-reference/limit.html

      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)
              tanzeem.ahmed Tanzeem Ahmed (Inactive)
              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