From: Ole John Aske
Date: February 22 2011 5:44pm
Subject: bzr commit into mysql-5.1-telco-7.0 branch (ole.john.aske:4218)
List-Archive: http://lists.mysql.com/commits/131873
Message-Id: <20110222174442.67AF0223@fimafeng09.norway.sun.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============6218260930807065511=="

--===============6218260930807065511==
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

#At file:///net/fimafeng09/export/home/tmp/oleja/mysql/mysql-5.1-telco-7.0/ based on revid:ole.john.aske@stripped

 4218 Ole John Aske	2011-02-22
      Added missing file from previous commit. 

    added:
      mysql-test/include/execute_with_statistics.inc
=== added file 'mysql-test/include/execute_with_statistics.inc'
--- a/mysql-test/include/execute_with_statistics.inc	1970-01-01 00:00:00 +0000
+++ b/mysql-test/include/execute_with_statistics.inc	2011-02-22 17:44:38 +0000
@@ -0,0 +1,28 @@
+# 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;
+SELECT SUM(variable_value) AS Total_handler_reads
+   FROM information_schema.session_status
+   WHERE variable_name LIKE 'Handler_read%';


--===============6218260930807065511==
MIME-Version: 1.0
Content-Type: text/bzr-bundle; charset="us-ascii";
	name="bzr/ole.john.aske@stripped"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

# Bazaar merge directive format 2 (Bazaar 0.90)
# revision_id: ole.john.aske@stripped\
#   mvlio73dc0dwia76
# target_branch: file:///net/fimafeng09/export/home/tmp/oleja/mysql\
#   /mysql-5.1-telco-7.0/
# testament_sha1: 28c3e8587b089f5d26a2c71d9c44a2f009c081d0
# timestamp: 2011-02-22 18:44:42 +0100
# base_revision_id: ole.john.aske@stripped\
#   l701sts3y40au9gh
# 
# Begin bundle
IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWRElBwwAAbnfgEAQXuP//3v/
3uC////wUASzYYNtetVqhd72vQkkTIJiqf6htNMmjST1T2k2qbQyan6KPU2iNNME9BKIjTJlM00R
lTaGpkaHqAAGjQA9IANARCMUeoeSDygGg0DQAyAAAIaqNNNPRPUDENGgDQ0AAAAADCUgVP1NMI1P
NUaaep6jyg0NAaGgaaABoGIGhtPrsKQ0YcDr9Xb6TZKDCxn96rGpGJhnuZEURV3bmGDGV5IglqA0
Yfnh+PRs+eDFntzH/Yd2nNVlKbN+yGM6oDsy8uSLHCuU5Dtmufb8n85K/bYULBJ8iLppPQxt7vJQ
we8cUSQhCqY175rMMdmbXrq1pzI50gvRWWcBno0b5+rcVKUYW8wtl0x9ioFX89PrudI0vVfpnzCK
RGKYR/uV2qQzS0vgVtHsSH1pkjtXMfM5LggpnK/IWeG+6JWhz93dFIxMOuhIc+D9VoYLwuX0muIx
gBXj1c1hHCxI4a5pkiFaIdgUEsqRDR2uREaZ6pzYGywlbpeY3I8yJuZSFoi2GeFICcqQfxEjBeNL
K72HGNEr21CKxGvVGDiRcNMzrndLJ9BvGmLLagsPBgZtYjnWVUV0KkoE7pxYVPvejtvLziargKCc
U+RLcBKYcRpsjWJWtNTtxCy2wyxm56VDS6Q0XF8riMlx5Lp/pLL9CCmb5+A3pQMYDqRwNxECMT3x
0XDixCsLh159JMKDQ64dURGb/Pp11dpqdZMMw3YfGf5H/RfTxnPdQ74w8GwJiSWPyOBe0+7zh161
thhPLZZKL4KpRV1BwoVmFTTMZjgyJPI4XZYjkSOO9dvjGQch0RZPXS3ScHr+BdnA83nX/X6CFMoc
s40KPwoMkeRsBz4zeIZWXkLh+5xCsw3FF+RwyWdceId5xwl428p69BwGgLGE54G3a09+qnyJvQVb
NupiiDU02iEZL/Da9KEHsRIKiq0kzKXUP6HpWnHWPvipsBddqwlr6Nw9fCSjyrFTn8rdutxu9NMk
pJby8swIYVtcSmltTt+q4QlaWjngpUhqILnUf5EnfYq9m3oNeWa2ph18ls2xrPg4quMzmG0Zmbgm
DTDe7maXQoTzadmpA4SuZ80YymS0cgzP4qFLej7KyiqDK7dkYQItM0SztyZOXS79R4+WTTdWLart
lhciIdLv7Zbypo92yBikZ0WRtEpCdqRyIpdQ7ADEIFGXGkTTAEy6dGHUdYI4KWN0znBrkQ2dFroM
S7egsEYHmSpHoOYLSdoZgipL08IdHO9/fuKRGQh1DWEpsWOgVBppssqUNlZ2MIpeVsTxL4aomWOo
eUE0R1wnNIelicg8QyL54KZkwwRcoPUsLZIh5MosoOVNXI8VkPPtEX0xGMUvbeRAlt0RSmFVM0v8
IXgYFgtLqYl78LZddL2aZkofHZftjGqIpEwer+IZwgLxWmRICLavqzlilUyEJKbChNKkssCXImpJ
KIbiKgAAEAZ00oCG4prnnJa8pW2bb8N82HO+DwU8bfTMQuKK/m6ScVTWjBjxZxIGbEtAGMjpW2Rb
JrAzANLayhiuEQhANgYyCHgx1M99BZIMBVdGKXLM0K0R1QRRisRzEfNwSv0VBwQc8uuimyhq4pWl
z/ZMnSIoE7uGrFKiCXiyvxL1Q9iKhZaY5BUc0P+LuSKcKEgIkoOGAA==


--===============6218260930807065511==--