From: Ole John Aske
Date: December 1 2010 9:35pm
Subject: bzr commit into mysql-5.1-telco-7.0-spj-scan-vs-scan branch
 (ole.john.aske:3382) Bug#58628
List-Archive: http://lists.mysql.com/commits/125715
X-Bug: 58628
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============1415079491=="

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

#At file:///home/oleja/mysql/mysql-5.1-telco-7.0-spj-scan-scan/ based on revid:ole.john.aske@stripped

 3382 Ole John Aske	2010-12-01
      Addendum patch for bug#58628: Update of result file due 
      to changed (improved) behaviour when constructing a REF 
      key from 'out of bound' values. 
      
      As the main fix will cause failing const key value ::copy() 
      to be reevaluate inside JOIN::exec(), we will detect out of bound
      values (which will form an illegal/undefined REF key) before 
      executing the access request. Previously these const REF keys 
      was produced by JOIN::optimize() and any conversion/range errors 
      was ignored. - Possibly causing undefined keys to be produced.
      
      These access request may then be ignored wo/ a Handler_read_key request
      being executed.

    modified:
      mysql-test/r/update.result
=== modified file 'mysql-test/r/update.result'
--- a/mysql-test/r/update.result	2010-07-19 09:03:52 +0000
+++ b/mysql-test/r/update.result	2010-12-01 21:35:17 +0000
@@ -404,7 +404,7 @@ user_id
 show status like '%Handler_read%';
 Variable_name	Value
 Handler_read_first	0
-Handler_read_key	1
+Handler_read_key	0
 Handler_read_next	0
 Handler_read_prev	0
 Handler_read_rnd	0
@@ -414,7 +414,7 @@ user_id
 show status like '%Handler_read%';
 Variable_name	Value
 Handler_read_first	0
-Handler_read_key	2
+Handler_read_key	0
 Handler_read_next	0
 Handler_read_prev	0
 Handler_read_rnd	0
@@ -423,7 +423,7 @@ UPDATE t1 SET user_id=null WHERE request
 show status like '%Handler_read%';
 Variable_name	Value
 Handler_read_first	0
-Handler_read_key	3
+Handler_read_key	1
 Handler_read_next	0
 Handler_read_prev	0
 Handler_read_rnd	0
@@ -432,7 +432,7 @@ UPDATE t1 SET user_id=null WHERE request
 show status like '%Handler_read%';
 Variable_name	Value
 Handler_read_first	0
-Handler_read_key	3
+Handler_read_key	1
 Handler_read_next	0
 Handler_read_prev	0
 Handler_read_rnd	0


--===============1415079491==
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\
#   2ls122fz6roancu1
# target_branch: file:///home/oleja/mysql/mysql-5.1-telco-7.0-spj-\
#   scan-scan/
# testament_sha1: 9888188b3344c47395299f84f72dec843f1cd2f6
# timestamp: 2010-12-01 22:35:22 +0100
# source_branch: bzr+ssh://oaske@stripped/bzrroot/server\
#   /mysql-5.1-telco-7.0-spj/
# base_revision_id: ole.john.aske@stripped\
#   vc14367mtq6m55v0
# 
# Begin bundle
IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWXn0XL4AAd/fgAAwWOf/93Nx
1gC////wUATrN7d3O4uPbdae91s9vXCShAGhNTyPRTYpowpptT1DIAZBoNNIBMmRqp7JqJo9QDIy
YmTEAGCUCEKbEE0an6j0p6GKeoeo0Bo009JoCRSp6egppspgRpkeoGTR6QAwmgAkiIn6phMptGhD
QnqMBGQ0YmEeof4HU3dZYaj762jLmlMLXId6MSHyYOfjONxljkafBhl1+2q/sfeGTIb+zQgkD8eA
TRsdSuhGZJ3OVjGrYS7VwXZfGa3u7fCo09FMmI54HKXllnXZXEoIW1ZeMvKhLrnY9WI7vioy2vlq
kVsXyC54FZt/Cv+15rd2u/s9ezdxGUTVPwtqncpvAjkblG8gI7hass/YZy06/OKvXrzKljPkymLG
HqEakil3QrsJWze3g7ClBL5PoLCfTJCdAwnGwwNzGoj2XOlIgcGT0Fhmri09C0yKiMXLtsEHN2Pu
Nd/PBGNqxAB5wmSX6ko7I7ohNUtqh/uN6CQumSbDIVmMNHQvNVq1NLiGERCeuevoCaguc0WNI0F/
DZMgmrjB9mDhw6jdDm8yivEyvuo7rSDMMWCoMc5NVYZ4y66aCZxKvBi+Q7E6xyQcUQEiisyC5BsK
UG5mRKoFMZm9HHS2a6PpJLOMYdUspJUv6DUUzweJtErsYlZWVIAGq8SeITjFqAkJZNFg3DBqqm06
I/eOaMxgyg2GsGufSOJnOMwpbCQ9d57qBQ6ghRujLY1/Iuyxy4KZ4GQgoyIDntQxLxMCMj2inywr
4aEff9dkQIZbLHGUU/LeaMjhHIVP2cip0JLbfRShgN5I8PFxKXuCQ6G/KHFxMdHpGM4mFTg7sPn7
viF9z6p/ITvREUV8XS1HqcxFg6GIOm9tI13Ogk4vRne00YOSw65O/PFdlp2U5lA8sL1eP225Mllb
4tSLMaRwRB37c4oDY2DdbWGm76khiiX6rJaFVNvreYmEIYh6vORKZ1Uz8SsvmhMp3JSO3nNVNXR2
K21m78o2NOHKNCIkzH33728Hk3KwRRjxGPlDcXot8pmEez4AvqxX5jLq9/0GPK5JykOMcWZcY3id
v0oluGExdCEXCOpGWWc3bEbqTAziVDagqraiD+Mq0ETdq2G8qeb7FOwzF5HK5nF2UMXhUzK7QIyG
iTaLkGjmOcvCAM0n2D2cP62YuO8jgkbYzWKUo6q42293qtJHTdZgbbQwtUU5Kv06PQJS2SW1tU0+
cJo0Xi0pY6ns+1e0RRkbYSNQWteDBl49hFqnp0hUE9ckeFpCRtEORijsoJKGqXXziYWpohaMWem3
XPARmTwSJz4aDG5xA/ejdr93SNOiwIMhW6JkVZAoyE3Gk3iqDk1RgJIqVEGmoRyx6Fx9N1BcXpcE
cK1Fg4dcs4K7IwdkgmUvbvSMwPuGCnomv7o5Cwz7428qnczJv9ikiydsTKTedq6jQOmv5c28XWlW
uz2wBCInP1tCCmWiCh7k6c/CCwqqDcJpzrhJtS0oos1SPCLjOfaI4BJyfhyh6aZsIq/g7gLEOrYI
KJtD3bHG4snmNQQMgdwe+xsGKzdJZJ0O/gNITxk6Sy/LrGYIt05jG6mXEsDUq+1NdQ1YTi3FkFIx
v1Yc1uuzeEt5t6tuBJNSwyuO5cMYtC15NIaKoRBB9WDAxaukRhKrGZVNrVgYY6TSJOxI2nEs/4u5
IpwoSDz6Ll8A


--===============1415079491==--