i am not permited to view my functions

i log in as root
i create a one line function

it then says i'm not permuted to view it

i can execute show create function

> it then says i'm not permuted to view it

When exactly does "it" say that?

ok i connect 'very typically'

i go to query tab

i type

create function fn_df(d date) returns varchar(20) return date_format(d,'%d/%b/%Y')

i go to the DBs pane refresh on functions group click the func open the function on the right next to the buttons

help, discard and save 'you have no privileges to view this routine'

after writing the above "create function" statement, did you execute it ? ("Run" from query pane context menu, or F9)
just curious..

then, assuming that your last sentence means "click the func >will< open the function on the right next to the buttons ..." what happens before the error message ? what exactly happens when you click the function name ? screenshot ?

click the blue icon play i usually do that
or right click run selection when needed 'rare condition'

https://fbcdn-sphotos-e-a.akamaihd.net/hphotos-ak-ash3/812782_10151327861875326_308815839_o.jpg

no error i just can't edit it as usual

Ah, got it. HeidiSQL assumes a privilege error when the body of the routine is empty. It is not really empty in your case, but it is not surrounded by a BEGIN...END, which HeidiSQL expects. So, it turns out as a bug in HeidiSQL. Please try to confirm that, by adding the mentioned BEGIN/END.

Oh this is tricky to fix. I recently fixed another bug and opened this one instead.

That fixed the issue Thank you

Should be fixed in r4326. information_schema.ROUTINES.ROUTINE_DEFINITION is asked as an alternative way now.

That means - you should now be able to leave the BEGIN..END block away, should work with or without these.

i updated it and now it works as expected i'm very happy