From: Ole John Aske
Date: December 9 2010 8:04am
Subject: bzr commit into mysql-5.1-telco-7.0-spj-scan-vs-scan branch
 (ole.john.aske:3396)
List-Archive: http://lists.mysql.com/commits/126389
Message-Id: <20101209080459.C0046223@fimafeng09.norway.sun.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============6745572990673685071=="

--===============6745572990673685071==
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-spj-scan-scan/ based on revid:ole.john.aske@stripped

 3396 Ole John Aske	2010-12-09
      PJS-scan-scan : Updated resultfile as explain output changed slightly after fix for #58818 
      may add an extra 'IS TRUE' to the having predicate.

    modified:
      mysql-test/r/subselect3.result
=== modified file 'mysql-test/r/subselect3.result'
--- a/mysql-test/r/subselect3.result	2010-03-09 10:36:26 +0000
+++ b/mysql-test/r/subselect3.result	2010-12-09 08:04:55 +0000
@@ -209,7 +209,7 @@ id	select_type	table	type	possible_keys	
 2	DEPENDENT SUBQUERY	t1	ALL	NULL	NULL	NULL	NULL	2	100.00	Using temporary; Using filesort
 Warnings:
 Note	1276	Field or reference 't2.oref' of SELECT #2 was resolved in SELECT #1
-Note	1003	select `test`.`t2`.`a` AS `a`,`test`.`t2`.`oref` AS `oref`,<in_optimizer>(`test`.`t2`.`a`,<exists>(select count(0) from `test`.`t1` group by `test`.`t1`.`grp` having ((`test`.`t1`.`grp` = `test`.`t2`.`oref`) and trigcond((<cache>(`test`.`t2`.`a`) = <ref_null_helper>(count(0))))))) AS `Z` from `test`.`t2`
+Note	1003	select `test`.`t2`.`a` AS `a`,`test`.`t2`.`oref` AS `oref`,<in_optimizer>(`test`.`t2`.`a`,<exists>(select count(0) from `test`.`t1` group by `test`.`t1`.`grp` having (((`test`.`t1`.`grp` = `test`.`t2`.`oref`) is true) and trigcond((<cache>(`test`.`t2`.`a`) = <ref_null_helper>(count(0))))))) AS `Z` from `test`.`t2`
 drop table t1, t2;
 create table t1 (a int, b int, primary key (a));
 insert into t1 values (1,1), (3,1),(100,1);


--===============6745572990673685071==
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\
#   6qz202jae6vwthzi
# target_branch: file:///net/fimafeng09/export/home/tmp/oleja/mysql\
#   /mysql-5.1-telco-7.0-spj-scan-scan/
# testament_sha1: 963ec054249bfec3a2cd57e7a91b9861a6791951
# timestamp: 2010-12-09 09:04:59 +0100
# source_branch: bzr+ssh://oaske@stripped/bzrroot/server\
#   /mysql-5.1-telco-7.0-spj/
# base_revision_id: ole.john.aske@stripped\
#   6eun5m33b207mivj
# 
# Begin bundle
IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWXSt14kAAbBfgAgwWOf/93Ix
3hD////wUARG3o0XU3d1Zly2wlCU2jRKfqempqe9JT9JoG1PUjI/VHpP0oek8jUyCSgQyTaBNAjF
PU2moG1DTQBo9QaCUJqZJPymI0mmnpT9Kep6ntCgAZAAaBzTEwEaYEYRgAAACYRgJKTaiYnpNEYN
CNqYj0mg0ABoBpNhmjaeH844j9UTTQrUgUWs5sjqtU3D74w+PlrUVfPMleR4s6nUM+OzPHSpJJhs
VPP2Wmdx+qJuDz0oyR9uM8OZH0OjDM2yphVPJlDP12mGzBtQyiY+1TNzrFMkddM9WrOzjMqjWI6P
XMWOmjtt/T93RvXLoccxu5Ngy8A2RSM6EbFjfBo2FbqJltZiwvjhEQi7I8VwY+nZRPGXSJi8xQ0V
8u4IrWRYxsbE1inx50CPXIq3ks85jnuKkFTLqsvlzTW90bDFZLFZy0dnnY7ayjSy3gqZyMmlB3gv
IWxOQWq+8ztvhqvMHBcK0p4XpYwTV1c+S1vrztTRbcqf7jZujIvV0qGNVUTPMSSS21lZAYrhX4FI
nmydK3boSeJorN8Fslj4bcrzvbDyHehWb8q6jSRTc99lhdcohkgeKlsMR/acH1KkoMSa3GozQxMG
0IMDHiUQpeTa6LLGT3wrLmMzMdk8WZkZkqteiwgWDa1vLap1JSbRa6ixwYkoSgixWorCVa8u/vVa
Bx7Z6s6O2bm7TytcIQnBqFRTbydj6Pf0HLhwTi/kuPZoqpQuhC/5Mbu7pLwxd3VVqRxSKBn9yKoK
qAu9UU3tjQO8rDFu4XmeIXlMM92Ind4ng+ycPlAxtjVMpKzZ9NaFkiiF4+pqqHQNsn2yPrTbD4WK
aLvdKrws6sBcLBsIvn1GH7kHW6tT1vtvGsEbepIn0o7ZozAxSOGhaLuRcKi7KpE6Z6aum1Pha6Nk
dMxVPuy+GJaKohDOSNVGW6Fj4mRASrlxpnENPaWNZQI3m0dDZKNvKO/Zeu2UQaymRdfFjL0oZnQN
yKkkuhl57YNli8QWYNybxguuiix1ni4G7pu1BAYWw6p5UcXhgyZOxXBx5j3KD75JfE7CIK4paj3v
RDo67yUTWc6KSK40V9K178qLLK8lGtWVBIr2GrWFM5sa+2EJya0HXWF4jkuNpzdAplsEZjgJkjEG
eXIDBCp4RQi31lsRnERDIlhg5jqlJtft4EwS5K2xTqnhYdm9GlVUnjeHRWqYgIWwVFHxnEdwZmRp
RKIOqbGTfp065/D0iFyfY9greWJaBWwdoeUQ/hFAa09VvW/DOTYsGStMNec5boSFhwri6dcpNoni
eG6R7xUbd+lqIvEvCexypR6Vdd2NJFddSqbkPr5qmmhipwcXU9gU9OeCugwskDPtmEZl3X8dTp/s
pBQCEcYwao+eGnjc+vsHDuZAykkbHoHCNpti62Y66UQOsYXuElm56DdxlaFyaLngr1wTsgmD5VYQ
RqU022bHaS8yIr1URGDAmsDkJ+JqFBaJa4sHIrljvqw2iaZUCkJaf8XckU4UJB0rdeJA


--===============6745572990673685071==--