From 3aa2a62f37cb4e34b86a8d1f495c90727a461621 Mon Sep 17 00:00:00 2001
From: "pem@mysql.comhem.se" <>
Date: Wed, 8 Sep 2004 11:42:18 +0200
Subject: 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.

---
 sql/sp.cc | 1 +
 1 file changed, 1 insertion(+)

(limited to 'sql/sp.cc')

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)
-- 
cgit v1.2.1