svnno****@sourc*****
svnno****@sourc*****
2008年 6月 9日 (月) 17:10:08 JST
Revision: 136
http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=tritonn&view=rev&rev=136
Author: mir
Date: 2008-06-09 17:10:08 +0900 (Mon, 09 Jun 2008)
Log Message:
-----------
added testcase file for 2ind and testcase for bugfix of group functions.
Added Paths:
-----------
tags/tritonn-1.0.10-mysql-5.0.51a/mysql-test/suite/senna/r/senna_2ind.result
tags/tritonn-1.0.10-mysql-5.0.51a/mysql-test/suite/senna/t/senna_2ind.test
-------------- next part --------------
Added: tags/tritonn-1.0.10-mysql-5.0.51a/mysql-test/suite/senna/r/senna_2ind.result
===================================================================
--- tags/tritonn-1.0.10-mysql-5.0.51a/mysql-test/suite/senna/r/senna_2ind.result (rev 0)
+++ tags/tritonn-1.0.10-mysql-5.0.51a/mysql-test/suite/senna/r/senna_2ind.result 2008-06-09 08:10:08 UTC (rev 136)
@@ -0,0 +1,20 @@
+SET NAMES utf8;
+DROP TABLE IF EXISTS t1;
+drop table if exists t1;
+Warnings:
+Note 1051 Unknown table 't1'
+create table t1(c1 int, c2 varchar(255), index(c1)) default charset utf8;
+insert into t1 values (1,"aaa");
+insert into t1 values (2,"aaa");
+insert into t1 values (3,"bbb");
+insert into t1 values (4,"bbb");
+create fulltext index ft using
+ngram,split_alpha,split_digit,split_symbol on t1(c2);
+set senna_2ind=OFF;
+select sum(c1) from t1 where match(c2) against("a");
+sum(c1)
+3
+set senna_2ind=ON;
+select sum(c1) from t1 where match(c2) against("a");
+sum(c1)
+3
Added: tags/tritonn-1.0.10-mysql-5.0.51a/mysql-test/suite/senna/t/senna_2ind.test
===================================================================
--- tags/tritonn-1.0.10-mysql-5.0.51a/mysql-test/suite/senna/t/senna_2ind.test (rev 0)
+++ tags/tritonn-1.0.10-mysql-5.0.51a/mysql-test/suite/senna/t/senna_2ind.test 2008-06-09 08:10:08 UTC (rev 136)
@@ -0,0 +1,21 @@
+SET NAMES utf8;
+
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+--enable_warnings
+
+# bugfix for 2ind, group functions. sum, count ...
+drop table if exists t1;
+create table t1(c1 int, c2 varchar(255), index(c1)) default charset utf8;
+insert into t1 values (1,"aaa");
+insert into t1 values (2,"aaa");
+insert into t1 values (3,"bbb");
+insert into t1 values (4,"bbb");
+
+create fulltext index ft using
+ngram,split_alpha,split_digit,split_symbol on t1(c2);
+
+set senna_2ind=OFF;
+select sum(c1) from t1 where match(c2) against("a");
+set senna_2ind=ON;
+select sum(c1) from t1 where match(c2) against("a");