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

[N1QL] test_order_by_alias_aggr_fn functional test is failing

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 5.0.0
    • 5.0.0
    • query
    • 5.0.0-2318
    • Untriaged
    • No

    Description

      This is a regression which does not occur in 4.6.2-3836.

      How to run the test?
      python testrunner.py -i local.ini -c conf/tuq/py-tuq-dynamic.conf -p gsi_type=forestdb,doc-per-day=6,standard_buckets=1,primary_indx_type=GSI,nodes_init=1

      Error reported by test:

      actual results are []
      expected results are [{u'emp_per_month': 0}]
      [2017-03-16 11:21:18,249] - [newtuq:842] ERROR - Missing items: [{u'emp_per_month': 0}].
       Extra items: []
      ======================================================================
      FAIL: test_order_by_alias_aggr_fn (tuqquery.newtuq.QueryTests)
      ----------------------------------------------------------------------
      Traceback (most recent call last):
        File "pytests/tuqquery/newtuq.py", line 480, in test_order_by_alias_aggr_fn
          self._verify_results(actual_result['results'], expected_result)
        File "pytests/tuqquery/newtuq.py", line 844, in _verify_results
          len(actual_result), len(expected_result)))
      AssertionError: Results are incorrect.Actual num 0. Expected num: 1.
      
      

      Generated query to be run:

       QUERY SELECT SequenceNumber, mutated, COUNT(*) AS emp_per_month FROM default WHERE mutated >7 GROUP BY SequenceNumber, mutated ORDER BY emp_per_month, mutated, SequenceNumber
      

      Please run the test and it will generated the dataset for you.Please let me know if you need the dataset separately.

      Attachments

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

        Activity

          People

            Prerna.Manaktala Prerna Manaktala (Inactive)
            Prerna.Manaktala Prerna Manaktala (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty