List:Commits« Previous MessageNext Message »
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)
View as plain text  
#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 


Attachment: [text/bzr-bundle] bzr/ole.john.aske@oracle.com-20101221123725-e8sr4lkmeoicint0.bundle
Thread
bzr commit into mysql-5.1-telco-7.0-spj-scan-vs-scan branch(ole.john.aske:3399) Ole John Aske21 Dec