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
