Re: Stored procedures comment too short

[Roland Bouman]

Stefano Locati wrote:
> I'm using Fedora Core 4, the compiled version of
> mysql-query-browser is stable. To compile it is
> not difficult, in theory just a matter of
> ./configure ; make ; make install on
> mysql-gui-common and mysql-query-browser (both
> directories are in the tgz containing the source
> code).
>
> In practice I had to install a few development
> packages to make configure work and i had to run
> configure telling which gtkhtml library to use
> since it defaults to version 3.0 ./configure
> --with-gtkhtml=libgtkhtml-3.6
>

Ok thanks for the tips. I will try this (I'm just delvinf into linux, and I compiled Apache and Php, also using such a ./configure script. It shouldn't be too much of a problem. Thanks again!)

> Yes, even
>
> select ROUTINE_COMMENT
> from information_schema.ROUTINES
>
> gives the same result and in fact if I ask to
> describe the table
>
> mysql> desc information_schema.ROUTINES;
>
> ....
> | ROUTINE_COMMENT | varchar(64) | NO |
> | | |
> ....
> Further this table can't be altered - maybe
> because it's a memory table or a table reserved
> for mysql internal use.
>

Ok, well it was worth a try. I'm aware it could not be altered but I hoped it might automagically understand to stretch the comment column to match the definition in the proc table. Thanks for trying.


Roland.