rdebug_show_routine_statements

NAME

rdebug_show_routine_statements(): Show statement (breakpoint) IDs for a given routine.

TYPE

Procedure

DESCRIPTION

This procedure is part of the rdebug API.

rdebug_show_routine_statements() lists the statement/breakpoint IDs of a given routine. These IDs are eligible for rdebug_set_breakpoint(), and are presented in rdebug_show_routine() and rdebug_show_stack_state().

Execution of this routine is possible at any given time. When the specified routine has no debug info, rdebug_show_routine() simply shows its code.

SYNOPSIS

rdebug_show_routine_statements(
    in rdebug_routine_schema varchar(128) charset utf8,
    in rdebug_routine_name   varchar(128) charset utf8
  )
  READS SQL DATA

Input:

  • rdebug_routine_schema: schema where routine is located.
  • rdebug_routine_name: name of routine to show.

EXAMPLES

Show routine statement IDs: 

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 |
+----------------+--------------------+--------------+
Compare the above with output from rdebug_show_routine().

ENVIRONMENT

MySQL 5.1 or newer

SEE ALSO

rdebug_compile_routine(), rdebug_set_breakpoint(), rdebug_show_routine(), rdebug_show_stack_state()

AUTHOR

Shlomi Noach
 
common_schema documentation