|
Replies:
3
-
Pages:
1
-
Last Post:
Aug 14, 2011 5:29 PM
by: Mauritz
|
Threads:
[
Previous
|
Next
]
|
|
Posts:
3
Registered:
8/12/11
|
|
|
|
some thing wrong when i debug a storeprocedure.
Posted:
Aug 12, 2011 10:50 PM
|
|
|
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..
thanks~~~~
|
|
|
Posts:
3
Registered:
8/12/11
|
|
|
|
Re: some thing wrong when i debug a storeprocedure.
Posted:
Aug 13, 2011 12:38 AM
in response to: BananaSuper
|
|
|
ok, thank you very much.~
|
|
|
Posts:
3
Registered:
8/12/11
|
|
|
|
Re: some thing wrong when i debug a storeprocedure.
Posted:
Aug 13, 2011 5:13 AM
in response to: BananaSuper
|
|
|
hi buddy,
thanks for your reply,
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?
could you help me?
Thank you very much indeed.
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Re: some thing wrong when i debug a storeprocedure.
Posted:
Aug 14, 2011 5:29 PM
in response to: BananaSuper
|
|
|
Ok,
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.
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
