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

RQG: Mismatch in Queries seen for count(*) and min functions

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Test Blocker
    • 4.5.0
    • 4.5.0
    • query
    • 4.5.0-2100
    • Untriaged
    • Yes

    Description

      Test which fails:
      ./testrunner -i ${resource_tuq} -p gsi_type=${gsi_type} -t rqg.test_rqg.RQGTests.test_rqg_concurrent,test_file_path=b/resources/rqg/simple_table_db/query_tests_using_templates/query_50000_aggregate_functions.txt.zip,database=multiple_table_db,reset_database=True,concurreny_count=10,index_quota_percent=30,password=password,use_mysql=True,replicas=0,create_secondary_indexes=True,run_query_with_primary=True,record_failure=True,failure_record_path=/tmp,nodes_init=1,build_index_batch_size=1000,build_secondary_index_in_seq=True,nodes_init=1,number_of_buckets=1,total_queries=10000,skip_cleanup=True

      URL:
      http://172.23.107.87:8091/ui/index.html#/index

      Example of ini:
      [global]
      port:8091
      username:root
      password:couchbase
      index_port:9102

      [servers]
      1:SERVER_1

      [SERVER_1]
      ip:172.23.107.87
      services=n1ql,kv,index

      [membase]
      rest_username:Administrator
      rest_password:password

      Mismatch seen in results of queries:
      2016-04-12 11:40:03 | INFO | MainProcess | test_thread | [test_rqg._test_result_analysis] Total Queries Run = 10000, Pass = 9994, Fail = 6, Pass Pecentage = 99 %
      2016-04-12 11:40:03 | INFO | MainProcess | test_thread | [test_rqg.test_rqg_concurrent] <<<<<<<<<< TEST 2570 >>>>>>>>>>>
      keyword_list :: [' >= ', 'IN']
      run_result ::
      ____________________________________________________
      Scenario :: run_query_without_index_hint
      Reason :: the number of results do not match :: expected = 1, actual = 1
      mismatch in results :: expected :: [

      {u'MIN( int_field1 )': 34}

      ], actual :: []

      sql_query :: SELECT MIN( int_field1 ) FROM simple_table_1 WHERE char_field1 >= "N"
      n1ql_query :: SELECT MIN( int_field1 ) FROM simple_table_1 WHERE char_field1 >= "N"
      <<<<<<<<<< TEST 9584 >>>>>>>>>>>
      keyword_list :: [' > ', 'AND', 'IN']
      run_result ::
      ____________________________________________________
      Scenario :: run_query_without_index_hint
      Reason :: mismatch in results :: expected [0:1]:: [236], actual [0:1]:: [500]

      sql_query :: SELECT COUNT FROM simple_table_1 WHERE (int_field1 > 5042) AND (decimal_field1 > 5201)
      n1ql_query :: SELECT COUNT FROM simple_table_1 WHERE (int_field1 > 5042) AND (decimal_field1 > 5201)
      <<<<<<<<<< TEST 2358 >>>>>>>>>>>
      keyword_list :: [' > ', 'AND', 'IN']
      run_result ::
      ____________________________________________________
      Scenario :: run_query_without_index_hint
      Reason :: mismatch in results :: expected [0:1]:: [236], actual [0:1]:: [498]

      sql_query :: SELECT COUNT FROM simple_table_1 WHERE (varchar_field1 > "aYTUOeXhmw" AND int_field1 > 5042)
      n1ql_query :: SELECT COUNT FROM simple_table_1 WHERE (varchar_field1 > "aYTUOeXhmw" AND int_field1 > 5042)
      <<<<<<<<<< TEST 4959 >>>>>>>>>>>
      keyword_list :: [' > ', 'IN']
      run_result ::
      ____________________________________________________
      Scenario :: run_query_without_index_hint
      Reason :: the number of results do not match :: expected = 1, actual = 1
      mismatch in results :: expected :: [

      {u'MIN( int_field1 )': 69}

      ], actual :: []

      sql_query :: SELECT MIN( int_field1 ) FROM simple_table_1 WHERE varchar_field1 > "aYTUOeXhmw"
      n1ql_query :: SELECT MIN( int_field1 ) FROM simple_table_1 WHERE varchar_field1 > "aYTUOeXhmw"
      <<<<<<<<<< TEST 4106 >>>>>>>>>>>
      keyword_list :: [' < ', 'IN', 'NOT']
      run_result ::
      ____________________________________________________
      Scenario :: run_query_without_index_hint
      Reason :: the number of results do not match :: expected = 1, actual = 1
      mismatch in results :: expected :: [

      {u'MIN( int_field1 )': 69}

      ], actual :: []

      sql_query :: SELECT MIN( int_field1 ) FROM simple_table_1 WHERE NOT (varchar_field1 < "aYTUOeXhmw")
      n1ql_query :: SELECT MIN( int_field1 ) FROM simple_table_1 WHERE NOT (varchar_field1 < "aYTUOeXhmw")
      <<<<<<<<<< TEST 8351 >>>>>>>>>>>
      keyword_list :: [' > ', 'AND', 'IN']
      run_result ::
      ____________________________________________________
      Scenario :: run_query_without_index_hint
      Reason :: the number of results do not match :: expected = 1, actual = 1
      mismatch in results :: expected :: [

      {u'MIN( int_field1 )': 69}

      ], actual :: []

      sql_query :: SELECT MIN( int_field1 ) FROM simple_table_1 WHERE (varchar_field1 > "aYTUOeXhmw" AND decimal_field1 > 5201)
      n1ql_query :: SELECT MIN( int_field1 ) FROM simple_table_1 WHERE (varchar_field1 > "aYTUOeXhmw" AND decimal_field1 > 5201)

      Attachments

        1. dump_index_input.tar.gz
          38.78 MB
        2. logs.zip
          17.56 MB
        3. simple_table_1.tar.gz
          66 kB
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty