bk commit into 5.1 tree (mskold:1.2433)

[Martin Skold]

Below is the list of changes that have just been committed into a local
5.1 repository of marty. When marty does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html

ChangeSet@stripped, 2007-02-09 21:04:43+01:00, mskold@stripped +3 -0
  Enabled engine_condition_pushdown (on) as default

  mysql-test/r/ndb_basic.result@stripped, 2007-02-09 21:04:11+01:00, mskold@stripped +1 -1
    Enabled engine_condition_pushdown (on) as default

  mysql-test/r/ndb_blob.result@stripped, 2007-02-09 21:04:11+01:00, mskold@stripped +2 -2
    Enabled engine_condition_pushdown (on) as default

  sql/mysqld.cc@stripped, 2007-02-09 21:04:11+01:00, mskold@stripped +1 -1
    Enabled engine_condition_pushdown (on) as default

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	mskold
# Host:	linux.site
# Root:	/windows/Linux_space/MySQL/mysql-5.1-new-ndb

--- 1.614/sql/mysqld.cc	2007-02-09 21:04:54 +01:00
+++ 1.615/sql/mysqld.cc	2007-02-09 21:04:54 +01:00
@@ -5077,7 +5077,7 @@ struct my_option my_long_options[] =
    "Push supported query conditions to the storage engine.",
    (gptr*) &global_system_variables.engine_condition_pushdown,
    (gptr*) &global_system_variables.engine_condition_pushdown,
-   0, GET_BOOL, NO_ARG, 0, 0, 0, 0, 0, 0},
+   0, GET_BOOL, NO_ARG, 1, 0, 0, 0, 0, 0},
   /* See how it's handled in get_one_option() */
   {"event-scheduler", OPT_EVENT_SCHEDULER, "Enable/disable the event scheduler.",
    NULL,  NULL, 0, GET_STR, OPT_ARG, 0, 0, 0, 0, 0, 0},

--- 1.51/mysql-test/r/ndb_basic.result	2007-02-09 21:04:54 +01:00
+++ 1.52/mysql-test/r/ndb_basic.result	2007-02-09 21:04:54 +01:00
@@ -568,7 +568,7 @@ t1
 insert into t1 values (1,1),(2,1),(3,1),(4,1),(5,2),(6,1),(7,1);
 explain select * from t1 where a12345678901234567890123456789a1234567890=2;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	t1	ref	a12345678901234567890123456789a1234567890	a12345678901234567890123456789a1234567890	5	const	#	Using where
+1	SIMPLE	t1	ref	a12345678901234567890123456789a1234567890	a12345678901234567890123456789a1234567890	5	const	#	Using where with pushed condition
 select * from t1 where a12345678901234567890123456789a1234567890=2;
 a1234567890123456789012345678901234567890	a12345678901234567890123456789a1234567890
 5	2

--- 1.20/mysql-test/r/ndb_blob.result	2007-02-09 21:04:54 +01:00
+++ 1.21/mysql-test/r/ndb_blob.result	2007-02-09 21:04:54 +01:00
@@ -242,7 +242,7 @@ insert into t1 values(9,'b9',999,'dd9');
 commit;
 explain select * from t1 where c >= 100 order by a;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	t1	range	c	c	4	NULL	#	Using where; Using filesort
+1	SIMPLE	t1	range	c	c	4	NULL	#	Using where with pushed condition; Using filesort
 select * from t1 where c >= 100 order by a;
 a	b	c	d
 1	b1	111	dd1
@@ -278,7 +278,7 @@ insert into t1 values(2,@b2,222,@d2);
 commit;
 explain select * from t1 where c >= 100 order by a;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	t1	range	c	c	4	NULL	#	Using where; Using filesort
+1	SIMPLE	t1	range	c	c	4	NULL	#	Using where with pushed condition; Using filesort
 select a,length(b),substr(b,1+2*900,2),length(d),substr(d,1+3*900,3)
 from t1 where c >= 100 order by a;
 a	length(b)	substr(b,1+2*900,2)	length(d)	substr(d,1+3*900,3)