[Groonga-mysql-commit] mroonga/mroonga at 1959b83 [master] test: check really optimized

Back to archive index

Kouhei Sutou null+****@clear*****
Sat Mar 24 12:24:22 JST 2018


Kouhei Sutou	2018-03-24 12:24:22 +0900 (Sat, 24 Mar 2018)

  New Revision: 1959b83c5ee7a99a7ee62ebd41405b0e06794611
  https://github.com/mroonga/mroonga/commit/1959b83c5ee7a99a7ee62ebd41405b0e06794611

  Message:
    test: check really optimized

  Modified files:
    mysql-test/mroonga/storage/optimization/condition_push_down/one_full_text_search/r/not_in.result
    mysql-test/mroonga/storage/optimization/condition_push_down/one_full_text_search/t/not_in.test

  Modified: mysql-test/mroonga/storage/optimization/condition_push_down/one_full_text_search/r/not_in.result (+4 -0)
===================================================================
--- mysql-test/mroonga/storage/optimization/condition_push_down/one_full_text_search/r/not_in.result    2018-03-24 12:23:53 +0900 (da42287a)
+++ mysql-test/mroonga/storage/optimization/condition_push_down/one_full_text_search/r/not_in.result    2018-03-24 12:24:22 +0900 (e6dab587)
@@ -1,4 +1,5 @@
 DROP TABLE IF EXISTS memos;
+FLUSH STATUS;
 SET NAMES UTF8;
 CREATE TABLE memos (
 id INT UNSIGNED,
@@ -15,4 +16,7 @@ id NOT IN (1, 2)
 ORDER BY id;
 id	content
 4	Groonga is great!
+SHOW STATUS LIKE 'mroonga_condition_push_down';
+Variable_name	Value
+Mroonga_condition_push_down	1
 DROP TABLE memos;

  Modified: mysql-test/mroonga/storage/optimization/condition_push_down/one_full_text_search/t/not_in.test (+4 -0)
===================================================================
--- mysql-test/mroonga/storage/optimization/condition_push_down/one_full_text_search/t/not_in.test    2018-03-24 12:23:53 +0900 (bf5a06eb)
+++ mysql-test/mroonga/storage/optimization/condition_push_down/one_full_text_search/t/not_in.test    2018-03-24 12:24:22 +0900 (4b30f078)
@@ -20,6 +20,8 @@
 DROP TABLE IF EXISTS memos;
 --enable_warnings
 
+FLUSH STATUS;
+
 SET NAMES UTF8;
 CREATE TABLE memos (
   id INT UNSIGNED,
@@ -37,6 +39,8 @@ SELECT * FROM memos
        id NOT IN (1, 2)
  ORDER BY id;
 
+SHOW STATUS LIKE 'mroonga_condition_push_down';
+
 DROP TABLE memos;
 
 --source ../../../../../include/mroonga/have_mroonga_deinit.inc
-------------- next part --------------
HTML����������������������������...
URL: https://lists.osdn.me/mailman/archives/groonga-mysql-commit/attachments/20180324/2c7a808c/attachment-0001.htm 



More information about the Groonga-mysql-commit mailing list
Back to archive index