Debian Codegraph @

mysql-test/suite/funcs_1/storedproc/storedproc_08_show.inc

raw
1 #### suite/funcs_1/storedproc/storedproc_08_show.inc
2 #
3 # used from .../storedproc_08.inc to show all created / altered routines
4
5 --echo
6 --echo ... now check what is stored:
7 --echo -----------------------------
8
9 --vertical_results
10
11 --replace_column 24 <modified> 25 <created>
12 SELECT * FROM information_schema.routines where routine_schema = 'db_storedproc';
13
14
15 SHOW CREATE FUNCTION fn_1;
16 SHOW CREATE FUNCTION fn_2;
17 #SHOW CREATE FUNCTION fn_2b;
18
19 SHOW CREATE PROCEDURE sp_1;
20 SHOW CREATE PROCEDURE sp_2;
21
22
23 --replace_column 5 <modified> 6 <created>
24 SHOW FUNCTION STATUS LIKE 'fn_%';
25
26 --replace_column 5 <modified> 6 <created>
27 SHOW PROCEDURE STATUS LIKE 'sp_%';
28
29 --horizontal_results