/
rdebug_show_routine_statements.html
75 lines (66 loc) · 2.52 KB
/
rdebug_show_routine_statements.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
<h3>NAME</h3>
rdebug_show_routine_statements(): Show statement (breakpoint) IDs for a given routine.
<h3>TYPE</h3>
Procedure
<h3>DESCRIPTION</h3>
<p>
This procedure is part of the <a href="rdebug_api.html">rdebug API</a>.
</p>
<p>
<i>rdebug_show_routine_statements()</i> lists the statement/breakpoint IDs of a given
routine. These IDs are eligible for <a href="rdebug_set_breakpoint.html">rdebug_set_breakpoint()</a>,
and are presented in <a href="rdebug_show_routine.html">rdebug_show_routine()</a>
and <a href="rdebug_show_stack_state.html">rdebug_show_stack_state()</a>.
</p>
<p>
Execution of this routine is possible at any given time. When the specified routine
has no debug info, <i>rdebug_show_routine()</i> simply shows its code.
</p>
<h3>SYNOPSIS</h3>
<p>
<blockquote><pre>rdebug_show_routine_statements(
in rdebug_routine_schema varchar(128) charset utf8,
in rdebug_routine_name varchar(128) charset utf8
)
READS SQL DATA
</pre></blockquote>
</p>
<p>
Input:
<ul>
<li><strong>rdebug_routine_schema</strong>: schema where routine is located.
</li>
<li><strong>rdebug_routine_name</strong>: name of routine to show.
</li>
</ul>
</p>
<h3>EXAMPLES</h3>
<p>
Show routine statement IDs:
<blockquote><pre>mysql> call rdebug_show_routine_statements('test', 'analyze_continents');
+----------------+--------------------+--------------+
| routine_schema | routine_name | statement_id |
+----------------+--------------------+--------------+
| test | analyze_continents | 80 |
| test | analyze_continents | 86 |
| test | analyze_continents | 98 |
| test | analyze_continents | 108 |
| test | analyze_continents | 115 |
| test | analyze_continents | 121 |
| test | analyze_continents | 127 |
| test | analyze_continents | 136 |
| test | analyze_continents | 142 |
| test | analyze_continents | 147 |
+----------------+--------------------+--------------+
</pre></blockquote>
Compare the above with output from <a href="rdebug_show_routine.html">rdebug_show_routine()</a>.
</p>
<h3>ENVIRONMENT</h3>
MySQL 5.1 or newer
<h3>SEE ALSO</h3>
<a href="rdebug_compile_routine.html">rdebug_compile_routine()</a>,
<a href="rdebug_set_breakpoint.html">rdebug_set_breakpoint()</a>,
<a href="rdebug_show_routine.html">rdebug_show_routine()</a>,
<a href="rdebug_show_stack_state.html">rdebug_show_stack_state()</a>
<h3>AUTHOR</h3>
Shlomi Noach