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

If index WHERE contains NOT, Offset is not pushed

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 7.6.2
    • 7.2.3, 7.6.2
    • query
    • Untriaged
    • 0
    • Unknown

    Description

      https://www.couchbase.com/forums/t/limit-and-offset-is-not-being-pushed-to-index-with-where-clause/38156

      DROP INDEX default.ix21;
       
      CREATE INDEX `ix21` ON default (name DESC) WHERE type != "doc";
       
      EXPLAIN SELECT META(f).id
      FROM default f
      WHERE type != "doc" AND name > "xyz"
      ORDER BY name DESC
      OFFSET 10
      LIMIT 20;
      

      Also verify type NOT IN ["doc"] both places

      If change both places ( type != "doc") = true , it pushed.

      Also pushed

      CREATE INDEX `ix21` ON default (name DESC, type) WHERE (type != "doc");
      CREATE INDEX `ix21` ON default (name DESC, type) ;
      

      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
              Sitaram.Vemulapalli Sitaram Vemulapalli
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty