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

Implicit cover of nested array not working with arbitrary variables

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 5.5.5, 6.0.3, 6.5.0
    • 5.5.4, 6.0.2, 6.5.0
    • query
    • Untriaged
    • Unknown

    Description

      CREATE INDEX `ix2` ON `default`(distinct array (distinct array `p`.`relevancia` for `p` in `c`.`palabras` end) for `c` in `conclusiones` end) ;
      
      

      The following covers

      EXPLAIN SELECT META().id FROM default AS r WHERE ANY c IN r.conclusiones SATISFIES ANY p IN c.palabras SATISFIES p.relevancia > 50 END END;
      
      

      The following is not covering

      EXPLAIN SELECT META().id FROM default AS r WHERE ANY conclusion IN r.conclusiones SATISFIES ANY p IN conclusion.palabras SATISFIES p.relevancia > 50 END END;
      
      

      Attachments

        Issue Links

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

          Activity

            People

              mihir.kamdar Mihir Kamdar (Inactive)
              Sitaram.Vemulapalli Sitaram Vemulapalli
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  PagerDuty