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

Variable length sarging for OR predicates

    XMLWordPrintable

Details

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

    Description

      Allow variable length sarging for OR predicates.

      CREATE INDEX idx_ab ON default( a, b );
       
      SELECT *
      FROM default
      WHERE a = 5 OR ( a = 10 AND b = 10 );
      

      This will produce two spans:
      [ a: 5 ]
      [ a: 10 ]

      It should instead produce two variable-length spans:
      [ a: 5 ]
      [ a: 10, b: 10 ]

      Attachments

        Issue Links

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

          Activity

            People

              ajay.bhullar Ajay Bhullar
              gerald Gerald Sangudi (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty