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

Contents 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 177 - (show annotations) (download)
Mon Jul 6 09:38:02 2009 UTC (14 years, 8 months ago) by myuka
File size: 7034 byte(s) 
Initial inport
1 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 2 c2あたりc2 c3はずれc3 1
46 3 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