I wrote that I did not try it and did not know how it works. I thought it was less prmitive.
BTW: wrote this blog long time ago too: http://blog.webyog.com/2011/12/06/debugging-stored-programs-in-mysql/ - so I fully agree! - Peter On Tue, Mar 3, 2015 at 2:05 PM, Federico Razzoli <[email protected]> wrote: > Just a note about Oracle's "debugger": it is not a debugger. A debugger is > a server feature that exposes an API for the execution control and > variables inspecting. Oracle's "debugger" is just a tool that adds debug > code to our stored procedure. Which is acceptable from third-party > "debuggers", but quite ridicolous if it comes from MySQL's vendor. > > I don't consider this kind of solutions reliable... and I don't think that > stored procedure developers should be forced to buy Microsoft products. > > Regards > Federico > > > -------------------------------------------- > Mar 3/3/15, Peter Laursen <[email protected]> ha scritto: > > Oggetto: Re: [Maria-discuss] stored programs > A: "Federico Razzoli" <[email protected]> > Cc: "Maria Discuss" <[email protected]> > Data: Martedì 3 marzo 2015, 12:48 > > 1) +1 for > "ability to > prepare a statement from a local variable" what I > requested 6½ years ago: http://bugs.mysql.com/bug.php?id=40038 > 2) I agree that no > debugging facility is a serious limitation (though Oracle > claim that their "MySQL for Visual Studio" > can do it (with Visual Studio on Windows obviously). I > have not tried). > 3) another (supplementary) language > for stored programs. This has been discussed before in > severalcontexts. Problem is that there is no 'fit' > language being cross-platform. PostgreSQl has Perl, SQL > Server as C#. The current 'sp language' (for loops, > conditions etc.) is based on ADA. 'Adascript' > implementations (covering around 60% of full ADA, I think) > exist and could be considered. Or LUA that looks somewhat > similar. But the interpreter will need to ship with the > server. > > Just my 5 cents on > this! > > > -- > Peter-- Webyog > > > On Tue, Mar 3, 2015 at > 12:31 PM, Federico Razzoli <[email protected]> > wrote: > Hi > Sergej > > > > No, it was something more general. Performance is not > sufficient, there is no debugging facility, and stored > programs are not flexible enough. Arrays, variable number of > arguments and the ability to prepare a statement from a > local variable would help a lot. Or perhaps, the ability to > use a language other than SQL would be a solution. > > > > I used the OR REPLACE clause to point out that both MariaDB > and MySQL development is very slow (if any) when it comes to > stored programs. As a user and a MariaDB lover, I think that > this is a pity. > > > > Regards > > Federico > > > > > > -------------------------------------------- > > Mar 3/3/15, Sergei Golubchik <[email protected]> > ha scritto: > > > > Oggetto: Re: [Maria-discuss] stored programs > > A: "Federico Razzoli" <[email protected]> > > Cc: [email protected] > > Data: Martedì 3 marzo 2015, 10:48 > > > > 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
