| Bug #14773 | INFORMATION_SCHEMA.routines data not showing | ||
|---|---|---|---|
| Submitted: | 8 Nov 2005 22:12 | Modified: | 10 Nov 2005 15:35 |
| Reporter: | [ name withheld ] | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 5.0.15 | OS: | Lynix |
| Assigned to: | MySQL Verification Team | CPU Architecture: | Any |
[8 Nov 2005 22:12]
[ name withheld ]
[8 Nov 2005 22:23]
MySQL Verification Team
I was unable to repeat the behavior reported with current source server:
miguel@hegel:~/dbs/5.0> bin/mysql -uroot test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.0.16-debug
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> delimiter //
mysql> create procedure sp1()
-> begin
-> select 1+1;
-> end //
Query OK, 0 rows affected (0.00 sec)
mysql> delimiter ;
mysql> select * from INFORMATION_SCHEMA.routines\G
*************************** 1. row ***************************
SPECIFIC_NAME: sp1
ROUTINE_CATALOG: NULL
ROUTINE_SCHEMA: test
ROUTINE_NAME: sp1
ROUTINE_TYPE: PROCEDURE
DTD_IDENTIFIER: NULL
ROUTINE_BODY: SQL
ROUTINE_DEFINITION: begin
select 1+1;
end
EXTERNAL_NAME: NULL
EXTERNAL_LANGUAGE: NULL
PARAMETER_STYLE: SQL
IS_DETERMINISTIC: NO
SQL_DATA_ACCESS: CONTAINS SQL
SQL_PATH: NULL
SECURITY_TYPE: DEFINER
CREATED: 2005-11-08 20:24:03
LAST_ALTERED: 2005-11-08 20:24:03
SQL_MODE:
ROUTINE_COMMENT:
DEFINER: root@localhost
1 row in set (0.00 sec)
mysql>
[10 Nov 2005 15:35]
[ name withheld ]
This problem started after I tried to stop/kill a running procedure.How can I get rid of the 1044 error
