Re: Stored procedures comment too short
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.
Subject
Views
Written By
Posted
2184
January 03, 2006 05:53AM
1365
January 04, 2006 09:09PM
1708
January 06, 2006 08:46PM
Re: Stored procedures comment too short
1478
January 07, 2006 03:17AM
1438
January 07, 2006 02:45PM
1504
January 08, 2006 03:18AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.