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
13 WHERE routine_schema = 'db_storedproc'
14 ORDER BY routine_type, routine_name;
15
16
17 SHOW CREATE FUNCTION fn_1;
18 SHOW CREATE FUNCTION fn_2;
19 #SHOW CREATE FUNCTION fn_2b;
20
21 SHOW CREATE PROCEDURE sp_1;
22 SHOW CREATE PROCEDURE sp_2;
23
24
25 --replace_column 5 <modified> 6 <created>
26 SHOW FUNCTION STATUS LIKE 'fn_%';
27
28 --replace_column 5 <modified> 6 <created>
29 SHOW PROCEDURE STATUS LIKE 'sp_%';
30
31 --horizontal_results