WL#1363: Update the mysql.proc table and add new fields.

Also made the parsing and handling of SP characteristics
more general and extendable, and added a few ch:istics.


Docs/sp-imp-spec.txt:
  Updated spec with new schema.
Docs/sp-implemented.txt:
  Added info about ALTER and SHOW.
mysql-test/r/sp.result:
  Minor change in SHOW FUNCTION|PROCEDURE STATUS output.
scripts/mysql_create_system_tables.sh:
  New mysql.proc schema.
scripts/mysql_fix_privilege_tables.sql:
  New mysql.proc schema.
sql/lex.h:
  New lex words for SP characteristics.
sql/sp.cc:
  New mysql.proc schema.
  Also made the characteristics handling slightly more extendable.
sql/sp.h:
  Made the characteristics handling slightly more extendable.
sql/sp_head.cc:
  Made the characteristics handling slightly more extendable.
sql/sp_head.h:
  Made the characteristics handling slightly more extendable.
sql/sql_lex.h:
  Made the characteristics handling slightly more extendable.
sql/sql_parse.cc:
  Made the characteristics handling slightly more extendable.
sql/sql_yacc.yy:
  Made the characteristics handling slightly more extendable
  and made the parsing of characteristics more general, and
  added a few new dito. (LANGUAGE SQL, and [NOT] DETERMINISTIC
  for starters).

1 files changed, 4 insertions, 4 deletions

diff --git a/sql/sp.h b/sql/sp.h
index f957dd3c692..9bce886336d 100644
--- a/sql/sp.h
+++ b/sql/sp.h
@@ -33,7 +33,7 @@ sp_find_procedure(THD *thd, LEX_STRING *name);
 
 int
 sp_create_procedure(THD *thd, char *name, uint namelen, char *def, uint deflen,
-		    char *comment, uint commentlen, bool suid);
+		    st_sp_chistics *chistics);
 
 int
 sp_drop_procedure(THD *thd, char *name, uint namelen);
@@ -42,7 +42,7 @@ sp_drop_procedure(THD *thd, char *name, uint namelen);
 int
 sp_update_procedure(THD *thd, char *name, uint namelen,
 		    char *newname, uint newnamelen,
-		    char *comment, uint commentlen, enum suid_behaviour suid);
+		    st_sp_chistics *chistics);
 
 int
 sp_show_create_procedure(THD *thd, LEX_STRING *name);
@@ -55,7 +55,7 @@ sp_find_function(THD *thd, LEX_STRING *name);
 
 int
 sp_create_function(THD *thd, char *name, uint namelen, char *def, uint deflen,
-		   char *comment, uint commentlen, bool suid);
+		   st_sp_chistics *chistics);
 
 int
 sp_drop_function(THD *thd, char *name, uint namelen);
@@ -63,7 +63,7 @@ sp_drop_function(THD *thd, char *name, uint namelen);
 int
 sp_update_function(THD *thd, char *name, uint namelen,
 		   char *newname, uint newnamelen,
-		   char *comment, uint commentlen, enum suid_behaviour suid);
+		   st_sp_chistics *chistics);
 
 int
 sp_show_create_function(THD *thd, LEX_STRING *name);