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

Case insensitive projection doesn't work for nested fields

    XMLWordPrintable

Details

    • Untriaged
    • 0
    • Unknown

    Description

      Steps to reproduce:

      Insert the following document into your collection:

      {
        "level1": {
          "level2": {
            "level3": "hi"
          }
        }
      } 

      case-insensitive tag doesn't apply for the first level of nesting( level1 )

       SELECT `default`.`Level1`i.`Level2`i.`level3` FROM `default`;
      {
          "requestID": "d6b6dd02-1976-42fa-8cf0-f7867e0a2103",
          "signature": {
              "level3": "json"
          },
          "results": [
          {}
          ],
          "status": "success",
          "metrics": {
              "elapsedTime": "166.556084ms",
              "executionTime": "163.419709ms",
              "resultCount": 1,
              "resultSize": 2,
              "serviceLoad": 2
          }
      } 

      Expected behaviour:

      SELECT `default`.`Level1`i.`Level2`i.`level3` FROM `default`;
      {
          "requestID": "749767f3-5dda-4784-8d4d-3b44f30434fb",
          "signature": {
              "level3": "json"
          },
          "results": [
          {
              "level3": "hi"
          }
          ],
          "status": "success",
          "metrics": {
              "elapsedTime": "240.370583ms",
              "executionTime": "238.220583ms",
              "resultCount": 1,
              "resultSize": 30,
              "serviceLoad": 2
          }
      } 

       

      Attachments

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

        Activity

          People

            pierre.regazzoni Pierre Regazzoni
            gaurav.jayaraj Gaurav Jayaraj
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty