EVOLUTION-MANAGER
Edit File: optimization_count_skip_index_view.test
# Copyright(C) 2012 Kouhei Sutou <kou@clear-code.com> # # This library is free software; you can redistribute it and/or # modify it under the terms of the GNU Lesser General Public # License as published by the Free Software Foundation; either # version 2.1 of the License, or (at your option) any later version. # # This library is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU # Lesser General Public License for more details. # # You should have received a copy of the GNU Lesser General Public # License along with this library; if not, write to the Free Software # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA --source include/have_innodb.inc --source ../../include/mroonga/have_mroonga.inc --disable_warnings DROP TABLE IF EXISTS diaries, users; --enable_warnings CREATE TABLE diaries ( id INT PRIMARY KEY AUTO_INCREMENT, user_id INT NOT NULL, title VARCHAR(45) NOT NULL, KEY (user_id), FULLTEXT INDEX title_index (title) ) DEFAULT CHARSET=UTF8; CREATE TABLE users ( id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(45) NOT NULL, INDEX (name) ) ENGINE=InnoDB DEFAULT CHARSET=UTF8; INSERT INTO users (id, name) VALUES (1, "Alice"), (2, "Bob"); INSERT INTO diaries (user_id, title) VALUES (1, "survey"); INSERT INTO diaries (user_id, title) VALUES (2, "groonga (1)"); INSERT INTO diaries (user_id, title) VALUES (2, "groonga (2)"); CREATE VIEW articles AS SELECT diaries.user_id AS user_id, diaries.title AS title, users.name AS name FROM diaries, users WHERE diaries.user_id = users.id; SELECT COUNT(*) FROM articles WHERE name = 'Bob'; DROP VIEW articles; DROP TABLE diaries, users; --source ../../include/mroonga/have_mroonga_deinit.inc