Kenji Maruyama
null+****@clear*****
Thu Feb 20 15:27:59 JST 2014
Kenji Maruyama 2014-02-20 15:27:59 +0900 (Thu, 20 Feb 2014) New Revision: c3d1a2f60d99aa70173300bd2ed6dff0176e8fdf https://github.com/mroonga/mroonga/commit/c3d1a2f60d99aa70173300bd2ed6dff0176e8fdf Message: test: alter table with fulltext index which refer to table causes mysqld crash add test result [groonga-dev,02130] Reported by Naoya Murakami. Thanks!!! Added files: mysql-test/mroonga/storage/alter_table/fulltext/r/add_reference_table.result Added: mysql-test/mroonga/storage/alter_table/fulltext/r/add_reference_table.result (+50 -0) 100644 =================================================================== --- /dev/null +++ mysql-test/mroonga/storage/alter_table/fulltext/r/add_reference_table.result 2014-02-20 15:27:59 +0900 (abc55d8) @@ -0,0 +1,50 @@ +DROP TABLE IF EXISTS tags; +DROP TABLE IF EXISTS bugs; +CREATE TABLE tags ( +name VARCHAR(64) PRIMARY KEY +) DEFAULT CHARSET=utf8 COMMENT='default_tokenizer "TokenDelimit"'; +CREATE TABLE bugs ( +id INT UNSIGNED PRIMARY KEY, +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 +ALTER TABLE bugs ADD FULLTEXT INDEX bugs_tags_index (tags) COMMENT 'table "tags"'; +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; -------------- next part -------------- HTML����������������������������...Download