diff options
Diffstat (limited to 'storage/mroonga/mysql-test/mroonga/wrapper/r/transaction_query_cache.result')
-rw-r--r-- | storage/mroonga/mysql-test/mroonga/wrapper/r/transaction_query_cache.result | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/storage/mroonga/mysql-test/mroonga/wrapper/r/transaction_query_cache.result b/storage/mroonga/mysql-test/mroonga/wrapper/r/transaction_query_cache.result new file mode 100644 index 00000000000..54afac7a1a7 --- /dev/null +++ b/storage/mroonga/mysql-test/mroonga/wrapper/r/transaction_query_cache.result @@ -0,0 +1,28 @@ +SET @tmp_query_cache_size = @@query_cache_size; +SET GLOBAL query_cache_size = 1048576; +DROP TABLE IF EXISTS simple_table; +CREATE TABLE simple_table ( +id INT PRIMARY KEY +) COMMENT = 'ENGINE "InnoDB"' DEFAULT CHARSET=UTF8; +SHOW CREATE TABLE simple_table; +Table Create Table +simple_table CREATE TABLE `simple_table` ( + `id` int(11) NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=Mroonga DEFAULT CHARSET=utf8 COMMENT='ENGINE "InnoDB"' +INSERT INTO simple_table (id) VALUES (1),(2); +USE test; +START TRANSACTION; +INSERT INTO simple_table (id) VALUES (3); +SELECT * FROM simple_table; +id +1 +2 +COMMIT; +SELECT * FROM simple_table; +id +1 +2 +3 +DROP TABLE simple_table; +SET GLOBAL query_cache_size = @tmp_query_cache_size; |