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

aggregate query on primary key does not push down

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Fix
    • Critical
    • bug-backlog
    • 5.5.0
    • query
    • None
    • Untriaged
    • Unknown

    Description

      Create primary index and run the following query:

      SELECT MAX( 2 / LENGTH( REVERSE( meta().id   ) )  ), COUNT( 2 / LENGTH( REVERSE( meta().id   ) )  ) FROM  simple_table_db_66591879_simple_table   WHERE  meta().id  < "N"

       

      Run explain and you will see it does not push down.

      Attachments

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

        Activity

          People

            korrigan.clark Korrigan Clark (Inactive)
            korrigan.clark Korrigan Clark (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty