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

[RQG Dynamic Indexing] Dynamic index is not used for queries with function<field>

    XMLWordPrintable

Details

    • Triaged
    • No

    Description

      Dynamic Index created:
      CREATE INDEX `idx_simple_table_db_3042_simple_table` ON `simple_table_db_3042_simple_table`((distinct (array `v` for `v` in pairs(self) end))) WITH

      { "defer_build"=true }

      Query issued:
      select meta().id from simple_table_db_3042_simple_table where abs(char_field1) > 0;
      explain SELECT primary_key_id FROM simple_table_db_3042_simple_table WHERE ( MILLIS( datetime_field1 ) ) > 0;
      explain SELECT primary_key_id FROM simple_table_db_3042_simple_table WHERE ( STR_TO_UTC( datetime_field1 ) ) > 0;

      None of the above queries use dynamic index which is created.
      The queries use the dynamic index when no function is used.

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MB-23983 [RQG Dynamic Indexing] queryport.connPoolTimeout from 127.0.0.1:9101 - cause: queryport.connPoolTimeout from 127.0.0.1:9101

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MB-23981 [RQG DYNAMIC INDEXING] Queries with count(*) with <NOT like> not using dynamic indexes

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MB-23984 [RQG Dynamic Indexing] NOT and NOT like queries with UNION ALL not using dynamic index

          • Major - Major loss of function.
          • Closed
          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

              keshav Keshav Murthy
              Prerna.Manaktala Prerna Manaktala (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty