maria-discuss team mailing list archive

[Peter Laursen <peter_laursen@xxxxxxxxxx>]

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@xxxxxxxx>
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@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
>  server.
>
>  Just my 5 cents on
>  this!
>
>
>  --
>  Peter-- Webyog
>
>
>  On Tue, Mar 3, 2015 at
>  12:31 PM, Federico Razzoli <federico_raz@xxxxxxxx>
>  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@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
>
>   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@xxxxxxxxxxxxxxxxxxx
>
>  Unsubscribe : https://launchpad.net/~maria-discuss
>
>  More help   : https://help.launchpad.net/ListHelp
>
>
>
>
> _______________________________________________
> 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
>