From 2b8de050bfc98f0a0774d6a54be05ee774d2fa46 Mon Sep 17 00:00:00 2001
From: Sergei Golubchik <sergii@pisem.net>
Date: Fri, 30 Apr 2010 22:04:35 +0200
Subject: create table options bug: alter table does not reset
 HA_OPTION_TEXT_CREATE_OPTIONS when the last option value is removed

---
 sql/unireg.cc | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'sql')

diff --git a/sql/unireg.cc b/sql/unireg.cc
index 3a153277337..a048adbef72 100644
--- a/sql/unireg.cc
+++ b/sql/unireg.cc
@@ -197,6 +197,8 @@ bool mysql_create_frm(THD *thd, const char *file_name,
     create_info->table_options|= HA_OPTION_TEXT_CREATE_OPTIONS;
     create_info->extra_size+= (options_len + 4);
   }
+  else
+    create_info->table_options&= ~HA_OPTION_TEXT_CREATE_OPTIONS;
 
   if ((file=create_frm(thd, file_name, db, table, reclength, fileinfo,
 		       create_info, keys)) < 0)
-- 
cgit v1.2.1