From 5fdd9c99c246c27f92f85e9919dea2ed537d460d Mon Sep 17 00:00:00 2001
From: Sergey Glukhov <Sergey.Glukhov@sun.com>
Date: Wed, 10 Dec 2008 18:38:27 +0400
Subject: Bug#35275 INFORMATION_SCHEMA.TABLES.CREATE_OPTIONS omits
 KEY_BLOCK_SIZE Added KEY_BLOCK_SIZE option to I_S.TABLES.CREATE_OPTIONS field

---
 mysql-test/t/information_schema.test | 7 +++++++
 1 file changed, 7 insertions(+)

(limited to 'mysql-test/t/information_schema.test')

diff --git a/mysql-test/t/information_schema.test b/mysql-test/t/information_schema.test
index bcb22c44076..3dbdf76c220 100644
--- a/mysql-test/t/information_schema.test
+++ b/mysql-test/t/information_schema.test
@@ -1383,4 +1383,11 @@ select a.VARIABLE_VALUE - b.VARIABLE_VALUE from t0 b, information_schema.global_
    where a.VARIABLE_NAME = b.VARIABLE_NAME; 
 drop table t0;
 
+#
+# Bug#35275 INFORMATION_SCHEMA.TABLES.CREATE_OPTIONS omits KEY_BLOCK_SIZE
+#
+CREATE TABLE t1(a INT) KEY_BLOCK_SIZE=1;
+SELECT CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='t1';
+DROP TABLE t1;
+
 --echo End of 5.1 tests.
-- 
cgit v1.2.1