how_to_reproduce.txt

-- 1st_connection

mysql> pager cat >/dev/null
PAGER set to 'cat >/dev/null'

mysql> SELECT * FROM myisam INNER JOIN mroonga USING(val);

-- 2nd_connection
mysql> DELETE FROM mroonga;
Query OK, 10000 rows affected (0.04 sec)

packages.txt

# rpm -qa | grep roonga
groonga-libs-4.0.0-1.el6.x86_64
groonga-4.0.0-1.el6.x86_64
groonga-server-http-4.0.0-1.el6.x86_64
groonga-release-1.1.0-1.noarch
groonga-plugin-suggest-4.0.0-1.el6.x86_64
groonga-server-common-4.0.0-1.el6.x86_64
groonga-normalizer-mysql-devel-1.0.6-1.el6.x86_64
groonga-tokenizer-mecab-4.0.0-1.el6.x86_64
groonga-tools-2.0.0-0.el6.x86_64
groonga-normalizer-mysql-1.0.6-1.el6.x86_64
groonga-devel-4.0.0-1.el6.x86_64

# rpm -qa | grep MySQL
MySQL-embedded-5.6.16-1.linux_glibc2.5.x86_64
perl-DBD-MySQL-4.020-2.8.amzn1.x86_64
MySQL-devel-5.6.16-1.linux_glibc2.5.x86_64
MySQL-test-5.6.16-1.linux_glibc2.5.x86_64
MySQL-shared-compat-5.6.16-1.linux_glibc2.5.x86_64
MySQL-server-5.6.16-1.linux_glibc2.5.x86_64
MySQL-client-5.6.16-1.linux_glibc2.5.x86_64
MySQL-shared-5.6.16-1.linux_glibc2.5.x86_64

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

test_data.txt

# yes "0" | head -10000 > /tmp/zero

mysql> DROP DATABASE IF EXISTS mroonga;
Query OK, 2 rows affected (0.01 sec)

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

mysql> use mroonga;
Database changed

mysql> CREATE TABLE mroonga (num serial, val varchar(32)) Engine= Mroonga;
Query OK, 0 rows affected (0.09 sec)

mysql> LOAD DATA INFILE '/tmp/zero' INTO TABLE mroonga(num);
Query OK, 10000 rows affected (0.41 sec)
Records: 10000  Deleted: 0  Skipped: 0  Warnings: 0

mysql> UPDATE mroonga SET val= md5(num);
Query OK, 10000 rows affected (0.74 sec)
Rows matched: 10000  Changed: 10000  Warnings: 0

mysql> CREATE TABLE myisam (num serial, val varchar(32)) Engine= MyISAM;
Query OK, 0 rows affected (0.02 sec)

mysql> LOAD DATA INFILE '/tmp/zero' INTO TABLE myisam(num);
Query OK, 10000 rows affected (0.20 sec)
Records: 10000  Deleted: 0  Skipped: 0  Warnings: 0

mysql> UPDATE myisam SET val= md5(num);
Query OK, 10000 rows affected (0.57 sec)
Rows matched: 10000  Changed: 10000  Warnings: 0