Bugs when using python packages to call store procedure

Help
1

Hi team:

I met a problem when using python packages: MySQLdb & mysql.connector to call store procedure.

Scenario A:
Use singlestore studio to run “call sp(argList)” command, everything seems exactly working

Scenario B:
Use python package cursor.callproc(sp, argList) method, return error

Scenario C:
Use python package cursor.execute(“call sp(argList)”) method, can return final query result, while all actions included in the store procedure like update operations is totally not reflect to the result

We think this is a critical bug of singlestore, please kindly help to check and help us, thanks a lot.

Environment & Background:
SingleStore DB Version: 7.3.10

B.R.

2

Dear B.R. – thanks for the feedback.

What error did you get for Scenario B?

Can you explain more what you mean by “Scenario C … while all actions included in the store procedure like update operations is totally not reflect to the result”?

1 Like