gistfile1.txt

mysql> DROP DATABASE IF EXISTS mroonga;
Query OK, 1 row affected (0.05 sec)

mysql> CREATE DATABASE mroonga;
Query OK, 1 row affected (0.00 sec)

mysql> use mroonga;
Database changed

mysql> CREATE TABLE t1 (num serial, c1 text, c2 text, c3 text, c4 text, c5 text, c6 text, c7 text, c8 text, c9 text, c10 text, FULLTEXT KEY(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10)) Engine= mroonga;
Query OK, 0 rows affected (0.23 sec)

mysql> INSERT INTO t1 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10) VALUES ('いち', 'に', 'さん', 'し', 'ご', 'ろく', 'しち', 'は ち', 'きゅう', 'じゅう');
Query OK, 1 row affected (0.02 sec)


-------------------------------------------------------
mysql> SELECT @@mroonga_version;
+-------------------+
| @@mroonga_version |
+-------------------+
| 3.11              |
+-------------------+
1 row in set (0.00 sec)

mysql> SELECT
    ->   MATCH (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10) AGAINST ('+いち' IN BOOLEAN MODE) AS score,
    ->   MATCH (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10) AGAINST ('*W0:1,1:0,2:0,3:0,4:0,5:0,6:0,7:0,8:0,9:0 +いち' IN BOOLEAN MODE) AS score1,
    ->   MATCH (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10) AGAINST ('*W0:0,1:1,2:0,3:0,4:0,5:0,6:0,7:0,8:0,9:0 +いち' IN BOOLEAN MODE) AS score2,
    ->   MATCH (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10) AGAINST ('*W0:0,1:0,2:1,3:0,4:0,5:0,6:0,7:0,8:0,9:0 +いち' IN BOOLEAN MODE) AS score3,
    ->   MATCH (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10) AGAINST ('*W0:0,1:0,2:0,3:1,4:0,5:0,6:0,7:0,8:0,9:0 +いち' IN BOOLEAN MODE) AS score4,
    ->   MATCH (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10) AGAINST ('*W0:0,1:0,2:0,3:0,4:1,5:0,6:0,7:0,8:0,9:0 +いち' IN BOOLEAN MODE) AS score5,
    ->   MATCH (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10) AGAINST ('*W0:0,1:0,2:0,3:0,4:0,5:1,6:0,7:0,8:0,9:0 +いち' IN BOOLEAN MODE) AS score6,
    ->   MATCH (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10) AGAINST ('*W0:0,1:0,2:0,3:0,4:0,5:0,6:1,7:0,8:0,9:0 +いち' IN BOOLEAN MODE) AS score7,
    ->   MATCH (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10) AGAINST ('*W0:0,1:0,2:0,3:0,4:0,5:0,6:0,7:1,8:0,9:0 +いち' IN BOOLEAN MODE) AS score8,
    ->   MATCH (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10) AGAINST ('*W0:0,1:0,2:0,3:0,4:0,5:0,6:0,7:0,8:1,9:0 +いち' IN BOOLEAN MODE) AS score9,
    ->   MATCH (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10) AGAINST ('*W0:0,1:0,2:0,3:0,4:0,5:0,6:0,7:0,8:0,9:1 +いち' IN BOOLEAN MODE) AS score10
    -> FROM t1 WHERE MATCH (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10) AGAINST ('+いち' IN BOOLEAN MODE);
+-------+--------+--------+--------+--------+--------+--------+--------+--------+--------+---------+
| score | score1 | score2 | score3 | score4 | score5 | score6 | score7 | score8 | score9 | score10 |
+-------+--------+--------+--------+--------+--------+--------+--------+--------+--------+---------+
|     1 |      1 |      0 |      0 |      0 |      0 |      0 |      0 |      0 |      0 |       0 |
+-------+--------+--------+--------+--------+--------+--------+--------+--------+--------+---------+
1 row in set (0.01 sec)


-------------------------------------------------------
mysql> SELECT @@mroonga_version;
+-------------------+
| @@mroonga_version |
+-------------------+
| 3.12              |
+-------------------+
1 row in set (0.00 sec)

mysql> SELECT
    ->   MATCH (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10) AGAINST ('+いち' IN BOOLEAN MODE) AS score,
    ->   MATCH (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10) AGAINST ('*W1:1,2:0,3:0,4:0,5:0,6:0,7:0,8:0,9:0,10:0 +いち' IN BOOLEAN MODE) AS score1,
    ->   MATCH (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10) AGAINST ('*W1:0,2:1,3:0,4:0,5:0,6:0,7:0,8:0,9:0,10:0 +いち' IN BOOLEAN MODE) AS score2,
    ->   MATCH (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10) AGAINST ('*W1:0,2:0,3:1,4:0,5:0,6:0,7:0,8:0,9:0,10:0 +いち' IN BOOLEAN MODE) AS score3,
    ->   MATCH (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10) AGAINST ('*W1:0,2:0,3:0,4:1,5:0,6:0,7:0,8:0,9:0,10:0 +いち' IN BOOLEAN MODE) AS score4,
    ->   MATCH (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10) AGAINST ('*W1:0,2:0,3:0,4:0,5:1,6:0,7:0,8:0,9:0,10:0 +いち' IN BOOLEAN MODE) AS score5,
    ->   MATCH (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10) AGAINST ('*W1:0,2:0,3:0,4:0,5:0,6:1,7:0,8:0,9:0,10:0 +いち' IN BOOLEAN MODE) AS score6,
    ->   MATCH (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10) AGAINST ('*W1:0,2:0,3:0,4:0,5:0,6:0,7:1,8:0,9:0,10:0 +いち' IN BOOLEAN MODE) AS score7,
    ->   MATCH (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10) AGAINST ('*W1:0,2:0,3:0,4:0,5:0,6:0,7:0,8:1,9:0,10:0 +いち' IN BOOLEAN MODE) AS score8,
    ->   MATCH (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10) AGAINST ('*W1:0,2:0,3:0,4:0,5:0,6:0,7:0,8:0,9:1,10:0 +いち' IN BOOLEAN MODE) AS score9,
    ->   MATCH (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10) AGAINST ('*W1:0,2:0,3:0,4:0,5:0,6:0,7:0,8:0,9:0,10:1 +いち' IN BOOLEAN MODE) AS score10
    -> FROM t1 WHERE MATCH (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10) AGAINST ('+いち' IN BOOLEAN MODE);
+-------+--------+--------+--------+--------+--------+--------+--------+--------+--------+---------+
| score | score1 | score2 | score3 | score4 | score5 | score6 | score7 | score8 | score9 | score10 |
+-------+--------+--------+--------+--------+--------+--------+--------+--------+--------+---------+
|     1 |      0 |      0 |      0 |      0 |      0 |      0 |      0 |      0 |      0 |       0 |
+-------+--------+--------+--------+--------+--------+--------+--------+--------+--------+---------+
1 row in set (0.00 sec)