List:Commits« Previous MessageNext Message »
From:Ole John Aske Date:December 21 2010 12:37pm
Subject:bzr push into mysql-5.1-telco-7.0-spj-scan-vs-scan branch
(ole.john.aske:3398 to 3399)
View as plain text  
 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
 3398 Ole John Aske	2010-12-21
      SPJ-scan-scan: Updated cherry picked fix for bug 57030: 'BETWEEN evaluation is incorrect' 
      after reviewers had some suggestions for improvements / rewrite

    modified:
      mysql-test/r/range.result
      mysql-test/t/range.test
      sql/sql_select.cc
=== 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 

No bundle (reason: useless for push emails).
Thread
bzr push into mysql-5.1-telco-7.0-spj-scan-vs-scan branch(ole.john.aske:3398 to 3399) Ole John Aske21 Dec