RQG: Difference in results for sql update and n1ql update queries

Primary Indexes were created on buckets.

Test Case run:
./testrunner -i ${resource_tuq} -t rqg.test_rqg.RQGTests.test_rqg_crud_ops,test_file_path=b/resources/rqg/simple_table_db/query_tests_using_templates/crud_update_ops_50000.txt.zip,database=crud_db,reset_database=True,concurreny_count=1,index_quota_percent=60,password=password,use_mysql=True,replicas=0,merge_operation=True,crud_type=merge_update,total_queries=10000

Error:
2015-09-16 16:28:31 | INFO | MainProcess | Thread-11 | [tuq_helper.run_cbq_query] RUN QUERY delete from simple_table_9
2015-09-16 16:28:32 | INFO | MainProcess | Thread-11 | [rest_client.query_tool] query params : statement=delete+from+simple_table_9
2015-09-16 16:28:32 | INFO | MainProcess | Thread-7 | [test_rqg._run_queries_and_verify_crud] result from n1ql query returns 1000 items
2015-09-16 16:28:32 | INFO | MainProcess | Thread-7 | [test_rqg._run_queries_and_verify_crud] result from sql query returns 1000 items
2015-09-16 16:28:32 | INFO | MainProcess | Thread-3 | [test_rqg._run_queries_and_verify_crud] result from n1ql query returns 912 items
2015-09-16 16:28:32 | INFO | MainProcess | Thread-3 | [test_rqg._run_queries_and_verify_crud] result from sql query returns 1000 items
2015-09-16 16:28:32 | INFO | MainProcess | Thread-3 | [test_rqg._run_queries_and_verify_crud] Results are incorrect.Actual num 912. Expected num: 1000.:: mismatch in results :: expected :: [

{u'datetime_field1': '2005-01-18 00:00:00', u'int_field1': 8819, u'primary_key_id': u'159', u'varchar_field1': u'ivbuQVJzMJ', u'decimal_field1': 9883, u'char_field1': u'A', u'bool_field1': False}

,

{u'datetime_field1': '2005-09-21 00:00:00', u'int_field1': 9180, u'primary_key_id': u'248', u'varchar_field1': u'oHDMgZLhet', u'decimal_field1': 6444, u'char_field1': u'A', u'bool_field1': False}

,

{u'datetime_field1': '2005-10-14 00:00:00', u'int_field1': 7578, u'primary_key_id': u'905', u'varchar_field1': u'fKepfKQDcP', u'decimal_field1': 9176, u'char_field1': u'A', u'bool_field1': False}

,

{u'datetime_field1': '2006-07-16 00:00:00', u'int_field1': 9280, u'primary_key_id': u'109', u'varchar_field1': u'tXBCbzXNjd', u'decimal_field1': 4007, u'char_field1': u'A', u'bool_field1': False}

,

{u'datetime_field1': '2006-12-18 00:00:00', u'int_field1': 8344, u'primary_key_id': u'486', u'varchar_field1': u'FdmycUSeSP', u'decimal_field1': 519, u'char_field1': u'A', u'bool_field1': False}

], actual :: [

{u'datetime_field1': u'2005-01-18 00:00:00', u'bool_field1': False, u'primary_key_id': u'159', u'varchar_field1': u'ivbuQVJzMJ', u'decimal_field1': 9883, u'char_field1': u'A', u'int_field1': 8819}

,

{u'datetime_field1': u'2005-09-21 00:00:00', u'bool_field1': False, u'primary_key_id': u'248', u'varchar_field1': u'oHDMgZLhet', u'decimal_field1': 6444, u'char_field1': u'A', u'int_field1': 9180}

,

{u'datetime_field1': u'2005-10-14 00:00:00', u'bool_field1': False, u'primary_key_id': u'905', u'varchar_field1': u'fKepfKQDcP', u'decimal_field1': 9176, u'char_field1': u'A', u'int_field1': 7578}

,

{u'datetime_field1': u'2006-07-16 00:00:00', u'bool_field1': False, u'primary_key_id': u'109', u'varchar_field1': u'tXBCbzXNjd', u'decimal_field1': 4007, u'char_field1': u'A', u'int_field1': 9280}

,

{u'datetime_field1': u'2006-12-18 00:00:00', u'bool_field1': False, u'primary_key_id': u'486', u'varchar_field1': u'FdmycUSeSP', u'decimal_field1': 519, u'char_field1': u'A', u'int_field1': 8344}

]

2015-09-16 16:28:32 | INFO | MainProcess | Thread-3 | [tuq_helper.run_cbq_query] RUN QUERY MERGE INTO simple_table_1 USING copy_simple_table ON KEY copy_simple_table.primary_key_id WHEN MATCHED THEN UPDATE SET simple_table_1.char_field1 = 'I',simple_table_1.decimal_field1 = '8772',simple_table_1.datetime_field1 = '2009-12-08 00:00:00' WHERE (simple_table_1.char_field1 NOT BETWEEN "A" and "Z") AND ((simple_table_1.bool_field1 = false AND simple_table_1.decimal_field1 = 5109))

2015-09-16 16:28:32 | INFO | MainProcess | Thread-3 | [rest_client.query_tool] query params : statement=MERGE+INTO+simple_table_1+USING+copy_simple_table+ON+KEY+copy_simple_table.primary_key_id+WHEN+MATCHED+THEN+UPDATE+SET+simple_table_1.char_field1%3D+%27I%27%2Csimple_table_1.decimal_field1+%3D+%278772%27%2Csimple_table_1.datetime_field1+%3D%272009-12-08+00%3A00%3A00%27+WHERE+%28simple_table_1.char_field1+NOT+BETWEEN%22A%22+and+%22Z%22%29+AND+%28%28simple_table_1.bool_field1+%3D+false+AND+simple_table_1.decimal_field1+%3D+5109%29%29%0A+++
2015-09-16 16:28:32 | INFO | MainProcess | Thread-7 | [test_rqg._run_basic_crud_test] <<<<<<<<<<<<<<<<<<<<<<<<<<<< END RUNNING TEST 4 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
2015-09-16 16:28:32 | INFO | MainProcess | Thread-10 | [tuq_helper.run_cbq_query] TOTAL ELAPSED TIME: 1.76205013s
2015-09-16 16:28:32 | INFO | MainProcess | Thread-7 | [tuq_helper.run_cbq_query] RUN QUERY delete from simple_table_5
2015-09-16 16:28:32 | INFO | MainProcess | Thread-7 | [rest_client.query_tool] query params : statement=delete+from+simple_table_5
2015-09-16 16:28:33 | INFO | MainProcess | Thread-8 | [tuq_helper.run_cbq_query] TOTAL ELAPSED TIME: 2.040348372s
2015-09-16 16:28:33 | INFO | MainProcess | Thread-8 | [test_rqg._populate_delta_buckets] insert into simple_table_6(KEY k ,VALUE b) SELECT meta(b).id as k, b from copy_simple_table b
2015-09-16 16:28:33 | INFO | MainProcess | Thread-8 | [tuq_helper.run_cbq_query] RUN QUERY insert into simple_table_6(KEY k ,VALUE b) SELECT meta(b).id as k, b from copy_simple_table b
2015-09-16 16:28:33 | INFO | MainProcess | Thread-10 | [test_rqg._run_queries_and_verify_crud] result from n1ql query returns 950 items
2015-09-16 16:28:33 | INFO | MainProcess | Thread-10 | [test_rqg._run_queries_and_verify_crud] result from sql query returns 1000 items
2015-09-16 16:28:33 | INFO | MainProcess | Thread-8 | [rest_client.query_tool] query params : statement=insert+into+simple_table_6%28KEY+k+%2CVALUE+b%29+SELECT+meta%28b%29.id+as+k%2C+b+from+copy_simple_table+b
2015-09-16 16:28:33 | INFO | MainProcess | Thread-10 | [test_rqg._run_queries_and_verify_crud] Results are incorrect.Actual num 950. Expected num: 1000.:: mismatch in results :: expected :: [

{u'datetime_field1': '2005-01-18 00:00:00', u'int_field1': 8819, u'primary_key_id': u'159', u'varchar_field1': u'ivbuQVJzMJ', u'decimal_field1': 9883, u'char_field1': u'A', u'bool_field1': False}

,

{u'datetime_field1': '2005-09-21 00:00:00', u'int_field1': 9180, u'primary_key_id': u'248', u'varchar_field1': u'oHDMgZLhet', u'decimal_field1': 6444, u'char_field1': u'A', u'bool_field1': False}

,

{u'datetime_field1': '2005-10-14 00:00:00', u'int_field1': 7578, u'primary_key_id': u'905', u'varchar_field1': u'fKepfKQDcP', u'decimal_field1': 9176, u'char_field1': u'A', u'bool_field1': False}

,

{u'datetime_field1': '2006-07-16 00:00:00', u'int_field1': 9280, u'primary_key_id': u'109', u'varchar_field1': u'tXBCbzXNjd', u'decimal_field1': 4007, u'char_field1': u'A', u'bool_field1': False}

,

{u'datetime_field1': '2006-12-18 00:00:00', u'int_field1': 8344, u'primary_key_id': u'486', u'varchar_field1': u'FdmycUSeSP', u'decimal_field1': 519, u'char_field1': u'A', u'bool_field1': False}

], actual :: [

{u'datetime_field1': u'2005-01-18 00:00:00', u'bool_field1': False, u'primary_key_id': u'159', u'varchar_field1': u'ivbuQVJzMJ', u'decimal_field1': 9883, u'char_field1': u'A', u'int_field1': 8819}

,

{u'datetime_field1': u'2005-09-21 00:00:00', u'bool_field1': False, u'primary_key_id': u'248', u'varchar_field1': u'oHDMgZLhet', u'decimal_field1': 6444, u'char_field1': u'A', u'int_field1': 9180}

,

{u'datetime_field1': u'2005-10-14 00:00:00', u'bool_field1': False, u'primary_key_id': u'905', u'varchar_field1': u'fKepfKQDcP', u'decimal_field1': 9176, u'char_field1': u'A', u'int_field1': 7578}

,

{u'datetime_field1': u'2006-07-16 00:00:00', u'bool_field1': False, u'primary_key_id': u'109', u'varchar_field1': u'tXBCbzXNjd', u'decimal_field1': 4007, u'char_field1': u'A', u'int_field1': 9280}

,

{u'datetime_field1': u'2006-12-18 00:00:00', u'bool_field1': False, u'primary_key_id': u'486', u'varchar_field1': u'FdmycUSeSP', u'decimal_field1': 519, u'char_field1': u'A', u'int_field1': 8344}

]

2015-09-16 16:28:33 | INFO | MainProcess | Thread-10 | [tuq_helper.run_cbq_query] RUN QUERY MERGE INTO simple_table_8 USING copy_simple_table ON KEY copy_simple_table.primary_key_id WHEN MATCHED THEN UPDATE SET simple_table_8.char_field1 = 'R',simple_table_8.decimal_field1 = '1107',simple_table_8.datetime_field1 = '2003-04-25 00:00:00' WHERE ((simple_table_8.bool_field1 AND simple_table_8.varchar_field1 IN [ "AAlGtqtYJs" , "ADfhQaZmhR" , "AKOmvVZzgj" , "ATsGRspfTh" , "AXwchHaiAQ" ])) AND ((simple_table_8.bool_field1 OR simple_table_8.int_field1 < 5103)) OR (NOT (simple_table_8.primary_key_id > "549")) AND ((simple_table_8.bool_field1 = false AND simple_table_8.primary_key_id > "549"))