Kouhei Sutou
null+****@clear*****
Wed Apr 16 22:55:47 JST 2014
Kouhei Sutou 2014-04-16 22:55:47 +0900 (Wed, 16 Apr 2014) New Revision: 21f9e8c787e5afaf3a9c5496ac4d10d0dde506fa https://github.com/mroonga/mroonga/commit/21f9e8c787e5afaf3a9c5496ac4d10d0dde506fa Message: test: add a test case for ALTER TABLE ALGORITHM=COPY Added files: mysql-test/mroonga/storage/alter_table/r/algorithm_copy.result mysql-test/mroonga/storage/alter_table/t/algorithm_copy.test Added: mysql-test/mroonga/storage/alter_table/r/algorithm_copy.result (+13 -0) 100644 =================================================================== --- /dev/null +++ mysql-test/mroonga/storage/alter_table/r/algorithm_copy.result 2014-04-16 22:55:47 +0900 (3ded3d3) @@ -0,0 +1,13 @@ +DROP TABLE IF EXISTS memos; +CREATE TABLE memos ( +title VARCHAR(32) PRIMARY KEY +) DEFAULT CHARSET="utf8"; +ALTER TABLE memos ALGORITHM=COPY, ADD FULLTEXT INDEX (title) COMMENT "copy"; +SHOW CREATE TABLE memos; +Table Create Table +memos CREATE TABLE `memos` ( + `title` varchar(32) NOT NULL, + PRIMARY KEY (`title`), + FULLTEXT KEY `title` (`title`) COMMENT 'copy' +) ENGINE=mroonga DEFAULT CHARSET=utf8 +DROP TABLE memos; Added: mysql-test/mroonga/storage/alter_table/t/algorithm_copy.test (+34 -0) 100644 =================================================================== --- /dev/null +++ mysql-test/mroonga/storage/alter_table/t/algorithm_copy.test 2014-04-16 22:55:47 +0900 (0ed9cbd) @@ -0,0 +1,34 @@ +# Copyright(C) 2014 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/not_embedded.inc +--source ../../../include/mroonga/have_mroonga.inc + +--disable_warnings +DROP TABLE IF EXISTS memos; +--enable_warnings + +CREATE TABLE memos ( + title VARCHAR(32) PRIMARY KEY +) DEFAULT CHARSET="utf8"; + +ALTER TABLE memos ALGORITHM=COPY, ADD FULLTEXT INDEX (title) COMMENT "copy"; + +SHOW CREATE TABLE memos; + +DROP TABLE memos; + +--source ../../../include/mroonga/have_mroonga_deinit.inc -------------- next part -------------- HTML����������������������������...Descargar
