Kenji Maruyama
null+****@clear*****
Sat Feb 22 02:29:22 JST 2014
Kenji Maruyama 2014-02-22 02:29:22 +0900 (Sat, 22 Feb 2014) New Revision: 5cba35137ddf43928d857aa3e11d5fc5048f6894 https://github.com/mroonga/mroonga/commit/5cba35137ddf43928d857aa3e11d5fc5048f6894 Message: test: remove SHOW CREATE TABLE and the results of the query Modified files: mysql-test/mroonga/storage/alter_table/fulltext/r/add_reference_table.result mysql-test/mroonga/storage/alter_table/fulltext/t/add_reference_table.test Modified: mysql-test/mroonga/storage/alter_table/fulltext/r/add_reference_table.result (+0 -29) =================================================================== --- mysql-test/mroonga/storage/alter_table/fulltext/r/add_reference_table.result 2014-02-22 02:16:28 +0900 (dc20cc9) +++ mysql-test/mroonga/storage/alter_table/fulltext/r/add_reference_table.result 2014-02-22 02:29:22 +0900 (705d2f7) @@ -9,20 +9,6 @@ tags VARCHAR(40) COMMENT 'type "tags"' ) DEFAULT CHARSET=utf8; INSERT INTO tags (name) VALUES ("Groonga"); INSERT INTO bugs (id, tags) VALUES (1, "Groonga Mroonga"); -SHOW CREATE TABLE tags; -Table Create Table -tags CREATE TABLE `tags` ( - `name` varchar(64) NOT NULL, - PRIMARY KEY (`name`) -) ENGINE=mroonga DEFAULT CHARSET=utf8 COMMENT='default_tokenizer "TokenDelimit"' -SHOW CREATE TABLE bugs; -Table Create Table -bugs CREATE TABLE `bugs` ( - `id` int(10) unsigned NOT NULL, - `tags` varchar(40) DEFAULT NULL COMMENT 'type "tags"', - PRIMARY KEY (`id`), - CONSTRAINT `tags` FOREIGN KEY (`tags`) REFERENCES `test`.`tags` (`name`) ON DELETE RESTRICT ON UPDATE RESTRICT -) ENGINE=mroonga DEFAULT CHARSET=utf8 SELECT * FROM bugs; id tags 1 GROONGA MROONGA @@ -31,20 +17,5 @@ SELECT * FROM bugs WHERE MATCH(tags) AGAINST("Groonga"); id tags 1 GROONGA MROONGA -SHOW CREATE TABLE tags; -Table Create Table -tags CREATE TABLE `tags` ( - `name` varchar(64) NOT NULL, - PRIMARY KEY (`name`) -) ENGINE=mroonga DEFAULT CHARSET=utf8 COMMENT='default_tokenizer "TokenDelimit"' -SHOW CREATE TABLE bugs; -Table Create Table -bugs CREATE TABLE `bugs` ( - `id` int(10) unsigned NOT NULL, - `tags` varchar(40) DEFAULT NULL COMMENT 'type "tags"', - PRIMARY KEY (`id`), - FULLTEXT KEY `bugs_tags_index` (`tags`) COMMENT 'table "tags"', - CONSTRAINT `tags` FOREIGN KEY (`tags`) REFERENCES `test`.`tags` (`name`) ON DELETE RESTRICT ON UPDATE RESTRICT -) ENGINE=mroonga DEFAULT CHARSET=utf8 DROP TABLE bugs; DROP TABLE tags; Modified: mysql-test/mroonga/storage/alter_table/fulltext/t/add_reference_table.test (+0 -6) =================================================================== --- mysql-test/mroonga/storage/alter_table/fulltext/t/add_reference_table.test 2014-02-22 02:16:28 +0900 (bd7d0f9) +++ mysql-test/mroonga/storage/alter_table/fulltext/t/add_reference_table.test 2014-02-22 02:29:22 +0900 (6c29130) @@ -34,9 +34,6 @@ CREATE TABLE bugs ( INSERT INTO tags (name) VALUES ("Groonga"); INSERT INTO bugs (id, tags) VALUES (1, "Groonga Mroonga"); -SHOW CREATE TABLE tags; -SHOW CREATE TABLE bugs; - SELECT * FROM bugs; ALTER TABLE bugs ADD FULLTEXT INDEX bugs_tags_index (tags) COMMENT 'table "tags"'; @@ -44,9 +41,6 @@ ALTER TABLE bugs ADD FULLTEXT INDEX bugs_tags_index (tags) COMMENT 'table "tags" SELECT * FROM bugs WHERE MATCH(tags) AGAINST("Groonga"); -SHOW CREATE TABLE tags; -SHOW CREATE TABLE bugs; - DROP TABLE bugs; DROP TABLE tags; -------------- next part -------------- HTML����������������������������...下載
