diff options
| author | pem@mysql.comhem.se <> | 2004-09-08 11:42:18 +0200 |
|---|---|---|
| committer | pem@mysql.comhem.se <> | 2004-09-08 11:42:18 +0200 |
| commit | 3aa2a62f37cb4e34b86a8d1f495c90727a461621 (patch) | |
| tree | 2ba1000cc2420c2c39a41464112827c6b0e365df /sql/sp.cc | |
| parent | 2e38c0bf38bf735bb113f6194b841895350caac9 (diff) | |
| download | mariadb-git-3aa2a62f37cb4e34b86a8d1f495c90727a461621.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.
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) |