Re: Stored procedures comment too short

[Roland Bouman]

Stefano Locati wrote:
> I tried mysql-query-browser as you suggested and
> in fact it works. Thanks Roland. I had to compile
> it from sources since the standard linux rpm was
> core dumping at startup.

That's funny (I'm wandering along with you off topic for a while), that's what I am experiencing too. I always ran it on windows, no problemo. I installed both the Query Browser and the MySQL Administrator on Ubuntu linux (from rpm) and it after the login dialog, it gave me a 'could not found pcre' (or something like that) lib. (I found that out when starting up the executable from a command line shell, the errors appear in the shell, tha app crashes right after the login box)

I then made a symlink to one of the pcre's I found on the system, and then I got the administrator working. The query browser however still crashes directly when I click a node in the schema browser.

> The comment gets inserted correctly in the proc
> table. However SHOW PROCEDURE STATUS still limits
> the comment length to 64 chars.

Ok, what about information_schema.ROUTINE_COMMENT? I mean, what happens if you do:

select ROUTINE_COMMENT
from information_schema.ROUTINES

instead of

show procedure status



Edited 1 time(s). Last edit at 01/07/2006 03:18AM by Roland Bouman.