diff options
| author | unknown <pem@mysql.comhem.se> | 2004-09-08 11:42:18 +0200 |
|---|---|---|
| committer | unknown <pem@mysql.comhem.se> | 2004-09-08 11:42:18 +0200 |
| commit | 1bf3ce01c48f980c183a8b88afdc0440a26da36d (patch) | |
| tree | 2ba1000cc2420c2c39a41464112827c6b0e365df /sql/sp.cc | |
| parent | 9243aa9ebe800724497316a8eb1bbab1d1065db6 (diff) | |
| download | mariadb-git-1bf3ce01c48f980c183a8b88afdc0440a26da36d.tar.gz | |
Fixed BUG#5258: Stored procedure modified date is 0000-00-00.
Althought techically not a but (as it's functioning as designed),
it was decided that the design should be changed. Some users have
a problem with dates being '0000-00-00' and the SQL standard specifies
that the modification date should be the same as the creation date
at creation.
mysql-test/r/sp.result:
New test case for BUG#5258.
mysql-test/t/sp.test:
New test case for BUG#5258.
sql/sp.cc:
Set the modification time at creation too.
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 cd52cff90a3..41d07bb9d40 100644 --- a/sql/sp.cc +++ b/sql/sp.cc @@ -371,6 +371,7 @@ db_create_routine(THD *thd, int type, sp_head *sp) table->field[MYSQL_PROC_FIELD_DEFINER]-> store(definer, (uint)strlen(definer), system_charset_info); ((Field_timestamp *)table->field[MYSQL_PROC_FIELD_CREATED])->set_time(); + ((Field_timestamp *)table->field[MYSQL_PROC_FIELD_MODIFIED])->set_time(); table->field[MYSQL_PROC_FIELD_SQL_MODE]-> store((longlong)thd->variables.sql_mode); if (sp->m_chistics->comment.str) |