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

Some array queries are not producing Optimizer Estimates (costs and cardinalities)

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 7.0.0
    • Cheshire-Cat
    • query
    • 1
    • Other/not scored

    Description

      Here are some example queries

      SELECT x.u016_i FROM KS2 x WHERE ANY v IN uarr_n satisfies v = 100000 END
      SELECT x.u016_i FROM KS2 x WHERE ANY v IN rarr_n satisfies v = 0 END;
       SELECT x.u016_i FROM KS2 x WHERE ANY v IN rarr_n satisfies v = 100000 END
      SELECT x.u016_i FROM KS2 x WHERE ANY v IN rarr_n satisfies v <= 0 END

      0 and 100000 are "extreme" values are not found in the arrays.

      KS2 has 100000 documents, uarr_n and rarr_n each contain an array with length between 0-10 and values in range of 0-100000, not including 0 or 100000.

      UPDATE STATISTICS has been run on the array:

      UPDATE STATISTICS for KS2 (DISTINCT uarr_n, DISTINCT rarr_n);

      Attachments

        For Gerrit Dashboard: MB-40397
        # Subject Branch Project Status CR V

        Activity

          People

            bingjie.miao Bingjie Miao
            murali.krishna Murali Krishna
            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