Adding upstream version 1:10.11.6.upstream/1%10.11.6upstream

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

1 files changed, 30 insertions, 0 deletions

diff --git a/mysql-test/include/execute_with_statistics.inc b/mysql-test/include/execute_with_statistics.inc
new file mode 100644
index 00000000..c2305fe5
--- /dev/null
+++ b/mysql-test/include/execute_with_statistics.inc
@@ -0,0 +1,30 @@
+# include/execute_with_statistics.inc
+#
+# SUMMARY
+#
+#    Explain and execute the select statment in $query.
+#    Then report 'Last_query_cost' estimate from the query
+#    optimizer and total number of 'Handler_read%' when the
+#    query was executed.
+#    Intended usage is to verify that there are not regressions
+#    in either calculated or actuall cost for $query.
+#
+# USAGE
+#
+#    let $query= <select statement>;
+#    --source include/execute_with_statistics.inc
+#
+# EXAMPLE
+#    t/greedy_optimizer.test
+#
+
+eval EXPLAIN $query;
+SHOW STATUS LIKE 'Last_query_cost';
+
+FLUSH STATUS;
+eval $query;
+--disable_warnings
+SELECT SUM(variable_value) AS Total_handler_reads
+   FROM information_schema.session_status
+   WHERE variable_name LIKE 'Handler_read%';
+--enable_warnings