svnno****@sourc*****
svnno****@sourc*****
2010年 7月 1日 (木) 20:36:57 JST
Revision: 183
http://sourceforge.jp/projects/tritonn/svn/view?view=rev&revision=183
Author: myuka
Date: 2010-07-01 20:36:57 +0900 (Thu, 01 Jul 2010)
Log Message:
-----------
added test suite
* senna_score_sort.test
modified test suite
* senna_util.test (added senna_score_sort variables test)
Modified Paths:
--------------
tags/tritonn-1.0.12-mysql-5.0.83/mysql-test/suite/senna/t/senna_util.test
Added Paths:
-----------
tags/tritonn-1.0.12-mysql-5.0.83/mysql-test/suite/senna/t/senna_score_sort.test
-------------- next part --------------
Added: tags/tritonn-1.0.12-mysql-5.0.83/mysql-test/suite/senna/t/senna_score_sort.test
===================================================================
--- tags/tritonn-1.0.12-mysql-5.0.83/mysql-test/suite/senna/t/senna_score_sort.test (rev 0)
+++ tags/tritonn-1.0.12-mysql-5.0.83/mysql-test/suite/senna/t/senna_score_sort.test 2010-07-01 11:36:57 UTC (rev 183)
@@ -0,0 +1,27 @@
+SET NAMES utf8;
+
+--disable-warnings
+DROP TABLE IF EXISTS t1;
+--enable-warnings
+
+create table t1(c1 varchar(255))engine=myisam default charset utf8;
+create fulltext index ft using ngram on t1(c1);
+
+insert into t1 values("今日は東京に行きます。");
+insert into t1 values("今日は東京に行きます。明日も東京に行きます。明後日も東京に行きます。");
+insert into t1 values("今日は東京に行きます。明日も東京に行きます。");
+insert into t1 values("昨日は神奈川に行きました。");
+insert into t1 values("東京、東京、東京");
+
+select match(c1) against("東京") as score, c1 from t1 where match(c1) against("東京" in boolean mode) ;
+select match(c1) against("東京") as score, c1 from t1 where match(c1) against("東京") ;
+
+set session senna_score_sort=OFF;
+select match(c1) against("東京") as score, c1 from t1 where match(c1) against("東京" in boolean mode) ;
+select match(c1) against("東京") as score, c1 from t1 where match(c1) against("東京") ;
+
+set session senna_score_sort=ON;
+select match(c1) against("東京") as score, c1 from t1 where match(c1) against("東京" in boolean mode) ;
+select match(c1) against("東京") as score, c1 from t1 where match(c1) against("東京") ;
+
+drop table t1;
Modified: tags/tritonn-1.0.12-mysql-5.0.83/mysql-test/suite/senna/t/senna_util.test
===================================================================
--- tags/tritonn-1.0.12-mysql-5.0.83/mysql-test/suite/senna/t/senna_util.test 2010-06-30 07:28:35 UTC (rev 182)
+++ tags/tritonn-1.0.12-mysql-5.0.83/mysql-test/suite/senna/t/senna_util.test 2010-07-01 11:36:57 UTC (rev 183)
@@ -86,3 +86,35 @@
--error 1229
SET SESSION senna_index_type=ngram;
+
+
+# test for senna_score_sort
+
+SHOW GLOBAL VARIABLES LIKE 'senna_score_sort';
+SHOW SESSION VARIABLES LIKE 'senna_score_sort';
+
+SET senna_score_sort=OFF;
+
+SHOW GLOBAL VARIABLES LIKE 'senna_score_sort';
+SHOW SESSION VARIABLES LIKE 'senna_score_sort';
+
+SET senna_score_sort=ON;
+
+SHOW GLOBAL VARIABLES LIKE 'senna_score_sort';
+SHOW SESSION VARIABLES LIKE 'senna_score_sort';
+
+SET GLOBAL senna_score_sort=OFF;
+
+SHOW GLOBAL VARIABLES LIKE 'senna_score_sort';
+SHOW SESSION VARIABLES LIKE 'senna_score_sort';
+
+SET GLOBAL senna_score_sort=ON;
+
+SHOW GLOBAL VARIABLES LIKE 'senna_score_sort';
+SHOW SESSION VARIABLES LIKE 'senna_score_sort';
+
+--error 1231
+SET senna_score_sort=DUMMY;
+
+--error 1231
+SET GLOBAL senna_score_sort=DUMMY;