Details
-
Bug
-
Resolution: Duplicate
-
Major
-
5.0.0
-
5.0.0-2652
-
Untriaged
-
No
Description
Job which fails:
cen006-n1ql-vset02-04-rqg-joins-DynamicIndexing-primary-secondary-tests
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/multiple_table_db/query_test_using_templates/queries_joins_50000.txt.zip,database=multiple_table_db,reset_database=True,concurreny_count=10,index_quota_percent=30,record_failure=False,password=password,use_mysql=True,replicas=0,total_queries=${total_queries},failure_record_path=/tmp,skip_cleanup=${skip_cleanup},subquery=False,dynamic_indexing=True,create_primary_index=False
Example queries which fail:
SELECT t_5.primary_key_id , t_5.varchar_field1 , t_5.char_field1 FROM multiple_table_db_759_simple_table_4 t_2 INNER JOIN multiple_table_db_759_simple_table_3 t_5 ON KEYS [ t_2.primary_key_id ] LEFT JOIN multiple_table_db_759_simple_table_1 t_3 ON KEYS [ t_5.primary_key_id ] LEFT JOIN multiple_table_db_759_simple_table_2 t_1 ON KEYS [ t_2.primary_key_id ] INNER JOIN multiple_table_db_759_simple_table_10 t_4 ON KEYS [ t_5.primary_key_id ] WHERE ((t_3.int_field1 != 4952 AND NOT ((t_1.varchar_field1 > "aXXHYjxnbA") AND (t_3.varchar_field1 NOT LIKE "aFNWltxSmQ")) AND t_1.bool_field1 != true)) AND (t_5.primary_key_id LIKE '%549%') OR (t_4.int_field1 = 5269) AND ((t_1.bool_field1 = true AND t_3.decimal_field1 = 5234))
SELECT t_3.int_field1 , t_1.primary_key_id , t_3.bool_field1 FROM multiple_table_db_759_simple_table_10 t_4 LEFT JOIN multiple_table_db_759_simple_table_3 t_5 ON KEYS [ t_4.primary_key_id ] INNER JOIN multiple_table_db_759_simple_table_1 t_3 ON KEYS [ t_5.primary_key_id ] INNER JOIN multiple_table_db_759_simple_table_4 t_2 ON KEYS [ t_5.primary_key_id ] INNER JOIN multiple_table_db_759_simple_table_2 t_1 ON KEYS [ t_4.primary_key_id ] LEFT JOIN multiple_table_db_759_simple_table_4 t_2lXDfgOMuaI ON KEYS [ t_1.primary_key_id ] WHERE (((t_4.int_field1 IS NULL) OR (NOT (t_1.int_field1 != 4898)) AND t_1.primary_key_id < "549" AND NOT (t_4.bool_field1))) OR (t_5.decimal_field1 > 4991)
SELECT t_3.primary_key_id , t_3.varchar_field1 , t_3.char_field1 FROM multiple_table_db_759_simple_table_4 t_2 INNER JOIN multiple_table_db_759_simple_table_10 t_4 ON KEYS [ t_2.primary_key_id ] INNER JOIN multiple_table_db_759_simple_table_1 t_3 ON KEYS [ t_4.primary_key_id ] WHERE ((t_2.int_field1 = 4922 AND t_4.varchar_field1 NOT BETWEEN "AANcgcCryL" and "zsaHmIdUWW" AND t_2.bool_field1)) AND (t_3.char_field1 IN [ "A" , "B" , "C" , "D" , "E" ]) OR ((t_2.char_field1 NOT BETWEEN "A" and "Z" AND t_4.int_field1 IS NULL)) AND ((t_3.varchar_field1 < "aFNWltxSmQ" AND t_2.decimal_field1 <= 4974))
SELECT t_3.int_field1 , t_3.primary_key_id , t_3.bool_field1 FROM multiple_table_db_759_simple_table_2 t_1 LEFT JOIN multiple_table_db_759_simple_table_1 t_3 ON KEYS [ t_1.primary_key_id ] WHERE NOT (NOT ((t_3.bool_field1 != false OR t_3.int_field1 BETWEEN 1 and 9998)))
SELECT t_1.int_field1 , t_1.primary_key_id , t_1.varchar_field1 , t_1.bool_field1 FROM multiple_table_db_759_simple_table_10 t_4 INNER JOIN multiple_table_db_759_simple_table_2 t_1 ON KEYS [ t_4.primary_key_id ] WHERE NOT ((t_4.varchar_field1 < "ZoZPyPmsmP") AND (((t_4.char_field1 < "N") AND ((t_4.varchar_field1 >= "ZoZPyPmsmP") AND (t_4.varchar_field1 = "ZoZPyPmsmP"))) AND (t_4.varchar_field1 >= "ZoZPyPmsmP")))
Attachments
Issue Links
- duplicates
-
MB-23981 [RQG DYNAMIC INDEXING] Queries with count(*) with <NOT like> not using dynamic indexes
- Closed