← Back to team overview

maria-discuss team mailing list archive

Re: stored programs


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.


Mar 3/3/15, Peter Laursen <peter_laursen@xxxxxxxxxx> ha scritto:

 Oggetto: Re: [Maria-discuss] stored programs
 A: "Federico Razzoli" <federico_raz@xxxxxxxx>
 Cc: "Maria Discuss" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
 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
 Just my 5 cents on
 Peter-- Webyog
 On Tue, Mar 3, 2015 at
 12:31 PM, Federico Razzoli <federico_raz@xxxxxxxx>
 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.
 Mar 3/3/15, Sergei Golubchik <serg@xxxxxxxxxxx>
 ha scritto:
  Oggetto: Re: [Maria-discuss] stored programs
  A: "Federico Razzoli" <federico_raz@xxxxxxxx>
  Cc: maria-discuss@xxxxxxxxxxxxxxxxxxx
  Data: Martedì 3 marzo 2015, 10:48
  Hi, Federico!
  On Mar 03, Federico Razzoli
  > 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,
  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
  procedures and functions will follow
  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).
  don't understand what exactly missing feature that
  had in mind.
  It couldn't have been
  "CREATE OR REPLACE", this seems so minor.
  Or was it?
 Mailing list: https://launchpad.net/~maria-discuss
 Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
 Unsubscribe : https://launchpad.net/~maria-discuss
 More help   : https://help.launchpad.net/ListHelp

Follow ups