List:Commits« Previous MessageNext Message »
From:Jonas Oreland Date:December 15 2009 7:56am
Subject:bzr commit into mysql-5.1-telco-7.0-spj branch (jonas:3021)
View as plain text  
#At file:///home/jonas/src/70-spj/ based on revid:ole.john.aske@stripped

 3021 Jonas Oreland	2009-12-15
      ndb spj - save fenster, use lowercase tablenames, remove sloppy usage of "drop table if exists"

    modified:
      mysql-test/suite/ndb/r/ndb_join_pushdown.result
      mysql-test/suite/ndb/t/ndb_join_pushdown.test
=== modified file 'mysql-test/suite/ndb/r/ndb_join_pushdown.result'
--- a/mysql-test/suite/ndb/r/ndb_join_pushdown.result	2009-12-14 08:16:16 +0000
+++ b/mysql-test/suite/ndb/r/ndb_join_pushdown.result	2009-12-15 07:56:10 +0000
@@ -1130,356 +1130,353 @@ and t2.a = 3;
 a	b	c	a	b
 3	3	kalle	3	3
 drop table t1, t2;
-drop table if exists T3;
-Warnings:
-Note	1051	Unknown table 'T3'
-create table T3 (a3 int, b3 tinyint, c3 int not null, d3 int not null, 
-primary key(a3,b3)) engine = ndb;
-insert into T3 values (0x1f, 0x2f, 1, 0x1f);
-insert into T3 values (0x2f, 0x3f, 2, 0x2f);
-insert into T3 values (0x3f, 0x1f, 3, 0x3f);
+create table t3 (a3 int, b3 tinyint, c3 int not null, d3 int not null, 
+primary key(a3,b3)) engine = ndb;
+insert into t3 values (0x1f, 0x2f, 1, 0x1f);
+insert into t3 values (0x2f, 0x3f, 2, 0x2f);
+insert into t3 values (0x3f, 0x1f, 3, 0x3f);
 explain
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3="63";
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3="63";
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	x	ref	PRIMARY	PRIMARY	4	const	10	Pushed 2 joins
 1	SIMPLE	y	eq_ref	PRIMARY	PRIMARY	5	test.x.d3,const	1	
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3="63";
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3="63";
 a3	b3	c3	d3	a3	b3	c3	d3
 47	63	2	47	47	63	2	47
-drop table if exists T3;
-create table T3 (a3 int, b3 tinyint unsigned, c3 int not null, d3 int not null, 
+drop table t3;
+create table t3 (a3 int, b3 tinyint unsigned, c3 int not null, d3 int not null, 
 primary key(a3,b3)) engine = ndb;
-insert into T3 values (0x1f, 0x2f, 1, 0x1f);
-insert into T3 values (0x2f, 0x3f, 2, 0x2f);
-insert into T3 values (0x3f, 0x1f, 3, 0x3f);
+insert into t3 values (0x1f, 0x2f, 1, 0x1f);
+insert into t3 values (0x2f, 0x3f, 2, 0x2f);
+insert into t3 values (0x3f, 0x1f, 3, 0x3f);
 explain
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	x	ref	PRIMARY	PRIMARY	4	const	10	Pushed 2 joins
 1	SIMPLE	y	eq_ref	PRIMARY	PRIMARY	5	test.x.d3,const	1	
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
 a3	b3	c3	d3	a3	b3	c3	d3
 47	63	2	47	47	63	2	47
-drop table if exists T3;
-create table T3 (a3 int, b3 smallint, c3 int not null, d3 int not null, 
+drop table t3;
+create table t3 (a3 int, b3 smallint, c3 int not null, d3 int not null, 
 primary key(a3,b3)) engine = ndb;
-insert into T3 values (0x1f, 0x2f, 1, 0x1f);
-insert into T3 values (0x2f, 0x3f, 2, 0x2f);
-insert into T3 values (0x3f, 0x1f, 3, 0x3f);
+insert into t3 values (0x1f, 0x2f, 1, 0x1f);
+insert into t3 values (0x2f, 0x3f, 2, 0x2f);
+insert into t3 values (0x3f, 0x1f, 3, 0x3f);
 explain
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	x	ref	PRIMARY	PRIMARY	4	const	10	Pushed 2 joins
 1	SIMPLE	y	eq_ref	PRIMARY	PRIMARY	6	test.x.d3,const	1	
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
 a3	b3	c3	d3	a3	b3	c3	d3
 47	63	2	47	47	63	2	47
-drop table if exists T3;
-create table T3 (a3 int, b3 smallint unsigned, c3 int not null, d3 int not null, 
+drop table t3;
+create table t3 (a3 int, b3 smallint unsigned, c3 int not null, d3 int not null, 
 primary key(a3,b3)) engine = ndb;
-insert into T3 values (0x1f, 0x2f, 1, 0x1f);
-insert into T3 values (0x2f, 0x3f, 2, 0x2f);
-insert into T3 values (0x3f, 0x1f, 3, 0x3f);
+insert into t3 values (0x1f, 0x2f, 1, 0x1f);
+insert into t3 values (0x2f, 0x3f, 2, 0x2f);
+insert into t3 values (0x3f, 0x1f, 3, 0x3f);
 explain
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	x	ref	PRIMARY	PRIMARY	4	const	10	Pushed 2 joins
 1	SIMPLE	y	eq_ref	PRIMARY	PRIMARY	6	test.x.d3,const	1	
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
 a3	b3	c3	d3	a3	b3	c3	d3
 47	63	2	47	47	63	2	47
-drop table if exists T3;
-create table T3 (a3 int, b3 mediumint, c3 int not null, d3 int not null, 
+drop table t3;
+create table t3 (a3 int, b3 mediumint, c3 int not null, d3 int not null, 
 primary key(a3,b3)) engine = ndb;
-insert into T3 values (0x1f, 0x2f, 1, 0x1f);
-insert into T3 values (0x2f, 0x3f, 2, 0x2f);
-insert into T3 values (0x3f, 0x1f, 3, 0x3f);
+insert into t3 values (0x1f, 0x2f, 1, 0x1f);
+insert into t3 values (0x2f, 0x3f, 2, 0x2f);
+insert into t3 values (0x3f, 0x1f, 3, 0x3f);
 explain
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	x	ref	PRIMARY	PRIMARY	4	const	10	Pushed 2 joins
 1	SIMPLE	y	eq_ref	PRIMARY	PRIMARY	7	test.x.d3,const	1	
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
 a3	b3	c3	d3	a3	b3	c3	d3
 47	63	2	47	47	63	2	47
-drop table if exists T3;
-create table T3 (a3 int, b3 mediumint unsigned, c3 int not null, d3 int not null, 
+drop table t3;
+create table t3 (a3 int, b3 mediumint unsigned, c3 int not null, d3 int not null, 
 primary key(a3,b3)) engine = ndb;
-insert into T3 values (0x1f, 0x2f, 1, 0x1f);
-insert into T3 values (0x2f, 0x3f, 2, 0x2f);
-insert into T3 values (0x3f, 0x1f, 3, 0x3f);
+insert into t3 values (0x1f, 0x2f, 1, 0x1f);
+insert into t3 values (0x2f, 0x3f, 2, 0x2f);
+insert into t3 values (0x3f, 0x1f, 3, 0x3f);
 explain
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	x	ref	PRIMARY	PRIMARY	4	const	10	Pushed 2 joins
 1	SIMPLE	y	eq_ref	PRIMARY	PRIMARY	7	test.x.d3,const	1	
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
 a3	b3	c3	d3	a3	b3	c3	d3
 47	63	2	47	47	63	2	47
-drop table if exists T3;
-create table T3 (a3 int, b3 int, c3 int not null, d3 int not null, 
+drop table t3;
+create table t3 (a3 int, b3 int, c3 int not null, d3 int not null, 
 primary key(a3,b3)) engine = ndb;
-insert into T3 values (0x1f, 0x2f, 1, 0x1f);
-insert into T3 values (0x2f, 0x3f, 2, 0x2f);
-insert into T3 values (0x3f, 0x1f, 3, 0x3f);
+insert into t3 values (0x1f, 0x2f, 1, 0x1f);
+insert into t3 values (0x2f, 0x3f, 2, 0x2f);
+insert into t3 values (0x3f, 0x1f, 3, 0x3f);
 explain
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	x	ref	PRIMARY	PRIMARY	4	const	10	Pushed 2 joins
 1	SIMPLE	y	eq_ref	PRIMARY	PRIMARY	8	test.x.d3,const	1	
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
 a3	b3	c3	d3	a3	b3	c3	d3
 47	63	2	47	47	63	2	47
-drop table if exists T3;
-create table T3 (a3 int, b3 int unsigned, c3 int not null, d3 int not null, 
+drop table t3;
+create table t3 (a3 int, b3 int unsigned, c3 int not null, d3 int not null, 
 primary key(a3,b3)) engine = ndb;
-insert into T3 values (0x1f, 0x2f, 1, 0x1f);
-insert into T3 values (0x2f, 0x3f, 2, 0x2f);
-insert into T3 values (0x3f, 0x1f, 3, 0x3f);
+insert into t3 values (0x1f, 0x2f, 1, 0x1f);
+insert into t3 values (0x2f, 0x3f, 2, 0x2f);
+insert into t3 values (0x3f, 0x1f, 3, 0x3f);
 explain
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	x	ref	PRIMARY	PRIMARY	4	const	10	Pushed 2 joins
 1	SIMPLE	y	eq_ref	PRIMARY	PRIMARY	8	test.x.d3,const	1	
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
 a3	b3	c3	d3	a3	b3	c3	d3
 47	63	2	47	47	63	2	47
-drop table if exists T3;
-create table T3 (a3 int, b3 bigint, c3 int not null, d3 int not null, 
+drop table t3;
+create table t3 (a3 int, b3 bigint, c3 int not null, d3 int not null, 
 primary key(a3,b3)) engine = ndb;
-insert into T3 values (0x1f, 0x2f, 1, 0x1f);
-insert into T3 values (0x2f, 0x3f, 2, 0x2f);
-insert into T3 values (0x3f, 0x1f, 3, 0x3f);
+insert into t3 values (0x1f, 0x2f, 1, 0x1f);
+insert into t3 values (0x2f, 0x3f, 2, 0x2f);
+insert into t3 values (0x3f, 0x1f, 3, 0x3f);
 explain
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	x	ref	PRIMARY	PRIMARY	4	const	10	Pushed 2 joins
 1	SIMPLE	y	eq_ref	PRIMARY	PRIMARY	12	test.x.d3,const	1	
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
 a3	b3	c3	d3	a3	b3	c3	d3
 47	63	2	47	47	63	2	47
-drop table if exists T3;
-create table T3 (a3 int, b3 bigint unsigned, c3 int not null, d3 int not null, 
+drop table t3;
+create table t3 (a3 int, b3 bigint unsigned, c3 int not null, d3 int not null, 
 primary key(a3,b3)) engine = ndb;
-insert into T3 values (0x1f, 0x2f, 1, 0x1f);
-insert into T3 values (0x2f, 0x3f, 2, 0x2f);
-insert into T3 values (0x3f, 0x1f, 3, 0x3f);
+insert into t3 values (0x1f, 0x2f, 1, 0x1f);
+insert into t3 values (0x2f, 0x3f, 2, 0x2f);
+insert into t3 values (0x3f, 0x1f, 3, 0x3f);
 explain
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	x	ref	PRIMARY	PRIMARY	4	const	10	Pushed 2 joins
 1	SIMPLE	y	eq_ref	PRIMARY	PRIMARY	12	test.x.d3,const	1	
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
 a3	b3	c3	d3	a3	b3	c3	d3
 47	63	2	47	47	63	2	47
-drop table if exists T3;
-create table T3 (a3 int, b3 boolean, c3 int not null, d3 int not null, 
+drop table t3;
+create table t3 (a3 int, b3 boolean, c3 int not null, d3 int not null, 
 primary key(a3,b3)) engine = ndb;
-insert into T3 values (0x1f, 0, 1, 0x1f);
-insert into T3 values (0x2f, 1, 2, 0x2f);
-insert into T3 values (0x3f, 0, 3, 0x3f);
+insert into t3 values (0x1f, 0, 1, 0x1f);
+insert into t3 values (0x2f, 1, 2, 0x2f);
+insert into t3 values (0x3f, 0, 3, 0x3f);
 explain
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=1;
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=1;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	x	ref	PRIMARY	PRIMARY	4	const	10	Pushed 2 joins
 1	SIMPLE	y	eq_ref	PRIMARY	PRIMARY	5	test.x.d3,const	1	
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=1;
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=1;
 a3	b3	c3	d3	a3	b3	c3	d3
 47	1	2	47	47	1	2	47
-drop table if exists T3;
-create table T3 (a3 int, b3 float, c3 int not null, d3 int not null, 
+drop table t3;
+create table t3 (a3 int, b3 float, c3 int not null, d3 int not null, 
 primary key(a3,b3)) engine = ndb;
-insert into T3 values (0x1f, 2.71, 1, 0x1f);
-insert into T3 values (0x2f, 3.00, 2, 0x2f);
-insert into T3 values (0x3f, 0.50, 3, 0x3f);
+insert into t3 values (0x1f, 2.71, 1, 0x1f);
+insert into t3 values (0x2f, 3.00, 2, 0x2f);
+insert into t3 values (0x3f, 0.50, 3, 0x3f);
 explain
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.0;
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.0;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	x	ref	PRIMARY	PRIMARY	4	const	10	Pushed 2 joins
 1	SIMPLE	y	eq_ref	PRIMARY	PRIMARY	8	test.x.d3,const	1	Using where with pushed condition
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.0;
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.0;
 a3	b3	c3	d3	a3	b3	c3	d3
 47	3	2	47	47	3	2	47
-drop table if exists T3;
-create table T3 (a3 int, b3 float unsigned, c3 int not null, d3 int not null, 
+drop table t3;
+create table t3 (a3 int, b3 float unsigned, c3 int not null, d3 int not null, 
 primary key(a3,b3)) engine = ndb;
-insert into T3 values (0x1f, 2.71, 1, 0x1f);
-insert into T3 values (0x2f, 3.00, 2, 0x2f);
-insert into T3 values (0x3f, 0.50, 3, 0x3f);
+insert into t3 values (0x1f, 2.71, 1, 0x1f);
+insert into t3 values (0x2f, 3.00, 2, 0x2f);
+insert into t3 values (0x3f, 0.50, 3, 0x3f);
 explain
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.0;
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.0;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	x	ref	PRIMARY	PRIMARY	4	const	10	Pushed 2 joins
 1	SIMPLE	y	eq_ref	PRIMARY	PRIMARY	8	test.x.d3,const	1	Using where with pushed condition
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.0;
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.0;
 a3	b3	c3	d3	a3	b3	c3	d3
 47	3	2	47	47	3	2	47
-drop table if exists T3;
-create table T3 (a3 int, b3 double, c3 int not null, d3 int not null, 
+drop table t3;
+create table t3 (a3 int, b3 double, c3 int not null, d3 int not null, 
 primary key(a3,b3)) engine = ndb;
-insert into T3 values (0x1f, 2.71, 1, 0x1f);
-insert into T3 values (0x2f, 3.14, 2, 0x2f);
-insert into T3 values (0x3f, 0.50, 3, 0x3f);
+insert into t3 values (0x1f, 2.71, 1, 0x1f);
+insert into t3 values (0x2f, 3.14, 2, 0x2f);
+insert into t3 values (0x3f, 0.50, 3, 0x3f);
 explain
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.14;
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.14;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	x	ref	PRIMARY	PRIMARY	4	const	10	Pushed 2 joins
 1	SIMPLE	y	eq_ref	PRIMARY	PRIMARY	12	test.x.d3,const	1	
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.14;
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.14;
 a3	b3	c3	d3	a3	b3	c3	d3
 47	3.14	2	47	47	3.14	2	47
-drop table if exists T3;
-create table T3 (a3 int, b3 double unsigned, c3 int not null, d3 int not null, 
+drop table t3;
+create table t3 (a3 int, b3 double unsigned, c3 int not null, d3 int not null, 
 primary key(a3,b3)) engine = ndb;
-insert into T3 values (0x1f, 2.71, 1, 0x1f);
-insert into T3 values (0x2f, 3.14, 2, 0x2f);
-insert into T3 values (0x3f, 0.50, 3, 0x3f);
+insert into t3 values (0x1f, 2.71, 1, 0x1f);
+insert into t3 values (0x2f, 3.14, 2, 0x2f);
+insert into t3 values (0x3f, 0.50, 3, 0x3f);
 explain
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.14;
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.14;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	x	ref	PRIMARY	PRIMARY	4	const	10	Pushed 2 joins
 1	SIMPLE	y	eq_ref	PRIMARY	PRIMARY	12	test.x.d3,const	1	
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.14;
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.14;
 a3	b3	c3	d3	a3	b3	c3	d3
 47	3.14	2	47	47	3.14	2	47
-drop table if exists T3;
-create table T3 (a3 int, b3 decimal, c3 int not null, d3 int not null, 
+drop table t3;
+create table t3 (a3 int, b3 decimal, c3 int not null, d3 int not null, 
 primary key(a3,b3)) engine = ndb;
-insert into T3 values (0x1f, 0x2f, 1, 0x1f);
-insert into T3 values (0x2f, 0x3f, 2, 0x2f);
-insert into T3 values (0x3f, 0x1f, 3, 0x3f);
+insert into t3 values (0x1f, 0x2f, 1, 0x1f);
+insert into t3 values (0x2f, 0x3f, 2, 0x2f);
+insert into t3 values (0x3f, 0x1f, 3, 0x3f);
 explain
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=63;
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=63;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	x	ref	PRIMARY	PRIMARY	4	const	10	Pushed 2 joins
 1	SIMPLE	y	eq_ref	PRIMARY	PRIMARY	9	test.x.d3,const	1	
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=63;
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=63;
 a3	b3	c3	d3	a3	b3	c3	d3
 47	63	2	47	47	63	2	47
-drop table if exists T3;
-create table T3 (a3 int, b3 decimal(12,4), c3 int not null, d3 int not null, 
+drop table t3;
+create table t3 (a3 int, b3 decimal(12,4), c3 int not null, d3 int not null, 
 primary key(a3,b3)) engine = ndb;
-insert into T3 values (0x1f, 2.71, 1, 0x1f);
-insert into T3 values (0x2f, 3.14, 2, 0x2f);
-insert into T3 values (0x3f, 0.50, 3, 0x3f);
+insert into t3 values (0x1f, 2.71, 1, 0x1f);
+insert into t3 values (0x2f, 3.14, 2, 0x2f);
+insert into t3 values (0x3f, 0.50, 3, 0x3f);
 explain
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.14;
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.14;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	x	ref	PRIMARY	PRIMARY	4	const	10	Pushed 2 joins
 1	SIMPLE	y	eq_ref	PRIMARY	PRIMARY	10	test.x.d3,const	1	
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.14;
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.14;
 a3	b3	c3	d3	a3	b3	c3	d3
 47	3.1400	2	47	47	3.1400	2	47
-drop table if exists T3;
-create table T3 (a3 int, b3 date, c3 int not null, d3 int not null, 
+drop table t3;
+create table t3 (a3 int, b3 date, c3 int not null, d3 int not null, 
 primary key(a3,b3)) engine = ndb;
-insert into T3 values (0x1f, '1905-05-17', 1, 0x1f);
-insert into T3 values (0x2f, '2000-02-28', 2, 0x2f);
-insert into T3 values (0x3f, '2000-02-29', 3, 0x3f);
+insert into t3 values (0x1f, '1905-05-17', 1, 0x1f);
+insert into t3 values (0x2f, '2000-02-28', 2, 0x2f);
+insert into t3 values (0x3f, '2000-02-29', 3, 0x3f);
 explain
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='2000-02-28';
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='2000-02-28';
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	x	ref	PRIMARY	PRIMARY	4	const	10	Pushed 2 joins
 1	SIMPLE	y	eq_ref	PRIMARY	PRIMARY	7	test.x.d3,const	1	
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='2000-02-28';
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='2000-02-28';
 a3	b3	c3	d3	a3	b3	c3	d3
 47	2000-02-28	2	47	47	2000-02-28	2	47
-drop table if exists T3;
-create table T3 (a3 int, b3 datetime, c3 int not null, d3 int not null, 
+drop table t3;
+create table t3 (a3 int, b3 datetime, c3 int not null, d3 int not null, 
 primary key(a3,b3)) engine = ndb;
-insert into T3 values (0x1f, '1905-05-17 12:30:00', 1, 0x1f);
-insert into T3 values (0x2f, '2000-02-28 23:59:00', 2, 0x2f);
-insert into T3 values (0x3f, '2000-02-29 12:59:59', 2, 0x3f);
+insert into t3 values (0x1f, '1905-05-17 12:30:00', 1, 0x1f);
+insert into t3 values (0x2f, '2000-02-28 23:59:00', 2, 0x2f);
+insert into t3 values (0x3f, '2000-02-29 12:59:59', 2, 0x3f);
 explain
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='2000-02-28 23:59';
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='2000-02-28 23:59';
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	x	ref	PRIMARY	PRIMARY	4	const	10	Pushed 2 joins
 1	SIMPLE	y	eq_ref	PRIMARY	PRIMARY	12	test.x.d3,const	1	
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='2000-02-28 23:59';
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='2000-02-28 23:59';
 a3	b3	c3	d3	a3	b3	c3	d3
 47	2000-02-28 23:59:00	2	47	47	2000-02-28 23:59:00	2	47
-drop table if exists T3;
-create table T3 (a3 int, b3 time, c3 int not null, d3 int not null, 
+drop table t3;
+create table t3 (a3 int, b3 time, c3 int not null, d3 int not null, 
 primary key(a3,b3)) engine = ndb;
-insert into T3 values (0x1f, '12:30:00', 1, 0x1f);
-insert into T3 values (0x2f, '23:59:00', 2, 0x2f);
-insert into T3 values (0x3f, '12:59:59', 2, 0x3f);
+insert into t3 values (0x1f, '12:30:00', 1, 0x1f);
+insert into t3 values (0x2f, '23:59:00', 2, 0x2f);
+insert into t3 values (0x3f, '12:59:59', 2, 0x3f);
 explain
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='23:59';
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='23:59';
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	x	ref	PRIMARY	PRIMARY	4	const	10	Pushed 2 joins
 1	SIMPLE	y	eq_ref	PRIMARY	PRIMARY	7	test.x.d3,const	1	
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='23:59';
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='23:59';
 a3	b3	c3	d3	a3	b3	c3	d3
 47	23:59:00	2	47	47	23:59:00	2	47
-drop table if exists T3;
-create table T3 (a3 int, b3 char(16), c3 int not null, d3 int not null, 
+drop table t3;
+create table t3 (a3 int, b3 char(16), c3 int not null, d3 int not null, 
 primary key(a3,b3)) engine = ndb;
-insert into T3 values (0x1f, 'Ole', 1, 0x1f);
-insert into T3 values (0x2f, 'Dole', 2, 0x2f);
-insert into T3 values (0x3f, 'Doffen', 2, 0x3f);
+insert into t3 values (0x1f, 'Ole', 1, 0x1f);
+insert into t3 values (0x2f, 'Dole', 2, 0x2f);
+insert into t3 values (0x3f, 'Doffen', 2, 0x3f);
 explain
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	x	ref	PRIMARY	PRIMARY	4	const	10	Pushed 2 joins
 1	SIMPLE	y	eq_ref	PRIMARY	PRIMARY	20	test.x.d3,const	1	Using where with pushed condition
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
 a3	b3	c3	d3	a3	b3	c3	d3
 47	Dole	2	47	47	Dole	2	47
-drop table if exists T3;
-create table T3 (a3 int, b3 varchar(16), c3 int not null, d3 int not null, 
+drop table t3;
+create table t3 (a3 int, b3 varchar(16), c3 int not null, d3 int not null, 
 primary key(a3,b3)) engine = ndb;
-insert into T3 values (0x1f, 'Ole', 1, 0x1f);
-insert into T3 values (0x2f, 'Dole', 2, 0x2f);
-insert into T3 values (0x3f, 'Doffen', 2, 0x3f);
+insert into t3 values (0x1f, 'Ole', 1, 0x1f);
+insert into t3 values (0x2f, 'Dole', 2, 0x2f);
+insert into t3 values (0x3f, 'Doffen', 2, 0x3f);
 explain
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	x	ref	PRIMARY	PRIMARY	4	const	10	Pushed 2 joins
 1	SIMPLE	y	eq_ref	PRIMARY	PRIMARY	22	test.x.d3,const	1	Using where with pushed condition
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
 a3	b3	c3	d3	a3	b3	c3	d3
 47	Dole	2	47	47	Dole	2	47
-drop table if exists T3;
-create table T3 (a3 int, b3 varchar(512), c3 int not null, d3 int not null, 
+drop table t3;
+create table t3 (a3 int, b3 varchar(512), c3 int not null, d3 int not null, 
 primary key(a3,b3)) engine = ndb;
-insert into T3 values (0x1f, 'Ole', 1, 0x1f);
-insert into T3 values (0x2f, 'Dole', 2, 0x2f);
-insert into T3 values (0x3f, 'Doffen', 2, 0x3f);
+insert into t3 values (0x1f, 'Ole', 1, 0x1f);
+insert into t3 values (0x2f, 'Dole', 2, 0x2f);
+insert into t3 values (0x3f, 'Doffen', 2, 0x3f);
 explain
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	x	ref	PRIMARY	PRIMARY	4	const	10	Pushed 2 joins
 1	SIMPLE	y	eq_ref	PRIMARY	PRIMARY	518	test.x.d3,const	1	Using where with pushed condition
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
 a3	b3	c3	d3	a3	b3	c3	d3
 47	Dole	2	47	47	Dole	2	47
-drop table if exists T3;
-create table T3 (a3 int, b3 binary(16), c3 int not null, d3 int not null, 
+drop table t3;
+create table t3 (a3 int, b3 binary(16), c3 int not null, d3 int not null, 
 primary key(a3,b3)) engine = ndb;
-insert into T3 values (0x1f, 'Ole', 1, 0x1f);
-insert into T3 values (0x2f, 'Dole', 2, 0x2f);
-insert into T3 values (0x3f, 'Doffen', 2, 0x3f);
+insert into t3 values (0x1f, 'Ole', 1, 0x1f);
+insert into t3 values (0x2f, 'Dole', 2, 0x2f);
+insert into t3 values (0x3f, 'Doffen', 2, 0x3f);
 explain
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	x	ref	PRIMARY	PRIMARY	4	const	10	Pushed 2 joins
 1	SIMPLE	y	eq_ref	PRIMARY	PRIMARY	20	test.x.d3,const	1	Using where
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
 a3	b3	c3	d3	a3	b3	c3	d3
-drop table if exists T3;
-create table T3 (a3 int, b3 varbinary(16), c3 int not null, d3 int not null, 
+drop table t3;
+create table t3 (a3 int, b3 varbinary(16), c3 int not null, d3 int not null, 
 primary key(a3,b3)) engine = ndb;
-insert into T3 values (0x1f, 'Ole', 1, 0x1f);
-insert into T3 values (0x2f, 'Dole', 2, 0x2f);
-insert into T3 values (0x3f, 'Doffen', 2, 0x3f);
+insert into t3 values (0x1f, 'Ole', 1, 0x1f);
+insert into t3 values (0x2f, 'Dole', 2, 0x2f);
+insert into t3 values (0x3f, 'Doffen', 2, 0x3f);
 explain
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	x	ref	PRIMARY	PRIMARY	4	const	10	Pushed 2 joins
 1	SIMPLE	y	eq_ref	PRIMARY	PRIMARY	22	test.x.d3,const	1	Using where
-select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
+select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
 a3	b3	c3	d3	a3	b3	c3	d3
 47	Dole	2	47	47	Dole	2	47
-drop table if exists T3;
+drop table t3;
 set ndb_join_pushdown = @save_ndb_join_pushdown;

=== modified file 'mysql-test/suite/ndb/t/ndb_join_pushdown.test'
--- a/mysql-test/suite/ndb/t/ndb_join_pushdown.test	2009-12-14 08:16:16 +0000
+++ b/mysql-test/suite/ndb/t/ndb_join_pushdown.test	2009-12-15 07:56:10 +0000
@@ -735,258 +735,254 @@ drop table t1, t2;
 ## with its previous parents.
 ## All datatypes are tested in the section below
 ##
-  drop table if exists T3;
-  create table T3 (a3 int, b3 tinyint, c3 int not null, d3 int not null, 
+  create table t3 (a3 int, b3 tinyint, c3 int not null, d3 int not null, 
     primary key(a3,b3)) engine = ndb;
-  insert into T3 values (0x1f, 0x2f, 1, 0x1f);
-  insert into T3 values (0x2f, 0x3f, 2, 0x2f);
-  insert into T3 values (0x3f, 0x1f, 3, 0x3f);
+  insert into t3 values (0x1f, 0x2f, 1, 0x1f);
+  insert into t3 values (0x2f, 0x3f, 2, 0x2f);
+  insert into t3 values (0x3f, 0x1f, 3, 0x3f);
   explain
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3="63";
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3="63";
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3="63";
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3="63";
+  drop table t3;
 
-  drop table if exists T3;
-  create table T3 (a3 int, b3 tinyint unsigned, c3 int not null, d3 int not null, 
+  create table t3 (a3 int, b3 tinyint unsigned, c3 int not null, d3 int not null, 
     primary key(a3,b3)) engine = ndb;
-  insert into T3 values (0x1f, 0x2f, 1, 0x1f);
-  insert into T3 values (0x2f, 0x3f, 2, 0x2f);
-  insert into T3 values (0x3f, 0x1f, 3, 0x3f);
+  insert into t3 values (0x1f, 0x2f, 1, 0x1f);
+  insert into t3 values (0x2f, 0x3f, 2, 0x2f);
+  insert into t3 values (0x3f, 0x1f, 3, 0x3f);
   explain
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+  drop table t3;
 
-  drop table if exists T3;
-  create table T3 (a3 int, b3 smallint, c3 int not null, d3 int not null, 
+  create table t3 (a3 int, b3 smallint, c3 int not null, d3 int not null, 
     primary key(a3,b3)) engine = ndb;
-  insert into T3 values (0x1f, 0x2f, 1, 0x1f);
-  insert into T3 values (0x2f, 0x3f, 2, 0x2f);
-  insert into T3 values (0x3f, 0x1f, 3, 0x3f);
+  insert into t3 values (0x1f, 0x2f, 1, 0x1f);
+  insert into t3 values (0x2f, 0x3f, 2, 0x2f);
+  insert into t3 values (0x3f, 0x1f, 3, 0x3f);
   explain
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+  drop table t3;
 
-  drop table if exists T3;
-  create table T3 (a3 int, b3 smallint unsigned, c3 int not null, d3 int not null, 
+  create table t3 (a3 int, b3 smallint unsigned, c3 int not null, d3 int not null, 
     primary key(a3,b3)) engine = ndb;
-  insert into T3 values (0x1f, 0x2f, 1, 0x1f);
-  insert into T3 values (0x2f, 0x3f, 2, 0x2f);
-  insert into T3 values (0x3f, 0x1f, 3, 0x3f);
+  insert into t3 values (0x1f, 0x2f, 1, 0x1f);
+  insert into t3 values (0x2f, 0x3f, 2, 0x2f);
+  insert into t3 values (0x3f, 0x1f, 3, 0x3f);
   explain
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+  drop table t3;
 
-  drop table if exists T3;
-  create table T3 (a3 int, b3 mediumint, c3 int not null, d3 int not null, 
+  create table t3 (a3 int, b3 mediumint, c3 int not null, d3 int not null, 
     primary key(a3,b3)) engine = ndb;
-  insert into T3 values (0x1f, 0x2f, 1, 0x1f);
-  insert into T3 values (0x2f, 0x3f, 2, 0x2f);
-  insert into T3 values (0x3f, 0x1f, 3, 0x3f);
+  insert into t3 values (0x1f, 0x2f, 1, 0x1f);
+  insert into t3 values (0x2f, 0x3f, 2, 0x2f);
+  insert into t3 values (0x3f, 0x1f, 3, 0x3f);
   explain
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+  drop table t3;
 
-  drop table if exists T3;
-  create table T3 (a3 int, b3 mediumint unsigned, c3 int not null, d3 int not null, 
+  create table t3 (a3 int, b3 mediumint unsigned, c3 int not null, d3 int not null, 
     primary key(a3,b3)) engine = ndb;
-  insert into T3 values (0x1f, 0x2f, 1, 0x1f);
-  insert into T3 values (0x2f, 0x3f, 2, 0x2f);
-  insert into T3 values (0x3f, 0x1f, 3, 0x3f);
+  insert into t3 values (0x1f, 0x2f, 1, 0x1f);
+  insert into t3 values (0x2f, 0x3f, 2, 0x2f);
+  insert into t3 values (0x3f, 0x1f, 3, 0x3f);
   explain
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+  drop table t3;
 
-  drop table if exists T3;
-  create table T3 (a3 int, b3 int, c3 int not null, d3 int not null, 
+  create table t3 (a3 int, b3 int, c3 int not null, d3 int not null, 
     primary key(a3,b3)) engine = ndb;
-  insert into T3 values (0x1f, 0x2f, 1, 0x1f);
-  insert into T3 values (0x2f, 0x3f, 2, 0x2f);
-  insert into T3 values (0x3f, 0x1f, 3, 0x3f);
+  insert into t3 values (0x1f, 0x2f, 1, 0x1f);
+  insert into t3 values (0x2f, 0x3f, 2, 0x2f);
+  insert into t3 values (0x3f, 0x1f, 3, 0x3f);
   explain
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+  drop table t3;
 
-  drop table if exists T3;
-  create table T3 (a3 int, b3 int unsigned, c3 int not null, d3 int not null, 
+  create table t3 (a3 int, b3 int unsigned, c3 int not null, d3 int not null, 
     primary key(a3,b3)) engine = ndb;
-  insert into T3 values (0x1f, 0x2f, 1, 0x1f);
-  insert into T3 values (0x2f, 0x3f, 2, 0x2f);
-  insert into T3 values (0x3f, 0x1f, 3, 0x3f);
+  insert into t3 values (0x1f, 0x2f, 1, 0x1f);
+  insert into t3 values (0x2f, 0x3f, 2, 0x2f);
+  insert into t3 values (0x3f, 0x1f, 3, 0x3f);
   explain
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+  drop table t3;
 
-  drop table if exists T3;
-  create table T3 (a3 int, b3 bigint, c3 int not null, d3 int not null, 
+  create table t3 (a3 int, b3 bigint, c3 int not null, d3 int not null, 
     primary key(a3,b3)) engine = ndb;
-  insert into T3 values (0x1f, 0x2f, 1, 0x1f);
-  insert into T3 values (0x2f, 0x3f, 2, 0x2f);
-  insert into T3 values (0x3f, 0x1f, 3, 0x3f);
+  insert into t3 values (0x1f, 0x2f, 1, 0x1f);
+  insert into t3 values (0x2f, 0x3f, 2, 0x2f);
+  insert into t3 values (0x3f, 0x1f, 3, 0x3f);
   explain
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+  drop table t3;
 
-  drop table if exists T3;
-  create table T3 (a3 int, b3 bigint unsigned, c3 int not null, d3 int not null, 
+  create table t3 (a3 int, b3 bigint unsigned, c3 int not null, d3 int not null, 
     primary key(a3,b3)) engine = ndb;
-  insert into T3 values (0x1f, 0x2f, 1, 0x1f);
-  insert into T3 values (0x2f, 0x3f, 2, 0x2f);
-  insert into T3 values (0x3f, 0x1f, 3, 0x3f);
+  insert into t3 values (0x1f, 0x2f, 1, 0x1f);
+  insert into t3 values (0x2f, 0x3f, 2, 0x2f);
+  insert into t3 values (0x3f, 0x1f, 3, 0x3f);
   explain
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=(60+3);
+  drop table t3;
 
-  drop table if exists T3;
-  create table T3 (a3 int, b3 boolean, c3 int not null, d3 int not null, 
+  create table t3 (a3 int, b3 boolean, c3 int not null, d3 int not null, 
     primary key(a3,b3)) engine = ndb;
-  insert into T3 values (0x1f, 0, 1, 0x1f);
-  insert into T3 values (0x2f, 1, 2, 0x2f);
-  insert into T3 values (0x3f, 0, 3, 0x3f);
+  insert into t3 values (0x1f, 0, 1, 0x1f);
+  insert into t3 values (0x2f, 1, 2, 0x2f);
+  insert into t3 values (0x3f, 0, 3, 0x3f);
   explain
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=1;
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=1;
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=1;
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=1;
+  drop table t3;
 
-  drop table if exists T3;
-  create table T3 (a3 int, b3 float, c3 int not null, d3 int not null, 
+  create table t3 (a3 int, b3 float, c3 int not null, d3 int not null, 
     primary key(a3,b3)) engine = ndb;
-  insert into T3 values (0x1f, 2.71, 1, 0x1f);
-  insert into T3 values (0x2f, 3.00, 2, 0x2f);
-  insert into T3 values (0x3f, 0.50, 3, 0x3f);
+  insert into t3 values (0x1f, 2.71, 1, 0x1f);
+  insert into t3 values (0x2f, 3.00, 2, 0x2f);
+  insert into t3 values (0x3f, 0.50, 3, 0x3f);
   explain
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.0;
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.0;
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.0;
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.0;
+  drop table t3;
 
-  drop table if exists T3;
-  create table T3 (a3 int, b3 float unsigned, c3 int not null, d3 int not null, 
+  create table t3 (a3 int, b3 float unsigned, c3 int not null, d3 int not null, 
     primary key(a3,b3)) engine = ndb;
-  insert into T3 values (0x1f, 2.71, 1, 0x1f);
-  insert into T3 values (0x2f, 3.00, 2, 0x2f);
-  insert into T3 values (0x3f, 0.50, 3, 0x3f);
+  insert into t3 values (0x1f, 2.71, 1, 0x1f);
+  insert into t3 values (0x2f, 3.00, 2, 0x2f);
+  insert into t3 values (0x3f, 0.50, 3, 0x3f);
   explain
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.0;
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.0;
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.0;
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.0;
+  drop table t3;
 
-  drop table if exists T3;
-  create table T3 (a3 int, b3 double, c3 int not null, d3 int not null, 
+  create table t3 (a3 int, b3 double, c3 int not null, d3 int not null, 
     primary key(a3,b3)) engine = ndb;
-  insert into T3 values (0x1f, 2.71, 1, 0x1f);
-  insert into T3 values (0x2f, 3.14, 2, 0x2f);
-  insert into T3 values (0x3f, 0.50, 3, 0x3f);
+  insert into t3 values (0x1f, 2.71, 1, 0x1f);
+  insert into t3 values (0x2f, 3.14, 2, 0x2f);
+  insert into t3 values (0x3f, 0.50, 3, 0x3f);
   explain
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.14;
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.14;
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.14;
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.14;
+  drop table t3;
 
-  drop table if exists T3;
-  create table T3 (a3 int, b3 double unsigned, c3 int not null, d3 int not null, 
+  create table t3 (a3 int, b3 double unsigned, c3 int not null, d3 int not null, 
     primary key(a3,b3)) engine = ndb;
-  insert into T3 values (0x1f, 2.71, 1, 0x1f);
-  insert into T3 values (0x2f, 3.14, 2, 0x2f);
-  insert into T3 values (0x3f, 0.50, 3, 0x3f);
+  insert into t3 values (0x1f, 2.71, 1, 0x1f);
+  insert into t3 values (0x2f, 3.14, 2, 0x2f);
+  insert into t3 values (0x3f, 0.50, 3, 0x3f);
   explain
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.14;
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.14;
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.14;
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.14;
+  drop table t3;
 
-  drop table if exists T3;
-  create table T3 (a3 int, b3 decimal, c3 int not null, d3 int not null, 
+  create table t3 (a3 int, b3 decimal, c3 int not null, d3 int not null, 
     primary key(a3,b3)) engine = ndb;
-  insert into T3 values (0x1f, 0x2f, 1, 0x1f);
-  insert into T3 values (0x2f, 0x3f, 2, 0x2f);
-  insert into T3 values (0x3f, 0x1f, 3, 0x3f);
+  insert into t3 values (0x1f, 0x2f, 1, 0x1f);
+  insert into t3 values (0x2f, 0x3f, 2, 0x2f);
+  insert into t3 values (0x3f, 0x1f, 3, 0x3f);
   explain
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=63;
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=63;
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=63;
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=63;
+  drop table t3;
 
-  drop table if exists T3;
-  create table T3 (a3 int, b3 decimal(12,4), c3 int not null, d3 int not null, 
+  create table t3 (a3 int, b3 decimal(12,4), c3 int not null, d3 int not null, 
     primary key(a3,b3)) engine = ndb;
-  insert into T3 values (0x1f, 2.71, 1, 0x1f);
-  insert into T3 values (0x2f, 3.14, 2, 0x2f);
-  insert into T3 values (0x3f, 0.50, 3, 0x3f);
+  insert into t3 values (0x1f, 2.71, 1, 0x1f);
+  insert into t3 values (0x2f, 3.14, 2, 0x2f);
+  insert into t3 values (0x3f, 0.50, 3, 0x3f);
   explain
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.14;
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.14;
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.14;
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3=3.14;
+  drop table t3;
 
-  drop table if exists T3;
-  create table T3 (a3 int, b3 date, c3 int not null, d3 int not null, 
+  create table t3 (a3 int, b3 date, c3 int not null, d3 int not null, 
     primary key(a3,b3)) engine = ndb;
-  insert into T3 values (0x1f, '1905-05-17', 1, 0x1f);
-  insert into T3 values (0x2f, '2000-02-28', 2, 0x2f);
-  insert into T3 values (0x3f, '2000-02-29', 3, 0x3f);
+  insert into t3 values (0x1f, '1905-05-17', 1, 0x1f);
+  insert into t3 values (0x2f, '2000-02-28', 2, 0x2f);
+  insert into t3 values (0x3f, '2000-02-29', 3, 0x3f);
   explain
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='2000-02-28';
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='2000-02-28';
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='2000-02-28';
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='2000-02-28';
+  drop table t3;
 
-  drop table if exists T3;
-  create table T3 (a3 int, b3 datetime, c3 int not null, d3 int not null, 
+  create table t3 (a3 int, b3 datetime, c3 int not null, d3 int not null, 
     primary key(a3,b3)) engine = ndb;
-  insert into T3 values (0x1f, '1905-05-17 12:30:00', 1, 0x1f);
-  insert into T3 values (0x2f, '2000-02-28 23:59:00', 2, 0x2f);
-  insert into T3 values (0x3f, '2000-02-29 12:59:59', 2, 0x3f);
+  insert into t3 values (0x1f, '1905-05-17 12:30:00', 1, 0x1f);
+  insert into t3 values (0x2f, '2000-02-28 23:59:00', 2, 0x2f);
+  insert into t3 values (0x3f, '2000-02-29 12:59:59', 2, 0x3f);
   explain
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='2000-02-28 23:59';
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='2000-02-28 23:59';
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='2000-02-28 23:59';
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='2000-02-28 23:59';
+  drop table t3;
 
-  drop table if exists T3;
-  create table T3 (a3 int, b3 time, c3 int not null, d3 int not null, 
+  create table t3 (a3 int, b3 time, c3 int not null, d3 int not null, 
     primary key(a3,b3)) engine = ndb;
-  insert into T3 values (0x1f, '12:30:00', 1, 0x1f);
-  insert into T3 values (0x2f, '23:59:00', 2, 0x2f);
-  insert into T3 values (0x3f, '12:59:59', 2, 0x3f);
+  insert into t3 values (0x1f, '12:30:00', 1, 0x1f);
+  insert into t3 values (0x2f, '23:59:00', 2, 0x2f);
+  insert into t3 values (0x3f, '12:59:59', 2, 0x3f);
   explain
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='23:59';
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='23:59';
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='23:59';
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='23:59';
+  drop table t3;
 
-  drop table if exists T3;
-  create table T3 (a3 int, b3 char(16), c3 int not null, d3 int not null, 
+  create table t3 (a3 int, b3 char(16), c3 int not null, d3 int not null, 
     primary key(a3,b3)) engine = ndb;
-  insert into T3 values (0x1f, 'Ole', 1, 0x1f);
-  insert into T3 values (0x2f, 'Dole', 2, 0x2f);
-  insert into T3 values (0x3f, 'Doffen', 2, 0x3f);
+  insert into t3 values (0x1f, 'Ole', 1, 0x1f);
+  insert into t3 values (0x2f, 'Dole', 2, 0x2f);
+  insert into t3 values (0x3f, 'Doffen', 2, 0x3f);
   explain
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
+  drop table t3;
 
-  drop table if exists T3;
-  create table T3 (a3 int, b3 varchar(16), c3 int not null, d3 int not null, 
+  create table t3 (a3 int, b3 varchar(16), c3 int not null, d3 int not null, 
     primary key(a3,b3)) engine = ndb;
-  insert into T3 values (0x1f, 'Ole', 1, 0x1f);
-  insert into T3 values (0x2f, 'Dole', 2, 0x2f);
-  insert into T3 values (0x3f, 'Doffen', 2, 0x3f);
+  insert into t3 values (0x1f, 'Ole', 1, 0x1f);
+  insert into t3 values (0x2f, 'Dole', 2, 0x2f);
+  insert into t3 values (0x3f, 'Doffen', 2, 0x3f);
   explain
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
+  drop table t3;
 
-  drop table if exists T3;
-  create table T3 (a3 int, b3 varchar(512), c3 int not null, d3 int not null, 
+  create table t3 (a3 int, b3 varchar(512), c3 int not null, d3 int not null, 
     primary key(a3,b3)) engine = ndb;
-  insert into T3 values (0x1f, 'Ole', 1, 0x1f);
-  insert into T3 values (0x2f, 'Dole', 2, 0x2f);
-  insert into T3 values (0x3f, 'Doffen', 2, 0x3f);
+  insert into t3 values (0x1f, 'Ole', 1, 0x1f);
+  insert into t3 values (0x2f, 'Dole', 2, 0x2f);
+  insert into t3 values (0x3f, 'Doffen', 2, 0x3f);
   explain
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
-
-  drop table if exists T3;
-  create table T3 (a3 int, b3 binary(16), c3 int not null, d3 int not null, 
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
+  drop table t3;
+  
+  create table t3 (a3 int, b3 binary(16), c3 int not null, d3 int not null, 
     primary key(a3,b3)) engine = ndb;
-  insert into T3 values (0x1f, 'Ole', 1, 0x1f);
-  insert into T3 values (0x2f, 'Dole', 2, 0x2f);
-  insert into T3 values (0x3f, 'Doffen', 2, 0x3f);
+  insert into t3 values (0x1f, 'Ole', 1, 0x1f);
+  insert into t3 values (0x2f, 'Dole', 2, 0x2f);
+  insert into t3 values (0x3f, 'Doffen', 2, 0x3f);
   explain
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
-
-  drop table if exists T3;
-  create table T3 (a3 int, b3 varbinary(16), c3 int not null, d3 int not null, 
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
+  drop table t3;
+  
+  create table t3 (a3 int, b3 varbinary(16), c3 int not null, d3 int not null, 
     primary key(a3,b3)) engine = ndb;
-  insert into T3 values (0x1f, 'Ole', 1, 0x1f);
-  insert into T3 values (0x2f, 'Dole', 2, 0x2f);
-  insert into T3 values (0x3f, 'Doffen', 2, 0x3f);
+  insert into t3 values (0x1f, 'Ole', 1, 0x1f);
+  insert into t3 values (0x2f, 'Dole', 2, 0x2f);
+  insert into t3 values (0x3f, 'Doffen', 2, 0x3f);
   explain
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
-  select * from T3 x, T3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
-
-  drop table if exists T3;
-
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
+  select * from t3 x, t3 y where x.a3=0x2f and y.a3=x.d3 and y.b3='Dole';
+  drop table t3;
 
 set ndb_join_pushdown = @save_ndb_join_pushdown;
-


Attachment: [text/bzr-bundle] bzr/jonas@mysql.com-20091215075610-fy1xai1e7goicc1w.bundle
Thread
bzr commit into mysql-5.1-telco-7.0-spj branch (jonas:3021)Jonas Oreland15 Dec