execute_sql_string() will be suspend when there's an error in executing sqlString like primary key conflict
sqlString like below and sansTran=False: insert into table1 values(xxx);insert into table2 values(xxx); and there's an primary key conflict error when running 'insert into table2 values(xxx)' then, execute_sql_string() will be suspend after log 'Executing : Execute SQL String | xxxxxx'
script like below and version=1.2.4 Connect_To_Database_Using_Custom_Params pymysql db='xxx'... execute_sql_string insert into table1 values(xxx);insert into table2 values(xxx); Disconnect_from_database
if only run execute_sql_string insert into table2 values(xxx); the primary key conflict error will be displayed normally
What happens if you try:
execute_sql_string begin; insert into table1 values(xxx);insert into table2 values(xxx); end;
What happens if you try:
execute_sql_string begin; insert into table1 values(xxx);insert into table2 values(xxx); end;
it will also suspend when i run "execute_sql_string begin; insert into table1 values(xxx);insert into table2 values(xxx); end;"