A MySQL database is using a stored function avg_sales in some SQL queries. I am having a hard time finding the code for this function, in order to track down a bug that I suspect is in the function. Here is what I get when I try to query MySQL for the function code:
mysql> SHOW CREATE FUNCTION avg_sales; +-----------+----------+-----------------+----------------------+----------------------+--------------------+ | Function | sql_mode | Create Function | character_set_client | collation_connection | Database Collation | +-----------+----------+-----------------+----------------------+----------------------+--------------------+ | avg_sales | | NULL | latin1 | latin1_swedish_ci | utf8_general_ci | +-----------+----------+-----------------+----------------------+----------------------+--------------------+ 1 row in set (0.00 sec)
mysql> SHOW CREATE PROCEDURE avg_sales; ERROR 1305 (42000): PROCEDURE avg_sales does not exist mysql> SELECT ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES; +--------------------+ | ROUTINE_DEFINITION | +--------------------+ | NULL | | NULL | +--------------------+ 2 rows in set (0.00 sec)
mysql> SELECT param_list,returns,body FROM mysql.proc; ERROR 1142 (42000): SELECT command denied to user '********'@'localhost' for table 'proc' mysql>
What else should I try to get the code? This is on MySQL 5.1.61 running on CentOS. Thanks.
-- Dotan Cohen
http://gibberish.co.il http://what-is-what.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Mar 24
Peter Brawley Re: Show ROUTINE body, not PROCEDURE
Mar 24, 2013; 16:08
Peter Brawley
Re: Show ROUTINE body, not PROCEDURE
Mar 25
Dotan Cohen Re: Show ROUTINE body, not PROCEDURE
Mar 25, 2013; 11:28
Dotan Cohen
Re: Show ROUTINE body, not PROCEDURE
Mar 25
Peter Brawley Re: Show ROUTINE body, not PROCEDURE
Mar 25, 2013; 09:47
Peter Brawley
Re: Show ROUTINE body, not PROCEDURE
Mar 25
hsv Re: Show ROUTINE body, not PROCEDURE
Mar 25, 2013; 19:09
hsv
Re: Show ROUTINE body, not PROCEDURE
Mar 27
hsv Re: Show ROUTINE body, not PROCEDURE
Mar 27, 2013; 10:46
hsv
Re: Show ROUTINE body, not PROCEDURE
Mar 28
Dotan Cohen Re: Show ROUTINE body, not PROCEDURE
Mar 28, 2013; 22:33
Dotan Cohen
Re: Show ROUTINE body, not PROCEDURE
Mar 28
Peter Brawley Re: Show ROUTINE body, not PROCEDURE
Mar 28, 2013; 16:15
Peter Brawley
Re: Show ROUTINE body, not PROCEDURE
Mar 29
Dotan Cohen Re: Show ROUTINE body, not PROCEDURE
Mar 29, 2013; 17:57
Dotan Cohen
Re: Show ROUTINE body, not PROCEDURE
Mar 29
Peter Brawley Re: Show ROUTINE body, not PROCEDURE
Mar 29, 2013; 10:17
Peter Brawley
Re: Show ROUTINE body, not PROCEDURE
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!