Mroonga blog

2023-01-29

Mroonga 12.12 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine.

Mroonga 12.12 has been released!

Changes

Here are important changes in this release:

Improvements

We could not update normal columns when we set composite primary keys using Mroonga storage engine as below.

CREATE TABLE scores (
  name char(30) NOT NULL,
  score int NOT NULL,
  PRIMARY KEY (name, score),
  note char(30),
  FULLTEXT INDEX search_note_idx (note)
) ENGINE = Mroonga DEFAULT CHARSET=utf8mb4;

INSERT INTO scores (name, score) VALUES ("Taro Yamada", 29);

UPDATE scores SET note = "Note"
  WHERE name = "Taro Yamada" AND score = 29;

ERROR 1265 (01000): data truncated for primary key column: <name>

This error doesn’t occur Mroonga with MariaDB.

Thanks

  • handmound

Conclusion

Please refer to release note about the detail of changes in this release.

Let's search by Mroonga!