diff options
| author | pem@mysql.comhem.se <> | 2003-12-12 14:05:29 +0100 |
|---|---|---|
| committer | pem@mysql.comhem.se <> | 2003-12-12 14:05:29 +0100 |
| commit | 7a20e5282e6048c3ef33f1e1bc049aff7ad1a3b8 (patch) | |
| tree | f518c8cbe887552b0437489a710a7050031bc2f1 /Docs/sp-imp-spec.txt | |
| parent | 7bfbfc308f4c198860964c0aef6765a4b47eb252 (diff) | |
| download | mariadb-git-7a20e5282e6048c3ef33f1e1bc049aff7ad1a3b8.tar.gz | |
In order to make ALTER PROCEDURE|FUNCTION work correctly, and in general to
make characteristics (and SHOW) work right, we had to separate the old
definition blob in the mysql.proc table into separate fields for parameters,
return type, and body, and handle the characteristics (like SQL SECURITY)
separately... and then reassemble the CREATE string for parsing, of course.
This is rather ugly, mostly the parser bit. (Hopefully that will be better
with the new parser.)
Diffstat (limited to 'Docs/sp-imp-spec.txt')
| -rw-r--r-- | Docs/sp-imp-spec.txt | 11 |
1 files changed, 7 insertions, 4 deletions
diff --git a/Docs/sp-imp-spec.txt b/Docs/sp-imp-spec.txt index b93416df2f7..ee9bc7a0e4f 100644 --- a/Docs/sp-imp-spec.txt +++ b/Docs/sp-imp-spec.txt @@ -1063,8 +1063,10 @@ language enum('SQL') DEFAULT 'SQL' NOT NULL, sql_data_access enum('CONTAINS_SQL') DEFAULT 'CONTAINS_SQL' NOT NULL, is_deterministic enum('YES','NO') DEFAULT 'NO' NOT NULL, - definition blob DEFAULT '' NOT NULL, - security_type enum('INVOKER','DEFINER') DEFAULT 'INVOKER' NOT NULL, + security_type enum('INVOKER','DEFINER') DEFAULT 'DEFINER' NOT NULL, + param_list blob DEFAULT '' NOT NULL, + returns char(64) DEFAULT '' NOT NULL, + body blob DEFAULT '' NOT NULL, definer char(77) binary DEFAULT '' NOT NULL, created timestamp, modified timestamp, @@ -1093,5 +1095,6 @@ comment char(64) binary DEFAULT '' NOT NULL, PRIMARY KEY (schema,name,type) ) comment='Stored Procedures'; - --- + + -- +
\ No newline at end of file |