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

[Explain Plan] test_count_distinct fails

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 5.5.0
    • 5.5.0
    • query
    •  5.1.0-1431,this test passed in build 1394.
    • Untriaged
    • Yes

    Description

      This is a regression from build 5.1.0-1394.

      Query issued by the test:
      explain select count(distinct VMs[1].os) from default where VMs[1].os='windows' or tasks_points.task1>1

      Assert which fails:
      self.assertTrue( plan['~children'][0]['scan']'#operator'=='IndexScan2')

      Indexes created by the test:
      CREATE INDEX idx ON default(job_title) where email like '%@%.%' USING GSI
      CREATE INDEX idx2 ON default(VMs[1].os,tasks_points.task1) USING GSI
      CREATE INDEX idx3 ON default(VMs[1].os,name) where tasks_points.task1=1 USING GSI

      Uploading dataset.

      Attachments

        Issue Links

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

          Activity

            People

              ajay.bhullar Ajay Bhullar
              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