Robotframework-Database-Library icon indicating copy to clipboard operation
Robotframework-Database-Library copied to clipboard

execute_sql_string() will be suspend when there's an error in executing sqlString like primary key conflict

Open zhaomingminghit opened this issue 5 years ago • 3 comments

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'

zhaomingminghit avatar Nov 04 '20 09:11 zhaomingminghit

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

zhaomingminghit avatar Nov 04 '20 09:11 zhaomingminghit

What happens if you try:

execute_sql_string begin; insert into table1 values(xxx);insert into table2 values(xxx); end;

jerry57 avatar Dec 11 '20 05:12 jerry57

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;"

zhaomingminghit avatar Jan 15 '21 03:01 zhaomingminghit