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

Derive unnest predicate from joinfilters for primary keyspace

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Unresolved
    • Major
    • feature-backlog
    • 6.5.0
    • query

    Description

      The following query can not derive a "IS NOT NULL" filter of unnest join predicate for the primary keyspace:

      SELECT p.userid FROM crm a UNNEST participants p INNER JOIN crm uhl ON p.userid = uhl.id AND uhl.type = '_user_hier_level'

      Attachments

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

        Activity

          People

            keshav Keshav Murthy
            chang.liu Chang Liu (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty