From: Ole John Aske
Date: December 21 2010 12:37pm
Subject: bzr commit into mysql-5.1-telco-7.0-spj-scan-vs-scan branch
 (ole.john.aske:3399)
List-Archive: http://lists.mysql.com/commits/127411
Message-Id: <20101221123729.96877223@fimafeng09.norway.sun.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============6441773609625116474=="

--===============6441773609625116474==
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

 3399 Ole John Aske	2010-12-21
      SPJ-scan-scan: Updated resultfile for ndb_condition_pushdown.test required after 
      pushed fix for bug 57030: 'BETWEEN evaluation is incorrect':
      
      With improved handling of BETWEEN condition, The equal hi/low limits 
      in the condition :
      
      'WHERE 1901-01-01 01:01:01' BETWEEN date_time and date_time'
      
      is now detected by the optimizer, and handled as:
      
      'WHERE 1901-01-01 01:01:01' = date_time'
      
      Which in turn cause the access type to change from 'index' to 'ref'.

    modified:
      mysql-test/suite/ndb/r/ndb_condition_pushdown.result
=== modified file 'mysql-test/suite/ndb/r/ndb_condition_pushdown.result'
--- a/mysql-test/suite/ndb/r/ndb_condition_pushdown.result	2010-12-08 07:58:31 +0000
+++ b/mysql-test/suite/ndb/r/ndb_condition_pushdown.result	2010-12-21 12:37:25 +0000
@@ -1307,7 +1307,7 @@ select auto from t1 where
 ('1901-01-01 01:01:01' between date_time and date_time) 
 order by auto;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	t1	index	medium_index	PRIMARY	4	NULL	#	Using where with pushed condition
+1	SIMPLE	t1	ref	medium_index	medium_index	3	const	#	Using where with pushed condition; Using filesort
 select auto from t1 where
 ("aaaa" between string and string) and 
 ("aaaa" between vstring and vstring) and 


--===============6441773609625116474==
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\
#   e8sr4lkmeoicint0
# target_branch: file:///net/fimafeng09/export/home/tmp/oleja/mysql\
#   /mysql-5.1-telco-7.0-spj-scan-scan/
# testament_sha1: de67c52fd43e08526da323a4fc01cb25fc2d1db6
# timestamp: 2010-12-21 13:37:29 +0100
# source_branch: bzr+ssh://oaske@stripped/bzrroot/server\
#   /mysql-5.1-telco-7.0-spj/
# base_revision_id: ole.john.aske@stripped\
#   uggochx2uza194eu
# 
# Begin bundle
IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWYHzT4YAAbrfgAAwWOf//3J3
3oC////wUASMvHVTd7z3hidtKhKEQ0EyZNJjRpqeg0poNMjQA00DQaISeCeppoKepkyGgABoANAa
aCASp5okaPKZPKfqIPUDEyYAHpR+pqGgZKGKAAAPU0GgBoAAAAEkhNT0CYmgTaFMjwUzTSMgAADy
/tUlbvB+NxQuzfMv48tRFJrzk6NbU8Q2X3u03xOHP/VNnj1dFOyciIIKFY9jEIaAM5nkcT6DcaeH
T6I8lOco5mZ1LCf6qlbWpIcjULOJle55XW1tNRYqWoAMbL1okkiVSycqAo0IyodkDaW3S48BU6V0
wC44CGxu0SObIszF03w/cDDPMys41j4pGZI1skOMvB1EI3EUUsw48HJ78ncRd4HEY5EwKSRAkZro
Kcucap53z9Z3A9MSHY9jVhAYYUbWN1SgIonTjHsNeixA581gyB+IUlr59iRU3d/2RjUlsgeZTw0k
AkFQD9QVYsYxdjyAEoT1IGGZBpZKnITCauM0rHBoO5rKdbjc8Y3o4PR6KUMh8IoguldV7qwVgbEs
CoDhMINpIMDytcIBwlpIkibbtjQbMQ8ouVFQtpULVRaxjNoRuMk2FKYjRlDYVvqgJ0tJxCJiUHSZ
bNBiBTMHbwCUX1VFfK4xlpUiLKeYUMjQUBTap6G92AI3BgxReFlVB18RzazXlmymBp7WSx9N2tY4
mLFQkciyLEQCSCy8yg5y1kVou10sEQjIGkREYTZ3wDm/BUawcKBZZIUIh82cUDGpiwu+jLEwXwKV
SbQCEOgPW4VlRcP4oj5SCVoykjGIkM1Mwcunuts5qMi0e1FaIeKRebwauXXaZjN2lTp0cSE5srOo
OdPUDT6QjVk5zFLXdWlpP9qeKdmSOmhIm0tYGeFYIzMydfdYxmgJ2OJpTCp0EhXMIaMBnkEbGndA
ZEqN4xHgd6mbZ77nwUY+baqOMZGiIX14Suf4CaekMyIarVyaEwODPsOHKuJZGjOkjloLOXPQu2c3
M7PStXixmgUoqZhN7P09atZt239XVPILMTcEocDkiSKneus3sxq6UnAmzXjzT+qeVaeZewdi5N1v
ByDJPwTOTa2bUNgFI5wQObVPPpNHywBeaCyJ05hte0RX8uabFlMDMh6OxrCtjkE50hfia4X61540
qIzDBjqhsB+fRcluGMlD7NUxxOR2pEi+pqAWYO8pE87PP5geD2Q/3IlRDBEG7VrXW0+QmzP9Fqpa
OdEOmJM6I5JxKUh3EBMXpessbx21oOiymZwpIPRDAc5US1olFAYOTzXislZRwBxarLVtYCgCIUMh
+AURYplUfraKKBZQ1l4zt8qAWMEyXgzymw+v8SLgeo38ILLLb6sWORhKlNiql3nEV0YkKuMskeAT
8+JKbhb2kMXOgymFMAdH59e/voRX2tbY4nrqV2rDZNmI8WkwRtL8lsH6gxV2p9TxaigH/6hI4FK2
+VXDg1fWZ/EURzK4MqnDtFuduXOVEwibyIxep6TSNVu04UbxSUZJN1VaVm+SLCxFoXA+Tk6BDnTu
ML16L1Ajife4oGvx2CkvKnRnS5wZPSwUcUKxxRktsUsqlJ+Kd9dCTO/4u5IpwoSED5p8MA==


--===============6441773609625116474==--