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

Advise not recommending index for a query having a boolean field in the predicate without explicit value

    XMLWordPrintable

Details

    • Triaged
    • 1
    • Unknown

    Description

      Build : 7.0.0-1834

      Index advisor has recommendation for this query -
      select * from bucket1 where bool_field=True

      but not for the equivalent query -
      select * from bucket1 where bool_field;

      [
        {
          "#operator": "Advise",
          "advice": {
            "#operator": "IndexAdvice",
            "adviseinfo": {
              "current_indexes": [
                {
                  "index_statement": "CREATE PRIMARY INDEX #primary ON `bucket1`",
                  "keyspace_alias": "bucket1"
                }
              ],
              "recommended_indexes": "No index recommendation at this time."
            }
          },
          "query": "select *  from bucket1 where bool_field"
        }
      ]
      

      Attachments

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

        Activity

          People

            mihir.kamdar Mihir Kamdar (Inactive)
            mihir.kamdar Mihir Kamdar (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