Details
Description
This RQG test failed:
./testrunner -i /root/tuqvm.ini -t rqg.test_rqg.RQGTests.test_rqg_crud_ops,test_file_path=b/resources/rqg/simple_table_db/query_tests_using_templates/crud_delete_ops_50000.txt.zip,database=crud_db,reset_database=True,concurreny_count=1,index_quota_percent=30,password=password,use_mysql=True,replicas=0,merge_operation=True,total_queries=10000,crud_type=delete
Error:
____________________________________________________
Scenario :: crud_verification_test
Reason :: CBQError: host 172.23.106.40: ERROR:{u'status': u'errors', u'errors': [
], u'results': [], u'metrics':
{u'elapsedTime': u'77.467189ms', u'executionTime': u'77.359494ms', u'resultSize': 0, u'resultCount': 0, u'errorCount': 1}, u'requestID': u'6b61b3d1-0b71-4c8c-9317-a1b197f85ff6', u'signature': None}
sql_query :: DELETE FROM simple_table_3 WHERE ((primary_key_id < "549" AND int_field1 IS NOT NULL)) AND ((char_field1 LIKE "N" AND decimal_field1 < 4849)) OR ((bool_field1 = false AND primary_key_id <= "549")) AND ((bool_field1 AND int_field1 IS NOT NULL));
n1ql_query :: DELETE FROM simple_table_3 WHERE ((primary_key_id < "549" AND int_field1 IS NOT NULL)) AND ((char_field1 LIKE "N" AND decimal_field1 < 4849)) OR ((bool_field1 = false AND primary_key_id <= "549")) AND ((bool_field1 AND int_field1 IS NOT NULL));
<<<<<<<<<< TEST 10 >>>>>>>>>>>
keyword_list :: ['AND', 'BETWEEN', 'DELETE', 'LET', 'NOT']
run_result ::
____________________________________________________
Scenario :: crud_verification_test
Reason :: Results are incorrect.Actual num 984. Expected num: 1000.:: mismatch in results :: expected :: [
,
{u'datetime_field1': '2000-12-17 00:00:00', u'int_field1': 5477, u'primary_key_id': u'807', u'varchar_field1': u'zieLViHgTF', u'decimal_field1': 5326, u'char_field1': u'A', u'bool_field1': False},
{u'datetime_field1': '2002-04-25 00:00:00', u'int_field1': 9500, u'primary_key_id': u'387', u'varchar_field1': u'BOtIGaqXqt', u'decimal_field1': 7875, u'char_field1': u'A', u'bool_field1': False},
{u'datetime_field1': '2002-06-15 00:00:00', u'int_field1': 4092, u'primary_key_id': u'107', u'varchar_field1': u'ALZUdbeeUr', u'decimal_field1': 3335, u'char_field1': u'A', u'bool_field1': False},
{u'datetime_field1': '2003-06-28 00:00:00', u'int_field1': 1665, u'primary_key_id': u'438', u'varchar_field1': u'aKmwCTgJvQ', u'decimal_field1': 2048, u'char_field1': u'A', u'bool_field1': False}], actual :: [
{u'datetime_field1': u'2000-12-10 00:00:00', u'bool_field1': False, u'primary_key_id': u'716', u'varchar_field1': u'XldMmfTOWd', u'decimal_field1': 5955, u'char_field1': u'A', u'int_field1': 1591},
{u'datetime_field1': u'2000-12-17 00:00:00', u'bool_field1': False, u'primary_key_id': u'807', u'varchar_field1': u'zieLViHgTF', u'decimal_field1': 5326, u'char_field1': u'A', u'int_field1': 5477},
{u'datetime_field1': u'2002-04-25 00:00:00', u'bool_field1': False, u'primary_key_id': u'387', u'varchar_field1': u'BOtIGaqXqt', u'decimal_field1': 7875, u'char_field1': u'A', u'int_field1': 9500},
{u'datetime_field1': u'2002-06-15 00:00:00', u'bool_field1': False, u'primary_key_id': u'107', u'varchar_field1': u'ALZUdbeeUr', u'decimal_field1': 3335, u'char_field1': u'A', u'int_field1': 4092},
{u'datetime_field1': u'2003-06-28 00:00:00', u'bool_field1': False, u'primary_key_id': u'438', u'varchar_field1': u'aKmwCTgJvQ', u'decimal_field1': 2048, u'char_field1': u'A', u'int_field1': 1665}]
sql_query :: DELETE FROM simple_table_2 WHERE (bool_field1 AND varchar_field1 NOT BETWEEN "AArPyqfxSB" and "zieLViHgTF");
n1ql_query :: DELETE FROM simple_table_2 WHERE (bool_field1 AND varchar_field1 NOT BETWEEN "AArPyqfxSB" and "zieLViHgTF");
<<<<<<<<<< TEST 13 >>>>>>>>>>>
keyword_list :: [' < ', 'AND', 'DELETE', 'FALSE', 'KEY', 'LET']
run_result ::
____________________________________________________
Scenario :: crud_verification_test
Reason :: Results are incorrect.Actual num 745. Expected num: 744.:: mismatch in results :: expected :: [
,
{u'datetime_field1': '2000-12-17 00:00:00', u'int_field1': 5477, u'primary_key_id': u'807', u'varchar_field1': u'zieLViHgTF', u'decimal_field1': 5326, u'char_field1': u'A', u'bool_field1': False},
{u'datetime_field1': '2002-04-25 00:00:00', u'int_field1': 9500, u'primary_key_id': u'387', u'varchar_field1': u'BOtIGaqXqt', u'decimal_field1': 7875, u'char_field1': u'A', u'bool_field1': False},
{u'datetime_field1': '2002-06-15 00:00:00', u'int_field1': 4092, u'primary_key_id': u'107', u'varchar_field1': u'ALZUdbeeUr', u'decimal_field1': 3335, u'char_field1': u'A', u'bool_field1': False},
{u'datetime_field1': '2003-06-28 00:00:00', u'int_field1': 1665, u'primary_key_id': u'438', u'varchar_field1': u'aKmwCTgJvQ', u'decimal_field1': 2048, u'char_field1': u'A', u'bool_field1': False}], actual :: [
{u'datetime_field1': u'2000-12-10 00:00:00', u'bool_field1': False, u'primary_key_id': u'716', u'varchar_field1': u'XldMmfTOWd', u'decimal_field1': 5955, u'char_field1': u'A', u'int_field1': 1591},
{u'datetime_field1': u'2000-12-17 00:00:00', u'bool_field1': False, u'primary_key_id': u'807', u'varchar_field1': u'zieLViHgTF', u'decimal_field1': 5326, u'char_field1': u'A', u'int_field1': 5477},
{u'datetime_field1': u'2002-04-25 00:00:00', u'bool_field1': False, u'primary_key_id': u'387', u'varchar_field1': u'BOtIGaqXqt', u'decimal_field1': 7875, u'char_field1': u'A', u'int_field1': 9500},
{u'datetime_field1': u'2002-06-15 00:00:00', u'bool_field1': False, u'primary_key_id': u'107', u'varchar_field1': u'ALZUdbeeUr', u'decimal_field1': 3335, u'char_field1': u'A', u'int_field1': 4092},
{u'datetime_field1': u'2003-06-28 00:00:00', u'bool_field1': False, u'primary_key_id': u'438', u'varchar_field1': u'aKmwCTgJvQ', u'decimal_field1': 2048, u'char_field1': u'A', u'int_field1': 1665}]
sql_query :: DELETE FROM simple_table_5 WHERE ((decimal_field1 != 4849 AND primary_key_id < "549" AND bool_field1 != false)) AND (bool_field1);
n1ql_query :: DELETE FROM simple_table_5 WHERE ((decimal_field1 != 4849 AND primary_key_id < "549" AND bool_field1 != false)) AND (bool_field1);
<<<<<<<<<< TEST 12 >>>>>>>>>>>
keyword_list :: ['DELETE', 'IN', 'IS', 'LET', 'NOT', 'NULL', 'OR']
run_result ::
____________________________________________________
Scenario :: crud_verification_test
Reason :: Results are incorrect.Actual num 931. Expected num: 1000.:: mismatch in results :: expected :: [
,
{u'datetime_field1': '2000-12-17 00:00:00', u'int_field1': 5477, u'primary_key_id': u'807', u'varchar_field1': u'zieLViHgTF', u'decimal_field1': 5326, u'char_field1': u'A', u'bool_field1': False},
{u'datetime_field1': '2002-04-25 00:00:00', u'int_field1': 9500, u'primary_key_id': u'387', u'varchar_field1': u'BOtIGaqXqt', u'decimal_field1': 7875, u'char_field1': u'A', u'bool_field1': False},
{u'datetime_field1': '2002-06-15 00:00:00', u'int_field1': 4092, u'primary_key_id': u'107', u'varchar_field1': u'ALZUdbeeUr', u'decimal_field1': 3335, u'char_field1': u'A', u'bool_field1': False},
{u'datetime_field1': '2003-06-28 00:00:00', u'int_field1': 1665, u'primary_key_id': u'438', u'varchar_field1': u'aKmwCTgJvQ', u'decimal_field1': 2048, u'char_field1': u'A', u'bool_field1': False}], actual :: [
{u'datetime_field1': u'2000-12-10 00:00:00', u'bool_field1': False, u'primary_key_id': u'716', u'varchar_field1': u'XldMmfTOWd', u'decimal_field1': 5955, u'char_field1': u'A', u'int_field1': 1591},
{u'datetime_field1': u'2000-12-17 00:00:00', u'bool_field1': False, u'primary_key_id': u'807', u'varchar_field1': u'zieLViHgTF', u'decimal_field1': 5326, u'char_field1': u'A', u'int_field1': 5477},
{u'datetime_field1': u'2002-04-25 00:00:00', u'bool_field1': False, u'primary_key_id': u'387', u'varchar_field1': u'BOtIGaqXqt', u'decimal_field1': 7875, u'char_field1': u'A', u'int_field1': 9500},
{u'datetime_field1': u'2002-06-15 00:00:00', u'bool_field1': False, u'primary_key_id': u'107', u'varchar_field1': u'ALZUdbeeUr', u'decimal_field1': 3335, u'char_field1': u'A', u'int_field1': 4092},
{u'datetime_field1': u'2003-06-28 00:00:00', u'bool_field1': False, u'primary_key_id': u'438', u'varchar_field1': u'aKmwCTgJvQ', u'decimal_field1': 2048, u'char_field1': u'A', u'int_field1': 1665}]
sql_query :: DELETE FROM simple_table_4 WHERE NOT ((bool_field1 OR int_field1 IS NOT NULL));
n1ql_query :: DELETE FROM simple_table_4 WHERE NOT ((bool_field1 OR int_field1 IS NOT NULL));
<<<<<<<<<< TEST 15 >>>>>>>>>>>
keyword_list :: ['AND', 'DELETE', 'FALSE', 'IS', 'LET', 'NOT', 'NULL']
run_result ::