From: Jorgen Loland
Date: December 6 2010 1:38pm
Subject: bzr commit into mysql-next-mr-bugfixing branch (jorgen.loland:3240) WL#4800
List-Archive: http://lists.mysql.com/commits/126135
Message-Id: <20101206133844.4BB50AE2@atum21.norway.sun.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============8675423569401430296=="

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

#At file:///export/home/jl208045/mysql/wl4800/mysql-next-mr-opt-backporting-wl4800/ based on revid:guilhem@stripped

 3240 Jorgen Loland	2010-12-06
      WL#4800:
      The optimizer may have second thoughts about which access method
      to use for a table. This needs to be traced, so added item to 
      WL4800 TODO list.
     @ WL4800_TODO.txt
        Added todo-item

    modified:
      WL4800_TODO.txt
=== modified file 'WL4800_TODO.txt'
--- a/WL4800_TODO.txt	2010-11-24 18:54:26 +0000
+++ b/WL4800_TODO.txt	2010-12-06 13:38:41 +0000
@@ -47,3 +47,11 @@ http://lists.mysql.com/commits/124599
 
 check save_in_field_no_warnings() in opt_range.cc: do we need to
 disable tracing there? see optimizer_trace_no_prot.result.
+
+The optimizer may have second thoughts about which access method to
+use for a table. This should be traced. See example query (1) where
+the trace says that ref-access is best but we change our mind and use
+range access anyway.
+(1)CREATE TABLE t1 (a int, b int, PRIMARY KEY (a,b), KEY b (b));
+   INSERT INTO t1 VALUES (1,1),(1,2),(1,0),(1,3);
+   SELECT MAX(b), a FROM t1 WHERE b < 2 AND a = 1 GROUP BY a;


--===============8675423569401430296==
MIME-Version: 1.0
Content-Type: text/bzr-bundle; charset="us-ascii";
	name="bzr/jorgen.loland@stripped"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

# Bazaar merge directive format 2 (Bazaar 0.90)
# revision_id: jorgen.loland@stripped\
#   h6uw29vjj2hlaz7i
# target_branch: file:///export/home/jl208045/mysql/wl4800/mysql-next-\
#   mr-opt-backporting-wl4800/
# testament_sha1: 5bcead2e2111bddd7a27ee62c808ef4fa46ecf10
# timestamp: 2010-12-06 14:38:44 +0100
# source_branch: file:///export/home/jl208045/mysql/wl4800/mysql-next-\
#   mr-opt-backporting-wl4800/
# base_revision_id: guilhem@stripped
# 
# Begin bundle
IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWRVcqAUAAePfgEAQWGf//3//
3+C////wUATGl7RhpNoaahMMiEJiYENqaptT1P0p+lBo9TaRmSemk09QbFDQ5pkZDJghowmCNNGj
EDTJkYAAgyCBBT2qm8piaZJmp6EDQADQGmhk00OaZGQyYIaMJgjTRoxA0yZGAAIJJENSeGiGEU/T
JJ6IHqAAZNBoAaCTusxz2j8V+AeIRXCJaX2soQmCLKy2FrKKU3UBojH+659u5X98qIn5yDk2C+m9
sDmsjp8L9iw1d1N9DFb6NWFRENUHER8hq6Rr3XhdOEIaJkdWswzZSbo3AwTWtCzLYoUvdfL5WCQg
jPkq4Ck8nsQa/eqvz57iqEd+bTjVAh4Jqz2m9ZaKGLQiVKWAWNAyAj+n9MTHADpa97T0t433aPKE
rBTGK3YAGJuJ2XlNDWQ4ac8SFs1M3AmmADE4sQWJGSngi7J4F7iUJE5HLQSpw+TcQoLmBj1RZFAv
KmU1+GQg643jLidlna7G4gU4Fq6rPN4O4aDzlmMIuyYp4upoOEkGJWmzLY3x0j1hu6BKdBvK78aq
8lCbJ6dfJziucGNEv7FJErnJoLOeAqImN8ILyzQLyrVYKMxqe18KNk5a1QplLAMqJNz3GG+oyPDd
0uHLJg02HggUE/ZacXOJmdQZ2swsi+Kcx4lpmnaCjFgH0CIgbs3aYBccL6KJ6aXjI99toNJbUDi9
8AtR0RFt4wZThsGe2HKDXgleAN/vMZAwW0qEW6u/TNoEcbGae7IBUoZAujKKogjeyW0yYBZIHCGC
lliiiYEpImfnFfOEHkxkT44jo35iGE7ecfbsTTJMgRE8YIKE49hk5dKRr9v2nPmJR/JqKoGA5dyr
7nYrKPxVAhsF0Z/z89fY9qR3kpNYOvaNAUZqqMX4VnbbivMN/i2KR+vYwgbx0oEc8ic3ijH1OJhj
vQbzw2qSybbhnDgPGmTzbtjQlagzrmI1tRUUIPrLEC+I2cEqkCdoeMkJcHmeYsGZ2c7C8WWFZoiH
b1FoHUYnI1Fkz2AbrSI0HyX15DbIOHucxp7XUTkq92iZaqvCJQn5tlXmYLoGk1ArYq14+rjfdgNg
g2nuD8gckfaY1xN8mPf4cK+sg6goCq/dp1DbBjQdWOeUlVtrbbybGGbWfx05qDWBOYplxW0taELt
/drowDEzaDFQd22lSadt16cNQYHefMZlh2dvJq8LBwPO+9ZC1gOwJQ4ZG/WsJxO2Aw+k6R3JzBzq
QoFKGjItX5XcLkymH4rgmOLsrQpFF6xcbegi0BwFjuIFEbnDV6bYMgDqxmBi+emZiTAVygL7HqGp
qzMAaleRGIO3hWEZF9/GBrFsqy4txIpOSw7m3R5kowjUIbinODmU5SqIlThNhXWwpGITe2Uf/ASu
mhKGzx2CDhVAQl2scuXci55DQhmTKV/MbWKwfsHhp6LkrgU4Ma5SNhYN0mwDu2kueAOcsDPIZ8Wz
ogG1xJOWzVGB64GhFMdJiEE9NrHAwJG5wvSRF7sIgCGxTNcHcIhcX76FBXU7iksCouZNCXPYAszR
+S0ihMkmRhclx9G8IqassbTJ3DB8j4HFowiOGi5XBQ2WuowCwMkyOALE9NtJnKPBG9Yc8TiDZ0up
I7nnkFrIq7w3h7RWrcLlNOdYcvHt5b6e8uUHA23MtGZrE99aLX3SJaVmBU7VL0Vn/i7kinChICq5
UAo=


--===============8675423569401430296==--