maria-discuss team mailing list archive
Mailing list archive
Re: CREATE PROCEDURE clauses
Thank you! I wrote these info in the KB
Mar 3/9/13, Sergei Golubchik <serg@xxxxxxxxxxx> ha scritto:
Oggetto: Re: [Maria-discuss] CREATE PROCEDURE clauses
A: "Federico Razzoli" <federico_raz@xxxxxxxx>
Cc: "Mailing-List mariadb" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
Data: Martedì 3 settembre 2013, 09:13
On Sep 02, Federico Razzoli wrote:
> I wanted to add some info in the CREATE PROCEDURE page
in the KB, but
> I think that some info about CREATE PROCEDURE clauses
miss both in the
> kb and in the MySQL manual.
> * [NOT] DETERMINISTIC. From MySQL docs:
> "A routine is considered “deterministic” if it
always produces the
> same result for the same input parameters, and “not
> What does this exactly mean for procedures? OUT and
> Resultsets returned by the procedure? Both?
It doesn't really matter.
For stored functions, optimizer uses the value of [NOT]
optimize function calls.
But for procedures it's not used for anything, as far as I
> * NO SQL: As far as I understand, even SET is a SQL
statement. I guess
> that a "no sql" function is something like
> CREATE FUNCTION x(n INT) RETURNS INT
> RETURN n*2;
As far as I understand,
"NO SQL" means that there's no SQL in the routine *at all*.
Like,it might be written on C or ADA or whatever sql
<language clause> ::= LANGUAGE <language name>
<language name> ::=
| M | MUMPS
It's particularly important if a routine has the EXTERNAL
instead of the BEGIN ... END body.
But MariaDB does not support EXTERNAL or any other LANGUAGE
> I'm sorry if this info is already written somewhere,
but I really
> wasn't able to find it - and I feel that the KB should
> like these.
It's only on the SQL-99 Complete, Really pages: