Details
-
Bug
-
Resolution: Duplicate
-
Major
-
5.0.0
-
5.0.0-2652
-
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
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
- duplicates
-
MB-23884 [RQG Dynamic Indexing] Dynamic index is not used for queries with function<field>
- Closed
For Gerrit Dashboard: MB-23984 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
77025,5 | MB-23981,MB-23983,MB-23984. DNF transform of LIKE '%abc%' | master | query | Status: MERGED | +2 | +1 |
77076,2 | Revert "MB-23981,MB-23983,MB-23984. DNF transform of LIKE '%abc%'" | master | query | Status: MERGED | +2 | +1 |