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

[RQG Dynamic Indexing] NOT LIKE query is not using dynamic index.

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • Spock.Next
    • 4.6.2, 5.0.0
    • query
    • 4.6.2-3889,5.0.0-2873
    • Triaged
    • No

    Description

      Index created:
      create index ix1 on default(distinct pairs(self));

      Query issued:
      select meta().id from default where a not like "a%";

      This query does not use the dynamic index created.

      All queries for MB-22808 pass except:
      SELECT COUNT FROM simple_table_db_2483_simple_table WHERE char_field1 NOT LIKE '%N'
      AND
      SELECT MAX( decimal_field1 ) FROM simple_table_db_2483_simple_table WHERE (char_field1 NOT LIKE 'N%') OR ((bool_field1 != false AND int_field1 > 4821)) ORDER BY MAX( int_field1 );

      Attachments

        Issue Links

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

          Activity

            People

              Prerna.Manaktala Prerna Manaktala (Inactive)
              Prerna.Manaktala Prerna Manaktala (Inactive)
              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