Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
zhaomingminghit opened this issue Nov 4, 2020 · 3 comments

Comments

@zhaomingminghit
Copy link

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
Copy link
Author

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

@jerry57
Copy link
Collaborator

jerry57 commented Dec 11, 2020

What happens if you try:

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

@zhaomingminghit
Copy link
Author

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants