svnno****@sourc*****
svnno****@sourc*****
2007年 9月 28日 (金) 22:27:45 JST
Revision: 23 http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=tritonn&view=rev&rev=23 Author: mir Date: 2007-09-28 22:27:45 +0900 (Fri, 28 Sep 2007) Log Message: ----------- added test for bugfix for kwic sql function Modified Paths: -------------- mysql-5.0.45-tritonn-1.0.6/mysql-test/suite/senna/r/senna_kwic.result mysql-5.0.45-tritonn-1.0.6/mysql-test/suite/senna/t/senna_kwic.test Modified: mysql-5.0.45-tritonn-1.0.6/mysql-test/suite/senna/r/senna_kwic.result =================================================================== --- mysql-5.0.45-tritonn-1.0.6/mysql-test/suite/senna/r/senna_kwic.result 2007-09-27 07:50:08 UTC (rev 22) +++ mysql-5.0.45-tritonn-1.0.6/mysql-test/suite/senna/r/senna_kwic.result 2007-09-28 13:27:45 UTC (rev 23) @@ -110,3 +110,40 @@ SELECT KWIC("今日は東京 >>> 明日は埼玉に行きます。", 30, 1, -30, "","", "東京", "<span class='word'>", "</span>", ""); KWIC("今日は東京 >>> 明日は埼玉に行きます。", 30, 1, -30, "","", "東京", "<span class='word'>", "</span>", "") +drop table if exists t1; +create table t1 (c1 text) default charset utf8 engine = myisam; +insert into t1 values("今日は埼玉あああああああああああああああああああああああああああああああああああああ。 +明日も埼玉ああああああああああいいいいいいいいいいいいあああああああああああああああああああああ。 +明後日も埼玉あああああああああああああああああああああああああああああああああああ。 +いつでも埼玉あああああああああああああああああああああああああああああああああ。"); +select kwic(c1, 20, 1, 0, "", " ...", "埼玉", "<span id=word>", "</span>") from t1; +kwic(c1, 20, 1, 0, "", " ...", "埼玉", "<span id=word>", "</span>") +日は<span id=word>埼玉</span>ああ ... +select kwic(c1, 20, 2, 0, "", " ...", "埼玉", "<span id=word>", "</span>") from t1; +kwic(c1, 20, 2, 0, "", " ...", "埼玉", "<span id=word>", "</span>") +日は<span id=word>埼玉</span>ああ ...日も<span id=word>埼玉</span>ああ ... +select kwic(c1, 20, 3, 0, "", " ...", "埼玉", "<span id=word>", "</span>") from t1; +kwic(c1, 20, 3, 0, "", " ...", "埼玉", "<span id=word>", "</span>") +日は<span id=word>埼玉</span>ああ ...日も<span id=word>埼玉</span>ああ ...日も<span id=word>埼玉</span>ああ ... +select kwic(c1, 20, 4, 0, "", " ...", "埼玉", "<span id=word>", "</span>") from t1; +kwic(c1, 20, 4, 0, "", " ...", "埼玉", "<span id=word>", "</span>") +日は<span id=word>埼玉</span>ああ ...日も<span id=word>埼玉</span>ああ ...日も<span id=word>埼玉</span>ああ ...でも<span id=word>埼玉</span>ああ ... +select kwic(c1, 20, 5, 0, "", " ...", "埼玉", "<span id=word>", "</span>") from t1; +kwic(c1, 20, 5, 0, "", " ...", "埼玉", "<span id=word>", "</span>") +日は<span id=word>埼玉</span>ああ ...日も<span id=word>埼玉</span>ああ ...日も<span id=word>埼玉</span>ああ ...でも<span id=word>埼玉</span>ああ ... +select kwic(c1, 20, 1, 0, "(", ")", "埼玉", "[", "]") from t1; +kwic(c1, 20, 1, 0, "(", ")", "埼玉", "[", "]") +(日は[埼玉]ああ) +select kwic(c1, 20, 2, 0, "(", ")", "埼玉", "[", "]") from t1; +kwic(c1, 20, 2, 0, "(", ")", "埼玉", "[", "]") +(日は[埼玉]ああ)(日も[埼玉]ああ) +select kwic(c1, 20, 3, 0, "(", ")", "埼玉", "[", "]") from t1; +kwic(c1, 20, 3, 0, "(", ")", "埼玉", "[", "]") +(日は[埼玉]ああ)(日も[埼玉]ああ)(日も[埼玉]ああ) +select kwic(c1, 20, 4, 0, "(", ")", "埼玉", "[", "]") from t1; +kwic(c1, 20, 4, 0, "(", ")", "埼玉", "[", "]") +(日は[埼玉]ああ)(日も[埼玉]ああ)(日も[埼玉]ああ)(でも[埼玉]ああ) +select kwic(c1, 20, 5, 0, "(", ")", "埼玉", "[", "]") from t1; +kwic(c1, 20, 5, 0, "(", ")", "埼玉", "[", "]") +(日は[埼玉]ああ)(日も[埼玉]ああ)(日も[埼玉]ああ)(でも[埼玉]ああ) +drop table t1; Modified: mysql-5.0.45-tritonn-1.0.6/mysql-test/suite/senna/t/senna_kwic.test =================================================================== --- mysql-5.0.45-tritonn-1.0.6/mysql-test/suite/senna/t/senna_kwic.test 2007-09-27 07:50:08 UTC (rev 22) +++ mysql-5.0.45-tritonn-1.0.6/mysql-test/suite/senna/t/senna_kwic.test 2007-09-28 13:27:45 UTC (rev 23) @@ -73,3 +73,28 @@ # this is acceptable SELECT KWIC("今日は東京 >>> 明日は埼玉に行きます。", 30, 1, 10, "","", "東京", "<span class='word'>", "</span>", ""); SELECT KWIC("今日は東京 >>> 明日は埼玉に行きます。", 30, 1, -30, "","", "東京", "<span class='word'>", "</span>", ""); + +# bugfix for multiple-snippet +--disable_warnings +drop table if exists t1; +--enable_warnings +create table t1 (c1 text) default charset utf8 engine = myisam; + +insert into t1 values("今日は埼玉あああああああああああああああああああああああああああああああああああああ。 +明日も埼玉ああああああああああいいいいいいいいいいいいあああああああああああああああああああああ。 +明後日も埼玉あああああああああああああああああああああああああああああああああああ。 +いつでも埼玉あああああああああああああああああああああああああああああああああ。"); + +select kwic(c1, 20, 1, 0, "", " ...", "埼玉", "<span id=word>", "</span>") from t1; +select kwic(c1, 20, 2, 0, "", " ...", "埼玉", "<span id=word>", "</span>") from t1; +select kwic(c1, 20, 3, 0, "", " ...", "埼玉", "<span id=word>", "</span>") from t1; +select kwic(c1, 20, 4, 0, "", " ...", "埼玉", "<span id=word>", "</span>") from t1; +select kwic(c1, 20, 5, 0, "", " ...", "埼玉", "<span id=word>", "</span>") from t1; + +select kwic(c1, 20, 1, 0, "(", ")", "埼玉", "[", "]") from t1; +select kwic(c1, 20, 2, 0, "(", ")", "埼玉", "[", "]") from t1; +select kwic(c1, 20, 3, 0, "(", ")", "埼玉", "[", "]") from t1; +select kwic(c1, 20, 4, 0, "(", ")", "埼玉", "[", "]") from t1; +select kwic(c1, 20, 5, 0, "(", ")", "埼玉", "[", "]") from t1; + +drop table t1;