Kouhei Sutou
null+****@clear*****
Thu Oct 4 10:47:29 JST 2012
Kouhei Sutou 2012-01-06 15:59:50 +0900 (Fri, 06 Jan 2012) New Revision: 4827b03b883086f99e5d3d66b21b8736c899c0e9 https://github.com/mroonga/mroonga/commit/4827b03b883086f99e5d3d66b21b8736c899c0e9 Log: [test] follow test changes. Modified files: test/sql/suite/mroonga_storage/r/fulltext_order_limit.result test/sql/suite/mroonga_storage/r/order_limit_performance.result Modified: test/sql/suite/mroonga_storage/r/fulltext_order_limit.result (+4 -4) =================================================================== --- test/sql/suite/mroonga_storage/r/fulltext_order_limit.result 2012-01-01 14:25:56 +0900 (e4e4bf4) +++ test/sql/suite/mroonga_storage/r/fulltext_order_limit.result 2012-01-06 15:59:50 +0900 (7755e03) @@ -9,7 +9,7 @@ title VARCHAR(255), content TEXT, FULLTEXT INDEX(content), KEY(day) -) DEFAULT CHARSET UTF8; +) DEFAULT CHARSET UTF8 COLLATE UTF8_BIN; SHOW CREATE TABLE diaries; Table Create Table diaries CREATE TABLE `diaries` ( @@ -17,12 +17,12 @@ diaries CREATE TABLE `diaries` ( `year` int(10) unsigned DEFAULT NULL, `month` int(10) unsigned DEFAULT NULL, `day` int(10) unsigned DEFAULT NULL, - `title` varchar(255) DEFAULT NULL, - `content` text, + `title` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `content` text COLLATE utf8_bin, PRIMARY KEY (`id`), KEY `day` (`day`), FULLTEXT KEY `content` (`content`) -) ENGINE=mroonga DEFAULT CHARSET=utf8 +) ENGINE=mroonga DEFAULT CHARSET=utf8 COLLATE=utf8_bin INSERT INTO diaries VALUES(1, 2011, 11, 9, "Hello", "今日からはじめました。"); INSERT INTO diaries VALUES(2, 2011, 11, 10, "天気", "明日の富士山の天気について"); INSERT INTO diaries VALUES(3, 2011, 11, 11, "富士山", "今日も天気がよくてきれいに見える。"); Modified: test/sql/suite/mroonga_storage/r/order_limit_performance.result (+1 -1) =================================================================== --- test/sql/suite/mroonga_storage/r/order_limit_performance.result 2012-01-01 14:25:56 +0900 (bd1e43a) +++ test/sql/suite/mroonga_storage/r/order_limit_performance.result 2012-01-06 15:59:50 +0900 (842599f) @@ -1,6 +1,6 @@ drop table if exists t1; flush status; -create table t1 (c1 int primary key, c2 int, c3 text, _id int, key idx1(c2), fulltext index ft(c3)); +create table t1 (c1 int primary key, c2 int, c3 text, _id int, key idx1(c2), fulltext index ft(c3)) default charset utf8 collate utf8_bin; insert into t1 values(1,10,"aa ii uu ee oo",null); insert into t1 values(2,20,"ka ki ku ke ko",null); insert into t1 values(3,30,"ii si ii se ii",null); -------------- next part -------------- HTML����������������������������...ダウンロード
