Details
-
Bug
-
Resolution: Fixed
-
Test Blocker
-
4.5.0
-
4.5.0-1712
-
Untriaged
-
Yes
Description
As part of rqg subquery run:
cen006-n1ql-vset04-01-rqg-subquery-multiple-table-primary-secondary-tests
Test run:
|
./testrunner -i adv.ini -t rqg.test_rqg.RQGTests.test_rqg_concurrent,test_file_path=b/resources/rqg/multiple_table_db/query_test_using_templates/query_50000_subquery.txt.zip,database=multiple_table_db,reset_database=True,concurreny_count=10,index_quota_percent=30,password=password,use_mysql=True,replicas=0,nodes_init=1,total_queries=2000,skip_cleanup=True
|
|
This test creates only primary indexes using gsi.
|
There is no crud operation during the test.
|
No indexes are created/dropped during the test.
|
It compares various subquery results from n1ql/s1l based on fields.
|
|
There was a mismatch in n1ql and sql subqueries.
|
Example of 1 such n1ql subquery:
|
SELECT t_1.* FROM simple_table_2 t_1 WHERE EXISTS (SELECT * FROM simple_table_10 t_4 USE KEYS META(t_1).id WHERE ((t_4.int_field1 != 5185 OR (t_4.varchar_field1 IS NOT NULL) AND (t_4.primary_key_id LIKE '549%'))) AND (((NOT (t_4.bool_field1) AND t_4.int_field1 > 5185)) AND (NOT ((t_4.primary_key_id IN [ "1" , "10" , "100" , "1000" , "101" ] AND t_4.int_field1 > 5185)))) );
|
|
I narrowed down the subquery to:
|
SELECT * FROM simple_table_10 t_4 WHERE (((NOT (t_4.bool_field1) AND t_4.int_field1 > 5185)) ) ;
|
|
This query can be executed only with primary index on simple_table_10.
|
This results 247 results in 4.5 while 258 results in 4.1
|
|
Uploading logs and dataset for both cases.
|