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

[CX] LIMIT 1.1 in a query gives same result as limit 1

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Minor
    • 6.0.0
    • CBAS DP
    • analytics
    • cbas version:283
      couchbase version:4.5.1-2844
    • Untriaged
    • Unknown
    • CX Sprint 112

    Description

       
      Query issued:
      SELECT DISTINCT name FROM default_shadow LIMIT 1.1;
       
      cbas result:
      $ curl -s --data pretty=true  --data-urlencode "statement@file.txt" http://172.23.107.182:8095/analytics/service
      {
      	"requestID": "849b870c-dd75-4e4e-8ab4-88dab44684c1",
      	"signature": "*",
      	"results": [ {
      			"name": "employee-1"
      		} ]
      	,
      	"status": "success",
      	"metrics": {
      		"elapsedTime": "48.502495ms",
      		"executionTime": "48.087306ms",
      		"resultCount": "1",
      		"resultSize": "29"
      	}
      }
       
      n1ql result:
      [
        {
          "code": 5030,
          "msg": "Invalid LIMIT value 1.1."
        }
      ]
      
      

      Attachments

        Issue Links

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

          Activity

            People

              tanzeem.ahmed Tanzeem Ahmed (Inactive)
              Prerna.Manaktala Prerna Manaktala (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty