I was responding to Sergei Sent from my iPhone
> On Mar 3, 2015, at 6:22 AM, Peter Laursen <[email protected]> wrote: > > If this "You can't drop a busy proc in production to replace it" was for me, > then note the passage from my blog: > > "you can add a IN-parameter (debug: integer) to a Stored Procedure > paramer-list and CALL mysp(….,0|1) what would then control if the stored > program should enter or bypass debugging code when executing". This is the > best workaround I've found. > >> On Tue, Mar 3, 2015 at 2:17 PM, Justin Swanhart <[email protected]> wrote: >> You can't drop a busy proc in production to replace it. Many users would >> get an error. This is the same reason views have had CoR for so long. So >> yes it is a big deal! >> >> Anyway, what I want most are Antony Curtis' stored proc / parser changes >> (mdev 820 if I'm not mistaken). I am especially interested in table >> functions and external stored routines. >> >> I'd also like to discuss window functions too. I've implemented them in >> shard-query and have ideas about how to implement them in the server, but >> pluggable parser would be really useful here. >> >> --Justin >> >> Sent from my iPhone >> >> > On Mar 3, 2015, at 2:48 AM, Sergei Golubchik <[email protected]> wrote: >> > >> > Hi, Federico! >> > >> >> On Mar 03, Federico Razzoli wrote: >> >> Reading 10.0.3 release notes: >> >> >> >> https://mariadb.com/kb/en/mariadb/mariadb-1013-release-notes/ >> >> >> >> I see that IF EXISTS, IF NOT EXISTS and OR REPLACE are now almost >> >> consistent. "Almost" means that... OR REPLACE still doesn't apply to >> >> stored procedures, functions, triggers, events. >> > >> > Support for events is already pushed (albeit after 10.1.3). >> > Support for triggers will be pushed any day now (already reviewed and >> > approved, so there's no more work left on it). I suppose that stored >> > procedures and functions will follow soon. >> > >> > This was a GSoC 2014 project that added support for these clauses to >> > *all* objects. It's just being pushed piecewise, object by object. >> > >> >> Recently, during a public session, a PostgreSQL user asked me if >> >> MariaDB supports stored procedures - in his opinion, MySQL doesn't, no >> >> matter what the manual says. Unfortunately my answer was that MariaDB >> >> support for stored procedure is the same as MySQL ("so the answer is >> >> no", he said). >> > >> > I don't understand what exactly missing feature that user had in mind. >> > It couldn't have been "CREATE OR REPLACE", this seems so minor. >> > Or was it? >> > >> > Regards, >> > Sergei >> > >> > _______________________________________________ >> > Mailing list: https://launchpad.net/~maria-discuss >> > Post to : [email protected] >> > Unsubscribe : https://launchpad.net/~maria-discuss >> > More help : https://help.launchpad.net/ListHelp >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~maria-discuss >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~maria-discuss >> More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
