[Phpmyadmin-devel] sql export : functions/routines

Dieter Adriaenssens dieter.adriaenssens at gmail.com
Tue Sep 14 19:37:06 CEST 2010


Hi,

2010/9/11 Marc Delisle <marc at infomarc.info>:
> Dieter Adriaenssens a écrit :
>> Hi all,
>>
>> Bug #3062455 (Functions/Procedures should come first in export),
>> suggest to export functions and procedures before views, because on
>> import, on error might occur when a view uses a function/procedure
>> that is not existent.
>>
>> Now, the export of Functions/Procedures/Events is done in PMA_exportDBFooter().
>> Is there any specific reason why they are exported last? Otherwise,
>> I'll move them to PMA_exportDBCreate(), and test if it works.
>>
> Dieter,
> please test if a function can be defined even if the tables it uses are
> not yet defined.

It is possible to define a routine (function/procedure) with a
non-existing table. An error message appears when executing the
routine, but not when creating it.

> P.S. I just made a test with current master and with either Quick or
> Custom methods, functions, procedures and events are missing from the
> export.

I guess they should be exported. ;)

> --
> Marc Delisle
> http://infomarc.info
>
> ------------------------------------------------------------------------------
> Start uncovering the many advantages of virtual appliances
> and start using them to simplify application deployment and
> accelerate your shift to cloud computing
> http://p.sf.net/sfu/novell-sfdev2dev
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>



-- 
Groetjes,

Dieter Adriaenssens




More information about the Developers mailing list