[Phpmyadmin-devel] GSoC 2011: Support for Routines

[Aris Feryanto]

----- Original Message -----
> From: Rouslan Placella <rouslan at placella.com>
> 
> On Mon, 2011-06-13 at 00:21 +0200, Dieter Adriaenssens wrote:
>>  2011/6/13 Rouslan Placella <rouslan at placella.com>:
>>  > On Sun, 2011-06-12 at 21:19 +0200, Dieter Adriaenssens wrote:
>>  >> 2011/6/12 Rouslan Placella <rouslan at placella.com>:
>>  >> > On Sun, 2011-06-05 at 20:23 +0100, Rouslan Placella wrote:
>>  >> >> Hi there,
>>  >> >>
>>  >> >> I've had good progress this week with my work on 
> support for routines
>>  >> >> and if you guys have some time I'd be very grateful 
> if you could check
>>  >> >> out the currently implemented functionality on my demo 
> server [1] and,
>>  >> >> if you have extra time on your hands, also the code in my 
> repo [2].
>>  >> >> Currently the "Add", "Edit", 
> "Export" and "Drop" functionalities work
>>  >> >> well and are already integrated with AJAX. But the 
> execute functionality
>>  >> >> is unfinished and doesn't really work too well yet 
> with or without AJAX
>>  >> >> - it's what I'll be working on next week. Any 
> feedback is most welcome!
>>  >> >> Thanks.
>>  >>
>>  >> Hi Rouslan,
>>  >>
>>  >> Looks good. I was able to add, edit, execute, export and drop a 
> routine.

Hi Rouslan,

The edit and drop not work for me in the demo server. But, when I checkout your code and test it locally, it just work fine.

The scenario:
- In the demo server, I goto sakila db
- Under Routines, click Edit in "inventory_in_stock"
- Add some comment
- Click "Go" button

And I got error:

Query "DROP FUNCTION `inventory_in_stock`; " failed
MySQL said: #1146 - Table 'mysql.columns_priv' doesn't exist


 
--
Aris Feryanto