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

Data platform: Intersect AND terms for dynamic index

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Major
    • 4.6.2, 5.0.0
    • 4.5.1, 4.6.0
    • query
    • None

    Description

      Given

      CREATE INDEX idx ON default( DISTINCT ARRAY p FOR p IN PAIRS( SELF ) END );
       
      SELECT META( d ).id
      FROM default d
      WHERE
      ANY p IN PAIRS( d ) SATISFIES p = [ "name", "John" ] END
      AND AND p IN PAIRS( d ) SATISFIES p = [ "age", 30 ] END;
      

      We need to generate a span for each AND term and intersect the results.

      cc Keshav Murthy

      Attachments

        Issue Links

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

          Activity

            People

              prasanna.gholap Prasanna Gholap [X] (Inactive)
              gerald Gerald Sangudi (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty