Kentaro Hayashi
null+****@clear*****
Fri Sep 30 14:28:41 JST 2016
Kentaro Hayashi 2016-09-30 14:28:41 +0900 (Fri, 30 Sep 2016) New Revision: d9d9499d53120159e538c111c92b599f80a4bc28 https://github.com/mroonga/mroonga.github.com/commit/d9d9499d53120159e538c111c92b599f80a4bc28 Message: blog an: add 6.09 entry Added files: en/_posts/2016-09-29-mroonga-6.09.md Added: en/_posts/2016-09-29-mroonga-6.09.md (+47 -0) 100644 =================================================================== --- /dev/null +++ en/_posts/2016-09-29-mroonga-6.09.md 2016-09-30 14:28:41 +0900 (561fabc) @@ -0,0 +1,47 @@ +--- +layout: post.en +title: Mroonga 6.09 has been released! +description: Mroonga 6.09 has been released! +--- + +## Mroonga 6.09 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 6.09](/docs/news.html#release-6-09) has been released! + + * How to install: [Install](/docs/install.html) + * How to upgrade: [Upgrade guide](/docs/upgrade.html) + +### Changes + +Here is the topic in this release. + + * Supported nonexistent reference insert check for FOREIGN KEY + +#### Supported nonexistent reference insert check for FOREIGN KEY + +In the previous versions, there is no support about reference insert check for FOREIGN KEY. + + create table HOGES( + ID INT PRIMARY KEY AUTO_INCREMENT, + HOGE VARCHAR(255) + ) ENGINE=Mroonga; + create table FOODS( + ID INT PRIMARY KEY AUTO_INCREMENT, + HOGE_ID INT(10), + FOO VARCHAR(255), + foreign key(HOGE_ID) references HOGES(ID) + ) ENGINE=Mroonga ; + +so, invalid data was inserted without error if you use above schema. + +Note that FOREIGN KEY check doesn't work for old version of MySQL and folks such as MySQL 5.5 or MariaDB 5.5, and FOREIGN KEY check for INSERT/DELETE is not supported yet. (it will be supported in the future release!) + +### Conclusion + +Please refer to [Release 6.09 - 2016-09-29](/docs/news.html#release-6-09-2016-09-29) about detailed changes since 6.08. + +Let's go all out to search by Mroonga! -------------- next part -------------- HTML����������������������������...下載
