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

[RQG Dynamic Indexing] NOT and NOT like queries with UNION ALL not using dynamic index

    XMLWordPrintable

Details

    • Untriaged
    • No

    Description

      Job which is failing:
      cen006-n1ql-vset03-02-rqg-fields-union-DynamicIndexing-primary-secondary-tests

      Number of queries failing:
      Total Queries Run = 10000, Pass = 9653, Fail = 347

      Dynamic index created:
      CREATE INDEX idx_simple_table_db_5248_simple_table ON simple_table_db_5248_simple_table(DISTINCT ARRAY v FOR v IN PAIRS(SELF) END) WITH

      {'defer_build': 'true'}

      Example of Queries failing:
      (SELECT * FROM simple_table_db_5248_simple_table WHERE (bool_field1 AND (char_field1 IN [ "A" , "B" , "C" , "D" , "E" ]) OR (primary_key_id IN [ "1" , "10" , "100" , "1000" , "101" ])) ORDER BY int_field1 , decimal_field1 , primary_key_id , varchar_field1 , char_field1 , bool_field1 ASC) UNION ALL (SELECT * FROM simple_table_db_5248_simple_table WHERE bool_field1 ORDER BY int_field1 , decimal_field1 , primary_key_id , varchar_field1 , char_field1 DESC) UNION (SELECT * FROM simple_table_db_5248_simple_table WHERE ((bool_field1 = true AND primary_key_id > "549")) AND ((bool_field1 != false OR decimal_field1 <= 5024)) OR ((bool_field1 OR varchar_field1 IS NOT NULL)) AND ((decimal_field1 IS NULL AND primary_key_id = "549" AND NOT (bool_field1))) ORDER BY int_field1 , primary_key_id ASC) UNION ALL (SELECT * FROM simple_table_db_5248_simple_table WHERE NOT ((primary_key_id LIKE '%549' AND NOT (int_field1 > 4964))) ORDER BY primary_key_id ASC)

      (SELECT * FROM simple_table_db_5248_simple_table WHERE (bool_field1 OR NOT (NOT (char_field1 LIKE 'N%'))) ORDER BY primary_key_id , varchar_field1 , char_field1 DESC) UNION ALL (SELECT * FROM simple_table_db_5248_simple_table WHERE NOT ((bool_field1 AND int_field1 != 4964)) ORDER BY int_field1 , decimal_field1 ) UNION ALL (SELECT * FROM simple_table_db_5248_simple_table WHERE (bool_field1 != true AND (primary_key_id < "549") AND ((varchar_field1 <= "aKTJdLZhpz") OR ((varchar_field1 < "aKTJdLZhpz") OR (varchar_field1 < "aKTJdLZhpz")))) ORDER BY int_field1 , decimal_field1 ) UNION (SELECT * FROM simple_table_db_5248_simple_table WHERE NOT ((decimal_field1 < 5024 AND primary_key_id LIKE '%549' AND bool_field1)) ORDER BY int_field1 , primary_key_id , varchar_field1 , char_field1 )

      (SELECT * FROM simple_table_db_5248_simple_table WHERE ((bool_field1 != false AND ((primary_key_id = "549") OR (varchar_field1 >= "aKTJdLZhpz")) OR (primary_key_id IS NULL))) OR ((NOT (bool_field1) OR int_field1 IN [ 7 , 10 , 11 , 28 , 43 ])) ORDER BY int_field1 , primary_key_id , varchar_field1 ASC) UNION (SELECT * FROM simple_table_db_5248_simple_table WHERE ((bool_field1 AND ((int_field1 < 4964) OR ((decimal_field1 < 5024) OR (int_field1 >= 4964))) OR (int_field1 != 4964))) AND ((bool_field1 = true AND (decimal_field1 BETWEEN 9 and 9998) AND (int_field1 >= 4964))) ORDER BY int_field1 DESC) UNION (SELECT * FROM simple_table_db_5248_simple_table WHERE ((primary_key_id <= "549" AND decimal_field1 < 5024)) OR (bool_field1) ORDER BY int_field1 , decimal_field1 , primary_key_id , varchar_field1 , bool_field1 ) UNION (SELECT * FROM simple_table_db_5248_simple_table WHERE ((char_field1 NOT LIKE "N") OR (varchar_field1 NOT LIKE '%aKTJdLZhpz%')) OR (decimal_field1 > 5024) ORDER BY int_field1 , decimal_field1 , primary_key_id DESC)

      (SELECT * FROM simple_table_db_5248_simple_table WHERE (NOT (char_field1 LIKE '%N')) OR ((bool_field1 != false AND decimal_field1 < 5024)) ORDER BY int_field1 , decimal_field1 , primary_key_id , bool_field1 ASC) UNION ALL (SELECT * FROM simple_table_db_5248_simple_table WHERE ((int_field1 = 4964 OR char_field1 IS NULL)) AND ((bool_field1 = true AND varchar_field1 <= "aKTJdLZhpz")) ORDER BY int_field1 , primary_key_id , varchar_field1 , bool_field1 ) UNION (SELECT * FROM simple_table_db_5248_simple_table WHERE (bool_field1 != true OR char_field1 = "N") ORDER BY int_field1 , primary_key_id , bool_field1 ) UNION (SELECT * FROM simple_table_db_5248_simple_table WHERE ((int_field1 != 4964 OR primary_key_id = "549")) OR ((bool_field1 != false OR primary_key_id < "549")) ORDER BY primary_key_id , varchar_field1 ASC)

      (SELECT * FROM simple_table_db_5248_simple_table WHERE NOT ((varchar_field1 LIKE '%aKTJdLZhpz' AND int_field1 != 4964)) ORDER BY int_field1 , primary_key_id , varchar_field1 , char_field1 , bool_field1 ASC) UNION (SELECT * FROM simple_table_db_5248_simple_table WHERE NOT (varchar_field1 < "aKTJdLZhpz") ORDER BY int_field1 , primary_key_id , varchar_field1 , bool_field1 )

      How to run the test:
      ./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_unions.txt.zip,database=simple_table_db,reset_database=True,gsi_type=${gsi_type},concurreny_count=10,index_quota_percent=30,password=password,use_mysql=True,replicas=0,create_secondary_indexes=True,number_of_buckets=1,total_queries=${total_queries},record_failure=False,failure_record_path=/tmp,skip_cleanup=${skip_cleanup},subquery=False,dynamic_indexing=True,create_primary_index=False

      Attachments

        Issue Links

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

          Activity

            People

              keshav Keshav Murthy
              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