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

CBO: Hint productivity does not return warning if unknown collection

    XMLWordPrintable

Details

    • Untriaged
    • 0
    • Unknown

    Description

      following query does not return warning when using incorrect collection (z)

       

      EXPLAIN SELECT COUNT(DISTINCT r.destinationairport) FROM airport a JOIN route r ON r.sourceairport /*+ productivity z 600.0 */ = a.faa WHERE a.city = 'San Francisco' AND a.country = 'United States';

      From test does not get any warning:

      ======================================================================
      		 
      ERROR: test_hints_warnings (cbas.cbas_cbo_hints.CbasHintsTests)
      		 
      ----------------------------------------------------------------------
      		 
      Traceback (most recent call last):
      		 
        File "/Users/pierre.regazzoni/couchbase/testrunner/pytests/cbas/cbas_cbo_hints.py", line 87, in test_hints_warnings
      		 
          self.assertEqual(explain["warnings"][0]["msg"], hints_warning[self.hash_hint])
      		 
      KeyError: 'warnings'

      Attachments

        Issue Links

          links to

          Web Link git gerrit link

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

          Activity

            People

              vijay.sarathy Vijay Sarathy
              pierre.regazzoni Pierre Regazzoni
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty