maria-discuss team mailing list archive

[Federico Razzoli <federico_raz@xxxxxxxx>]

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