[Tritonn-commit 82] [svn] [92] added testcases for many bugfixes.

Zurück zum Archiv-Index

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;




Tritonn-commit メーリングリストの案内
Zurück zum Archiv-Index