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