svnno****@sourc*****
svnno****@sourc*****
2008年 1月 28日 (月) 16:13:24 JST
Revision: 92
http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=tritonn&view=rev&rev=92
Author: mir
Date: 2008-01-28 16:13:24 +0900 (Mon, 28 Jan 2008)
Log Message:
-----------
added testcases for many bugfixes.
Modified Paths:
--------------
tags/tritonn-1.0.9-mysql-5.0.51/mysql-test/suite/senna/r/senna_create.result
tags/tritonn-1.0.9-mysql-5.0.51/mysql-test/suite/senna/r/senna_kwic.result
tags/tritonn-1.0.9-mysql-5.0.51/mysql-test/suite/senna/t/senna_create.test
tags/tritonn-1.0.9-mysql-5.0.51/mysql-test/suite/senna/t/senna_kwic.test
Added Paths:
-----------
tags/tritonn-1.0.9-mysql-5.0.51/mysql-test/suite/senna/r/senna_general.result
tags/tritonn-1.0.9-mysql-5.0.51/mysql-test/suite/senna/t/senna_general.test
Modified: tags/tritonn-1.0.9-mysql-5.0.51/mysql-test/suite/senna/r/senna_create.result
===================================================================
--- tags/tritonn-1.0.9-mysql-5.0.51/mysql-test/suite/senna/r/senna_create.result 2008-01-28 05:17:05 UTC (rev 91)
+++ tags/tritonn-1.0.9-mysql-5.0.51/mysql-test/suite/senna/r/senna_create.result 2008-01-28 07:13:24 UTC (rev 92)
@@ -52,9 +52,7 @@
c2 CHAR(100),
FULLTEXT INDEX USING NGRAM (c2)
) ENGINE = InnoDB DEFAULT CHARSET utf8;
-Warnings:
-Warning 1266 Using storage engine MyISAM for table 't1'
-DROP TABLE t1;
+ERROR HY000: The used table type doesn't support FULLTEXT indexes
CREATE TABLE t1 (c1 INT PRIMARY KEY AUTO_INCREMENT,
c2 VARCHAR(128),
c3 TEXT,
Added: tags/tritonn-1.0.9-mysql-5.0.51/mysql-test/suite/senna/r/senna_general.result
===================================================================
--- tags/tritonn-1.0.9-mysql-5.0.51/mysql-test/suite/senna/r/senna_general.result 2008-01-28 05:17:05 UTC (rev 91)
+++ tags/tritonn-1.0.9-mysql-5.0.51/mysql-test/suite/senna/r/senna_general.result 2008-01-28 07:13:24 UTC (rev 92)
@@ -0,0 +1,7 @@
+set names utf8;
+DROP TABLE IF EXISTS t1;
+create table t1 (c1 char(100) unique) engine = innodb;
+insert into t1 values ("test");
+delete from t1 where c1 = "test";
+insert into t1 values ("test");
+drop table t1;
Modified: tags/tritonn-1.0.9-mysql-5.0.51/mysql-test/suite/senna/r/senna_kwic.result
===================================================================
--- tags/tritonn-1.0.9-mysql-5.0.51/mysql-test/suite/senna/r/senna_kwic.result 2008-01-28 05:17:05 UTC (rev 91)
+++ tags/tritonn-1.0.9-mysql-5.0.51/mysql-test/suite/senna/r/senna_kwic.result 2008-01-28 07:13:24 UTC (rev 92)
@@ -153,3 +153,26 @@
KWIC(c1, 30, 1, 0, "","", "東京", "<span class='word'>", "</span>")
DROP TABLE t1;
+create table t1 (c1 longtext, time INT) default charset utf8 engine=myisam;
+insert into t1 (c1, time) VALUES('B A B', 1191299318);
+insert into t1 (c1, time) VALUES('B A B', 1191299722);
+select kwic(c1, 120, 3, 0, "", "", "B", "[", "]") from t1;
+kwic(c1, 120, 3, 0, "", "", "B", "[", "]")
+[B] A[ B]
+[B] A[ B]
+drop table t1;
+create table t1 (c1 longtext) default charset utf8 engine=myisam;
+insert into t1 (c1) VALUES('ｱｲｺﾝﾒﾆｭｰ と ﾎﾟｰﾄﾚｯﾄ から検索');
+select * from t1;
+c1
+ｱｲｺﾝﾒﾆｭｰ と ﾎﾟｰﾄﾚｯﾄ から検索
+select kwic(c1, 120, 3, 0, "", "", "ｱｲｺﾝﾒﾆｭｰ", "[", "]") from t1;
+kwic(c1, 120, 3, 0, "", "", "ｱｲｺﾝﾒﾆｭｰ", "[", "]")
+[ｱｲｺﾝﾒﾆｭｰ] と ﾎﾟｰﾄﾚｯﾄ から検索
+select kwic(c1, 120, 3, 0, "", "", "から", "[", "]") from t1;
+kwic(c1, 120, 3, 0, "", "", "から", "[", "]")
+ｱｲｺﾝﾒﾆｭｰ と ﾎﾟｰﾄﾚｯﾄ[ から]検索
+select kwic(c1, 120, 3, 0, "", "", "検索", "[", "]") from t1;
+kwic(c1, 120, 3, 0, "", "", "検索", "[", "]")
+ｱｲｺﾝﾒﾆｭｰ と ﾎﾟｰﾄﾚｯﾄ から[検索]
+drop table t1;
Modified: tags/tritonn-1.0.9-mysql-5.0.51/mysql-test/suite/senna/t/senna_create.test
===================================================================
--- tags/tritonn-1.0.9-mysql-5.0.51/mysql-test/suite/senna/t/senna_create.test 2008-01-28 05:17:05 UTC (rev 91)
+++ tags/tritonn-1.0.9-mysql-5.0.51/mysql-test/suite/senna/t/senna_create.test 2008-01-28 07:13:24 UTC (rev 92)
@@ -1,3 +1,5 @@
+-- source include/have_innodb.inc
+
SET NAMES utf8;
--disable_warnings
@@ -60,11 +62,11 @@
FULLTEXT INDEX USING NGRAM (c2)
) ENGINE = MEMORY DEFAULT CHARSET utf8;
+--error 1214
CREATE TABLE t1 (c1 INT PRIMARY KEY AUTO_INCREMENT,
c2 CHAR(100),
FULLTEXT INDEX USING NGRAM (c2)
) ENGINE = InnoDB DEFAULT CHARSET utf8;
-DROP TABLE t1;
# multi column fulltext index
CREATE TABLE t1 (c1 INT PRIMARY KEY AUTO_INCREMENT,
Added: tags/tritonn-1.0.9-mysql-5.0.51/mysql-test/suite/senna/t/senna_general.test
===================================================================
--- tags/tritonn-1.0.9-mysql-5.0.51/mysql-test/suite/senna/t/senna_general.test 2008-01-28 05:17:05 UTC (rev 91)
+++ tags/tritonn-1.0.9-mysql-5.0.51/mysql-test/suite/senna/t/senna_general.test 2008-01-28 07:13:24 UTC (rev 92)
@@ -0,0 +1,14 @@
+-- source include/have_innodb.inc
+
+set names utf8;
+
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+--enable_warnings
+
+# regression test if innodb won't get error by following sql.
+create table t1 (c1 char(100) unique) engine = innodb;
+insert into t1 values ("test");
+delete from t1 where c1 = "test";
+insert into t1 values ("test");
+drop table t1;
Modified: tags/tritonn-1.0.9-mysql-5.0.51/mysql-test/suite/senna/t/senna_kwic.test
===================================================================
--- tags/tritonn-1.0.9-mysql-5.0.51/mysql-test/suite/senna/t/senna_kwic.test 2008-01-28 05:17:05 UTC (rev 91)
+++ tags/tritonn-1.0.9-mysql-5.0.51/mysql-test/suite/senna/t/senna_kwic.test 2008-01-28 07:13:24 UTC (rev 92)
@@ -105,3 +105,18 @@
SELECT KWIC(c1, 30, 1, 0, "","", "東京", "<span class='word'>", "</span>") FROM t1;
DROP TABLE t1;
+# bugfix senna buffer overflow.
+create table t1 (c1 longtext, time INT) default charset utf8 engine=myisam;
+insert into t1 (c1, time) VALUES('B A B', 1191299318);
+insert into t1 (c1, time) VALUES('B A B', 1191299722);
+select kwic(c1, 120, 3, 0, "", "", "B", "[", "]") from t1;
+drop table t1;
+
+# bugfix senna buffer overflow
+create table t1 (c1 longtext) default charset utf8 engine=myisam;
+insert into t1 (c1) VALUES('ｱｲｺﾝﾒﾆｭｰ と ﾎﾟｰﾄﾚｯﾄ から検索');
+select * from t1;
+select kwic(c1, 120, 3, 0, "", "", "ｱｲｺﾝﾒﾆｭｰ", "[", "]") from t1;
+select kwic(c1, 120, 3, 0, "", "", "から", "[", "]") from t1;
+select kwic(c1, 120, 3, 0, "", "", "検索", "[", "]") from t1;
+drop table t1;