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 <federico_raz@yahoo.it> 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 <peter_laursen@webyog.com> ha scritto:
Oggetto: Re: [Maria-discuss] stored programs A: "Federico Razzoli" <federico_raz@yahoo.it> Cc: "Maria Discuss" <maria-discuss@lists.launchpad.net> 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 <federico_raz@yahoo.it> 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 <serg@mariadb.org> ha scritto:
Oggetto: Re: [Maria-discuss] stored programs
A: "Federico Razzoli" <federico_raz@yahoo.it>
Cc: maria-discuss@lists.launchpad.net
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 : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp