diff options
Diffstat (limited to 'storage/mroonga/mysql-test/mroonga/wrapper/r/alter_table_enable_keys_normal.result')
-rw-r--r-- | storage/mroonga/mysql-test/mroonga/wrapper/r/alter_table_enable_keys_normal.result | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/storage/mroonga/mysql-test/mroonga/wrapper/r/alter_table_enable_keys_normal.result b/storage/mroonga/mysql-test/mroonga/wrapper/r/alter_table_enable_keys_normal.result new file mode 100644 index 00000000000..2ba4f1b6386 --- /dev/null +++ b/storage/mroonga/mysql-test/mroonga/wrapper/r/alter_table_enable_keys_normal.result @@ -0,0 +1,26 @@ +DROP TABLE IF EXISTS diaries; +SET NAMES utf8; +CREATE TABLE diaries ( +id int PRIMARY KEY, +title varchar(255), +created_at datetime, +KEY created_at_index (created_at) +) COMMENT='ENGINE "InnoDB"' DEFAULT CHARSET=utf8; +ALTER TABLE diaries DISABLE KEYS; +INSERT INTO diaries VALUES (1, "Hello", "2012-04-30 20:00:00"); +INSERT INTO diaries VALUES (2, "天気" , "2012-04-30 23:00:00"); +INSERT INTO diaries VALUES (3, "富士山", "2012-04-30 19:00:00"); +SELECT * +FROM diaries +FORCE INDEX (created_at_index) +WHERE created_at = "2012-04-30 20:00:00"; +id title created_at +1 Hello 2012-04-30 20:00:00 +ALTER TABLE diaries ENABLE KEYS; +SELECT * +FROM diaries +FORCE INDEX (created_at_index) +WHERE created_at = "2012-04-30 20:00:00"; +id title created_at +1 Hello 2012-04-30 20:00:00 +DROP TABLE diaries; |