Kouhei Sutou
null+****@clear*****
Wed Aug 24 15:45:00 JST 2016
Kouhei Sutou 2016-08-24 15:45:00 +0900 (Wed, 24 Aug 2016) New Revision: f82296a840ce90d3bafdd884d2e5dfcf26dd71b7 https://github.com/mroonga/mroonga/commit/f82296a840ce90d3bafdd884d2e5dfcf26dd71b7 Message: test: use varchar for SHOW CREATE TABLE portability Modified files: mysql-test/mroonga/storage/alter_table/add_column/r/after.result mysql-test/mroonga/storage/alter_table/add_column/t/after.test Modified: mysql-test/mroonga/storage/alter_table/add_column/r/after.result (+5 -5) =================================================================== --- mysql-test/mroonga/storage/alter_table/add_column/r/after.result 2016-08-24 15:39:52 +0900 (52a7215) +++ mysql-test/mroonga/storage/alter_table/add_column/r/after.result 2016-08-24 15:45:00 +0900 (15cd349) @@ -1,22 +1,22 @@ DROP TABLE IF EXISTS diaries; CREATE TABLE diaries ( id INT PRIMARY KEY AUTO_INCREMENT, -body TEXT +body VARCHAR(140) ) DEFAULT CHARSET UTF8; SHOW CREATE TABLE diaries; Table Create Table diaries CREATE TABLE `diaries` ( `id` int(11) NOT NULL AUTO_INCREMENT, - `body` text, + `body` varchar(140) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=Mroonga DEFAULT CHARSET=utf8 -ALTER TABLE diaries ADD title TEXT AFTER id; +ALTER TABLE diaries ADD title VARCHAR(40) AFTER id; SHOW CREATE TABLE diaries; Table Create Table diaries CREATE TABLE `diaries` ( `id` int(11) NOT NULL AUTO_INCREMENT, - `title` text, - `body` text, + `title` varchar(40) DEFAULT NULL, + `body` varchar(140) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=Mroonga DEFAULT CHARSET=utf8 INSERT INTO diaries (title, body) values ("groonga (1)", "starting groonga."); Modified: mysql-test/mroonga/storage/alter_table/add_column/t/after.test (+2 -2) =================================================================== --- mysql-test/mroonga/storage/alter_table/add_column/t/after.test 2016-08-24 15:39:52 +0900 (860cb1a) +++ mysql-test/mroonga/storage/alter_table/add_column/t/after.test 2016-08-24 15:45:00 +0900 (12a9592) @@ -23,11 +23,11 @@ DROP TABLE IF EXISTS diaries; CREATE TABLE diaries ( id INT PRIMARY KEY AUTO_INCREMENT, - body TEXT + body VARCHAR(140) ) DEFAULT CHARSET UTF8; SHOW CREATE TABLE diaries; -ALTER TABLE diaries ADD title TEXT AFTER id; +ALTER TABLE diaries ADD title VARCHAR(40) AFTER id; SHOW CREATE TABLE diaries; INSERT INTO diaries (title, body) values ("groonga (1)", "starting groonga."); -------------- next part -------------- HTML����������������������������...下載
