Develop and Download Open Source Software

Tritonn

Browse Subversion Repository

/[tritonn]/tags/tritonn-1.0.12-mysql-5.0.83/mysql-test/suite/senna/r/senna_section.result

Annotation of /tags/tritonn-1.0.12-mysql-5.0.83/mysql-test/suite/senna/r/senna_section.result

Parent Directory Parent Directory | Revision Log Revision Log

Revision 184 - (hide annotations) (download)
Thu Jul 1 11:39:40 2010 UTC (13 years, 8 months ago) by myuka
File size: 7034 byte(s) 
added test suite results
  *senna_score_sort.result

modified test suite results
  *senna_cp932.result
  *senna_section.result
  *senna_eucjpms.result
  *senna_utf8.result
  *senna_sjis.result
  *senna_ujis.result
  *senna_util.result
1 myuka 177 SET NAMES utf8;
2     DROP TABLE IF EXISTS t1;
3     CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 VARCHAR(20), c3 TEXT) DEFAULT CHARSET utf8;
4     ALTER TABLE t1 ADD FULLTEXT INDEX ft USING NGRAM, SECTIONALIZE (c2,c3);
5     SHOW SENNA STATUS;
6     Table Key_name Column_name Encoding Index_type Sectionalize Normalize Split_alpha Split_digit Split_symbol Initial_n_segments Senna_keys_size Senna_keys_file_size Senna_lexicon_size Senna_lexicon_file_size Senna_inv_seg_size Senna_inv_chunk_size
7     t1 ft c2 utf8 NGRAM ON ON OFF OFF OFF 512 0 4268032 0 4268032 167936 135168
8     t1 ft c3 utf8 NGRAM ON ON OFF OFF OFF 512 0 4268032 0 4268032 167936 135168
9     INSERT INTO t1 VALUES(1, "c2あたりc2", "c3あたりc3");
10     INSERT INTO t1 VALUES(2, "c2あたりc2", "c3はずれc3");
11     INSERT INTO t1 VALUES(3, "c2はずれc2", "c3あたりc3");
12     INSERT INTO t1 VALUES(4, "c2はずれc2", "c3はずれc3");
13     SELECT * FROM t1;
14     c1 c2 c3
15     1 c2あたりc2 c3あたりc3
16     2 c2あたりc2 c3はずれc3
17     3 c2はずれc2 c3あたりc3
18     4 c2はずれc2 c3はずれc3
19     SELECT *, MATCH(c2,c3) AGAINST("あたり") AS score FROM t1
20     WHERE MATCH(c2,c3) AGAINST("あたり") ORDER BY score DESC;
21     c1 c2 c3 score
22     1 c2あたりc2 c3あたりc3 2
23     2 c2あたりc2 c3はずれc3 1
24     3 c2はずれc2 c3あたりc3 1
25     SELECT *, MATCH(c2,c3) AGAINST("あたり" IN BOOLEAN MODE) AS score FROM t1
26     WHERE MATCH(c2,c3) AGAINST("あたり" IN BOOLEAN MODE) ORDER BY score DESC;
27     c1 c2 c3 score
28     1 c2あたりc2 c3あたりc3 10
29     2 c2あたりc2 c3はずれc3 5
30     3 c2はずれc2 c3あたりc3 5
31     SELECT *, MATCH(c2,c3) AGAINST("*W1 あたり" IN BOOLEAN MODE) AS score FROM t1
32     WHERE MATCH(c2,c3) AGAINST("*W1 あたり" IN BOOLEAN MODE);
33     c1 c2 c3 score
34     1 c2あたりc2 c3あたりc3 1
35     2 c2あたりc2 c3はずれc3 1
36     SELECT *, MATCH(c2,c3) AGAINST("*W2 あたり" IN BOOLEAN MODE) AS score FROM t1
37     WHERE MATCH(c2,c3) AGAINST("*W2 あたり" IN BOOLEAN MODE);
38     c1 c2 c3 score
39     1 c2あたりc2 c3あたりc3 1
40     3 c2はずれc2 c3あたりc3 1
41     SELECT *, MATCH(c2,c3) AGAINST("*W1,2 あたり" IN BOOLEAN MODE) AS score FROM t1
42     WHERE MATCH(c2,c3) AGAINST("*W1,2 あたり" IN BOOLEAN MODE);
43     c1 c2 c3 score
44     1 c2あたりc2 c3あたりc3 2
45 myuka 184 3 c2はずれc2 c3あたりc3 1
46 myuka 177 2 c2あたりc2 c3はずれc3 1
47     SELECT *, MATCH(c2,c3) AGAINST("*W3 あたり" IN BOOLEAN MODE) AS score FROM t1
48     WHERE MATCH(c2,c3) AGAINST("*W3 あたり" IN BOOLEAN MODE);
49     c1 c2 c3 score
50     SELECT *, MATCH(c2,c3) AGAINST("*W1:10,2:1 あたり" IN BOOLEAN MODE) AS score FROM t1
51     WHERE MATCH(c2,c3) AGAINST("*W1:10,2:1 あたり" IN BOOLEAN MODE);
52     c1 c2 c3 score
53     1 c2あたりc2 c3あたりc3 11
54     2 c2あたりc2 c3はずれc3 10
55     3 c2はずれc2 c3あたりc3 1
56     DELETE FROM t1 WHERE c1 = 2;
57     SELECT * FROM t1;
58     c1 c2 c3
59     1 c2あたりc2 c3あたりc3
60     3 c2はずれc2 c3あたりc3
61     4 c2はずれc2 c3はずれc3
62     SELECT *, MATCH(c2,c3) AGAINST("あたり" IN BOOLEAN MODE) AS score FROM t1
63     WHERE MATCH(c2,c3) AGAINST("あたり" IN BOOLEAN MODE);
64     c1 c2 c3 score
65     1 c2あたりc2 c3あたりc3 10
66     3 c2はずれc2 c3あたりc3 5
67     DELETE FROM t1 WHERE c1 = 4;
68     SELECT * FROM t1;
69     c1 c2 c3
70     1 c2あたりc2 c3あたりc3
71     3 c2はずれc2 c3あたりc3
72     DELETE FROM t1;
73     SELECT * FROM t1;
74     c1 c2 c3
75     DROP INDEX ft ON t1;
76     SHOW SENNA STATUS;
77     Table Key_name Column_name Encoding Index_type Sectionalize Normalize Split_alpha Split_digit Split_symbol Initial_n_segments Senna_keys_size Senna_keys_file_size Senna_lexicon_size Senna_lexicon_file_size Senna_inv_seg_size Senna_inv_chunk_size
78     DROP TABLE t1;
79     DROP TABLE IF EXISTS t1;
80     Warnings:
81     Note 1051 Unknown table 't1'
82     CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 VARCHAR(20), c3 INT, c4 TEXT) DEFAULT CHARSET utf8;
83     ALTER TABLE t1 ADD FULLTEXT INDEX ft USING NGRAM, SECTIONALIZE (c2,c4);
84     SHOW SENNA STATUS;
85     Table Key_name Column_name Encoding Index_type Sectionalize Normalize Split_alpha Split_digit Split_symbol Initial_n_segments Senna_keys_size Senna_keys_file_size Senna_lexicon_size Senna_lexicon_file_size Senna_inv_seg_size Senna_inv_chunk_size
86     t1 ft c2 utf8 NGRAM ON ON OFF OFF OFF 512 0 4268032 0 4268032 167936 135168
87     t1 ft c4 utf8 NGRAM ON ON OFF OFF OFF 512 0 4268032 0 4268032 167936 135168
88     INSERT INTO t1 VALUES(1, "c2あたりc2", 100, "c4あたりc4");
89     INSERT INTO t1 VALUES(2, "c2あたりc2", 200, "c4はずれc4");
90     INSERT INTO t1 VALUES(3, "c2はずれc2", 300, "c4あたりc4");
91     INSERT INTO t1 VALUES(4, "c2はずれc2", 400, "c4はずれc4");
92     SELECT *, MATCH(c2,c4) AGAINST("*W1:10,2:1 あたり" IN BOOLEAN MODE) AS score FROM t1
93     WHERE MATCH(c2,c4) AGAINST("*W1:10,2:1 あたり" IN BOOLEAN MODE);
94     c1 c2 c3 c4 score
95     1 c2あたりc2 100 c4あたりc4 11
96     2 c2あたりc2 200 c4はずれc4 10
97     3 c2はずれc2 300 c4あたりc4 1
98     DELETE FROM t1 WHERE c1 = 2;
99     SELECT * FROM t1;
100     c1 c2 c3 c4
101     1 c2あたりc2 100 c4あたりc4
102     3 c2はずれc2 300 c4あたりc4
103     4 c2はずれc2 400 c4はずれc4
104     SELECT *, MATCH(c2,c4) AGAINST("*W1:10,2:1 あたり" IN BOOLEAN MODE) AS score FROM t1
105     WHERE MATCH(c2,c4) AGAINST("*W1:10,2:1 あたり" IN BOOLEAN MODE);
106     c1 c2 c3 c4 score
107     1 c2あたりc2 100 c4あたりc4 11
108     3 c2はずれc2 300 c4あたりc4 1
109     INSERT INTO t1 VALUES(2, "c2あたりc2", 200, "c4はずれc4");
110     ALTER TABLE t1 ADD c2a INT AFTER c2;
111     UPDATE t1 SET c2a = 10;
112     SELECT *, MATCH(c2,c4) AGAINST("*W1:10,2:1 あたり" IN BOOLEAN MODE) AS score FROM t1
113     WHERE MATCH(c2,c4) AGAINST("*W1:10,2:1 あたり" IN BOOLEAN MODE);
114     c1 c2 c2a c3 c4 score
115     1 c2あたりc2 10 100 c4あたりc4 11
116     2 c2あたりc2 10 200 c4はずれc4 10
117     3 c2はずれc2 10 300 c4あたりc4 1
118     DELETE FROM t1 WHERE c1 = 2;
119     SELECT * FROM t1;
120     c1 c2 c2a c3 c4
121     1 c2あたりc2 10 100 c4あたりc4
122     3 c2はずれc2 10 300 c4あたりc4
123     4 c2はずれc2 10 400 c4はずれc4
124     SELECT *, MATCH(c2,c4) AGAINST("*W1:10,2:1 あたり" IN BOOLEAN MODE) AS score FROM t1
125     WHERE MATCH(c2,c4) AGAINST("*W1:10,2:1 あたり" IN BOOLEAN MODE);
126     c1 c2 c2a c3 c4 score
127     1 c2あたりc2 10 100 c4あたりc4 11
128     3 c2はずれc2 10 300 c4あたりc4 1
129     SHOW SENNA STATUS;
130     Table Key_name Column_name Encoding Index_type Sectionalize Normalize Split_alpha Split_digit Split_symbol Initial_n_segments Senna_keys_size Senna_keys_file_size Senna_lexicon_size Senna_lexicon_file_size Senna_inv_seg_size Senna_inv_chunk_size
131     t1 ft c2 utf8 NGRAM ON ON OFF OFF OFF 512 4 8462336 9 8462336 2789376 135168
132     t1 ft c4 utf8 NGRAM ON ON OFF OFF OFF 512 4 8462336 9 8462336 2789376 135168
133     DELETE FROM t1;
134     SHOW SENNA STATUS;
135     Table Key_name Column_name Encoding Index_type Sectionalize Normalize Split_alpha Split_digit Split_symbol Initial_n_segments Senna_keys_size Senna_keys_file_size Senna_lexicon_size Senna_lexicon_file_size Senna_inv_seg_size Senna_inv_chunk_size
136     t1 ft c2 utf8 NGRAM ON ON OFF OFF OFF 512 0 4268032 0 4268032 167936 135168
137     t1 ft c4 utf8 NGRAM ON ON OFF OFF OFF 512 0 4268032 0 4268032 167936 135168
138     DROP TABLE t1;
139     SHOW SENNA STATUS;
140     Table Key_name Column_name Encoding Index_type Sectionalize Normalize Split_alpha Split_digit Split_symbol Initial_n_segments Senna_keys_size Senna_keys_file_size Senna_lexicon_size Senna_lexicon_file_size Senna_inv_seg_size Senna_inv_chunk_size
Back to OSDN">Back to OSDN
 ViewVC Help
Powered by ViewVC 1.1.26  
About OSDN
Find Software
Develop Software
Help