Kouhei Sutou
null+****@clear*****
Fri Jun 21 14:34:49 JST 2013
Kouhei Sutou 2013-06-21 14:34:49 +0900 (Fri, 21 Jun 2013) New Revision: 3fae2db4db43f1fc4f0d5a8b28c0151337f2c7f3 https://github.com/mroonga/mroonga/commit/3fae2db4db43f1fc4f0d5a8b28c0151337f2c7f3 Message: wrapper: add a test for LOCK TABLES and ENABLE KEYS fixes #1778 Reported by Y.Kentaro. Thanks!!! Added files: test/sql/suite/mroonga/wrapper/alter_table/enable_keys/r/lock_tables.result test/sql/suite/mroonga/wrapper/alter_table/enable_keys/t/lock_tables.test Added: test/sql/suite/mroonga/wrapper/alter_table/enable_keys/r/lock_tables.result (+20 -0) 100644 =================================================================== --- /dev/null +++ test/sql/suite/mroonga/wrapper/alter_table/enable_keys/r/lock_tables.result 2013-06-21 14:34:49 +0900 (341cc4f) @@ -0,0 +1,20 @@ +DROP TABLE IF EXISTS memos; +CREATE TABLE IF NOT EXISTS memos ( +id VARCHAR(45) NOT NULL PRIMARY KEY, +text TEXT NOT NULL, +FULLTEXT KEY (text) +) DEFAULT CHARSET=utf8 COMMENT='engine "InnoDB"'; +LOCK TABLES memos WRITE; +ALTER TABLE memos DISABLE KEYS; +INSERT INTO memos +VALUES (00000, 'text0'), +(00001, 'text1'), +(00002, 'text2'); +ALTER TABLE memos ENABLE KEYS; +UNLOCK TABLES; +SELECT * FROM memos; +id text +0 text0 +1 text1 +2 text2 +DROP TABLE memos; Added: test/sql/suite/mroonga/wrapper/alter_table/enable_keys/t/lock_tables.test (+45 -0) 100644 =================================================================== --- /dev/null +++ test/sql/suite/mroonga/wrapper/alter_table/enable_keys/t/lock_tables.test 2013-06-21 14:34:49 +0900 (59e7769) @@ -0,0 +1,45 @@ +# Copyright(C) 2013 Kouhei Sutou <kou �� clear-code.com> +# +# This library is free software; you can redistribute it and/or +# modify it under the terms of the GNU Lesser General Public +# License as published by the Free Software Foundation; either +# version 2.1 of the License, or (at your option) any later version. +# +# This library is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU +# Lesser General Public License for more details. +# +# You should have received a copy of the GNU Lesser General Public +# License along with this library; if not, write to the Free Software +# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +--source include/have_innodb.inc +--source include/mroonga/have_mroonga.inc + +--disable_warnings +DROP TABLE IF EXISTS memos; +--enable_warnings + +CREATE TABLE IF NOT EXISTS memos ( + id VARCHAR(45) NOT NULL PRIMARY KEY, + text TEXT NOT NULL, + FULLTEXT KEY (text) +) DEFAULT CHARSET=utf8 COMMENT='engine "InnoDB"'; + +LOCK TABLES memos WRITE; +ALTER TABLE memos DISABLE KEYS; + +INSERT INTO memos + VALUES (00000, 'text0'), + (00001, 'text1'), + (00002, 'text2'); + +ALTER TABLE memos ENABLE KEYS; +UNLOCK TABLES; + +SELECT * FROM memos; + +DROP TABLE memos; + +--source include/mroonga/have_mroonga_deinit.inc -------------- next part -------------- HTML����������������������������...Download