1# Copyright(C) 2014 Kouhei Sutou <kou@clear-code.com> 2# 3# This library is free software; you can redistribute it and/or 4# modify it under the terms of the GNU Lesser General Public 5# License as published by the Free Software Foundation; either 6# version 2.1 of the License, or (at your option) any later version. 7# 8# This library is distributed in the hope that it will be useful, 9# but WITHOUT ANY WARRANTY; without even the implied warranty of 10# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU 11# Lesser General Public License for more details. 12# 13# You should have received a copy of the GNU Lesser General Public 14# License along with this library; if not, write to the Free Software 15# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1335 USA 16 17--source include/not_embedded.inc 18--source ../../include/mroonga/skip_solaris.inc 19--source ../../include/mroonga/have_mroonga.inc 20--source ../../include/mroonga/have_mroonga_helper.inc 21 22CREATE DATABASE repair_test; 23USE repair_test; 24 25CREATE TABLE diaries ( 26 id INT PRIMARY KEY AUTO_INCREMENT, 27 title TEXT, 28 body TEXT, 29 FULLTEXT INDEX body_index (body) 30) DEFAULT CHARSET UTF8; 31 32INSERT INTO diaries (title, body) VALUES ("survey", "will start Groonga!"); 33INSERT INTO diaries (title, body) VALUES ("Groonga (1)", "starting Groonga..."); 34INSERT INTO diaries (title, body) VALUES ("Groonga (2)", "started Groonga."); 35 36SELECT * FROM diaries WHERE MATCH(body) AGAINST("+starting" IN BOOLEAN MODE); 37 38--remove_file $MYSQLD_DATADIR/repair_test.mrn.000010E.c 39 40FLUSH TABLES; 41 42# Error ER_CANT_OPEN_FILE system call error: No such file or directory: failed to open path: <repair_test.mrn.000010E.c> 43--error ER_CANT_OPEN_FILE 44SELECT * FROM diaries WHERE MATCH(body) AGAINST("+starting" IN BOOLEAN MODE); 45 46REPAIR TABLE diaries; 47 48SELECT * FROM diaries; 49 50SELECT * FROM diaries WHERE MATCH(body) AGAINST("+starting" IN BOOLEAN MODE); 51 52DROP TABLE diaries; 53 54DROP DATABASE repair_test; 55USE test; 56 57--source ../../include/mroonga/have_mroonga_deinit.inc 58