this is the first time i use toad for mysql to debug storeprocedure in mysql. my mysql server version is 5.1.58.
the debug process was interrupted everytime i debug the sp, and the crash point was diffrent in each time.
the following sql grammar are some crash point: "select ppl, ppl_1, grps, grps_1 into _ppl, _ppl_1, _grps, _grps_1 from t_grouping g join t_racecustomize rc on rc.grouping = g.id where rc.id = _racecustomizeid;"
"if(_match_role = 2) then"
can any buddy help me? because the sp is very complicated, so i need to debug it step by step..
you said toad for mysql didn't have a debugger tool, but i find the 'debug' option when i right click on my storeprocedure, and the IDE can start to debug. i even can see the local variable, and 'step in'/'step over' and so on.
but the debugger was interrupted after after several operations. am i have a wrong software installation?
I deleted Ernest's message because first of all it is inaccurate since Toad for MySQL has had a debugger for years and also I don't appreciate linking to competing products (Although I could live with it that if it wasn't for the fact that the everything else in the reply was inaccurate).
That said, it doesn't mean that there might not be bugs in it unfortunately. To fix this I would need to have a full stored procedure/function that could reproduce the issue. We are very close to releasing Toad for MySQL 6.0 though so if you can't get this to me fairly quickly unfortunately it wont make this release.