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

[Backport MB-59138 to 7.2.4] Index has 0 entries when NESTED ARRAY FLATTEN_KEYS() and one of them has MISSING

    XMLWordPrintable

Details

    • Untriaged
    • 0
    • Unknown

    Description

      Index has 0 entries. It may be evalueForIndex() issue. Let projector take look first. cc Varun Velamuri

      UPSERT INTO default VALUES("k03", { "a": [ { "id": "1" },
                                                 { "a1": [
                                        { "ch": { "name": "phoneNumber", "value": { "value": "111111111" }}, "type": "Phone" },
                                        { "ch": { "name": "email", "value": { "value": "abc@gmail.com" }}, "type": "email" } ] } ] });
      CREATE INDEX ix21 ON default( DISTINCT ARRAY ( DISTINCT ARRAY FLATTEN_KEYS(c.ch.`value`.`value`, c.type) FOR c IN r.a1 END) FOR r IN a END);
      SELECT d.*
      FROM default AS d
      WHERE ANY r IN a SATISFIES ANY c IN r.a1 SATISFIES c.ch.`value`.`value` = "111111111" AND c.type = "Phone" END END;
      
      

      cbindex -auth Administrator:password -type=scanAll -bucket default -index ix21
      ScanAll index:
      Total number of entries:  0
      
      

      Attachments

        Issue Links

          Activity

            People

              hemant.rajput Hemant Rajput
              amit.kulkarni Amit Kulkarni
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty