Description:
When calling several stored procedures in a script, the statement gets out of synch with the result. The reported code doesn't match the results. The results are correct.
There is no reasonable work-around I can think of for this, but I hesitate to record it as critical.
How to repeat:
SQL:
drop procedure if exists tmp_test_synch;
create procedure tmp_test_synch(val integer)
select val;
Python code:
sql = """
-- one
call tmp_test_synch(1);
-- two
call tmp_test_synch(2);
-- three
call tmp_test_synch(3);
"""
for result in cur.execute(sql, multi=True):
if result.with_rows:
print("\n****statement****\n", result.statement[:120])
print( result.fetchall() )
Output:
****statement****
-- one
call tmp_test_synch(1)
[(1,)]
****statement****
-- three
call tmp_test_synch(3)
[(2,)]
****statement****
-- one
call tmp_test_synch(1)
[(3,)]
Suggested fix:
Obvious, I hope!
Description: When calling several stored procedures in a script, the statement gets out of synch with the result. The reported code doesn't match the results. The results are correct. There is no reasonable work-around I can think of for this, but I hesitate to record it as critical. How to repeat: SQL: drop procedure if exists tmp_test_synch; create procedure tmp_test_synch(val integer) select val; Python code: sql = """ -- one call tmp_test_synch(1); -- two call tmp_test_synch(2); -- three call tmp_test_synch(3); """ for result in cur.execute(sql, multi=True): if result.with_rows: print("\n****statement****\n", result.statement[:120]) print( result.fetchall() ) Output: ****statement**** -- one call tmp_test_synch(1) [(1,)] ****statement**** -- three call tmp_test_synch(3) [(2,)] ****statement**** -- one call tmp_test_synch(1) [(3,)] Suggested fix: Obvious, I hope!