summaryrefslogtreecommitdiff
path: root/mysql-test/suite/funcs_1/storedproc/storedproc_08_show.inc
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/funcs_1/storedproc/storedproc_08_show.inc')
-rw-r--r--mysql-test/suite/funcs_1/storedproc/storedproc_08_show.inc9
1 files changed, 4 insertions, 5 deletions
diff --git a/mysql-test/suite/funcs_1/storedproc/storedproc_08_show.inc b/mysql-test/suite/funcs_1/storedproc/storedproc_08_show.inc
index 962d9242675..d6fd397561c 100644
--- a/mysql-test/suite/funcs_1/storedproc/storedproc_08_show.inc
+++ b/mysql-test/suite/funcs_1/storedproc/storedproc_08_show.inc
@@ -2,15 +2,14 @@
#
# used from .../storedproc_08.inc to show all created / altered routines
-let $message= ... now check what is stored:;
---source include/show_msg.inc
+--echo
+--echo ... now check what is stored:
+--echo -----------------------------
--vertical_results
-#--replace_column 16 "YYYY-MM-DD hh:mm:ss" 17 "YYYY-MM-DD hh:mm:ss"
-
--replace_column 16 <modified> 17 <created>
-SELECT * FROM information_schema.routines;
+SELECT * FROM information_schema.routines where routine_schema = 'db_storedproc';
SHOW CREATE FUNCTION fn_1;