diff options
| author | unknown <pem@mysql.comhem.se> | 2004-08-27 16:41:34 +0200 |
|---|---|---|
| committer | unknown <pem@mysql.comhem.se> | 2004-08-27 16:41:34 +0200 |
| commit | d41092796332f1a9de32c56eeff16dc8e49b69b1 (patch) | |
| tree | 287d35fcdfa138772888049b89c1ca74345c6187 /sql/sp.cc | |
| parent | fffa919ffc5cdf0d53353bdcb2ab8043440b642b (diff) | |
| download | mariadb-git-d41092796332f1a9de32c56eeff16dc8e49b69b1.tar.gz | |
Fixed BUG#5251: mysql changes creation time of a procedure/function when altering.
mysql-test/r/sp.result:
New test case for BUG#5251.
mysql-test/t/sp.test:
New test case for BUG#5251.
sql/sp.cc:
Don't update the created timestamp when doing alter procedure/function.
Diffstat (limited to 'sql/sp.cc')
| -rw-r--r-- | sql/sp.cc | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/sp.cc b/sql/sp.cc index b881eeb78d9..dda6e0fad60 100644 --- a/sql/sp.cc +++ b/sql/sp.cc @@ -425,6 +425,7 @@ db_update_routine(THD *thd, int type, sp_name *name, if (ret == SP_OK) { store_record(table,record[1]); + table->timestamp_on_update_now = 0; // Don't update create time now. ((Field_timestamp *)table->field[MYSQL_PROC_FIELD_MODIFIED])->set_time(); if (chistics->suid != IS_DEFAULT_SUID) table->field[MYSQL_PROC_FIELD_SECURITY_TYPE]->store((longlong)chistics->suid); |