[Commits] Rev 4474: Fix buildbot failure: make selectivity.test and selectivity_innodb.test work when in file:///home/psergey/dev2/10.0-cp1/

Sergey Petrunya psergey at askmonty.org
Tue Nov 11 18:59:34 EET 2014


At file:///home/psergey/dev2/10.0-cp1/

------------------------------------------------------------
revno: 4474
revision-id: psergey at askmonty.org-20141111165931-d61nkv28s0pcajoz
parent: bar at mnogosearch.org-20141110124327-ffw2mpmfcjhxmtk5
committer: Sergey Petrunya <psergey at askmonty.org>
branch nick: 10.0-cp1
timestamp: Tue 2014-11-11 19:59:31 +0300
message:
  Fix buildbot failure: make selectivity.test and selectivity_innodb.test work when
  table names are case-insensitive.
=== modified file 'mysql-test/r/selectivity.result'
--- a/mysql-test/r/selectivity.result	2014-10-29 05:31:52 +0000
+++ b/mysql-test/r/selectivity.result	2014-11-11 16:59:31 +0000
@@ -1400,12 +1400,12 @@ Table	Op	Msg_type	Msg_text
 test.t2	analyze	status	Engine-independent statistics collected
 test.t2	analyze	status	OK
 explain extended
-select * from t2 A straight_join t2 B where A.a is null;
+select * from t2 a straight_join t2 b where a.a is null;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
-1	SIMPLE	A	ALL	NULL	NULL	NULL	NULL	1000	100.00	Using where
-1	SIMPLE	B	ALL	NULL	NULL	NULL	NULL	1000	100.00	Using join buffer (flat, BNL join)
+1	SIMPLE	a	ALL	NULL	NULL	NULL	NULL	1000	100.00	Using where
+1	SIMPLE	b	ALL	NULL	NULL	NULL	NULL	1000	100.00	Using join buffer (flat, BNL join)
 Warnings:
-Note	1003	select `test`.`A`.`a` AS `a`,`test`.`A`.`b` AS `b`,`test`.`B`.`a` AS `a`,`test`.`B`.`b` AS `b` from `test`.`t2` `A` straight_join `test`.`t2` `B` where isnull(`test`.`A`.`a`)
+Note	1003	select `test`.`a`.`a` AS `a`,`test`.`a`.`b` AS `b`,`test`.`b`.`a` AS `a`,`test`.`b`.`b` AS `b` from `test`.`t2` `a` straight_join `test`.`t2` `b` where isnull(`test`.`a`.`a`)
 set histogram_size=@save_histogram_size;
 set optimizer_use_condition_selectivity=@save_optimizer_use_condition_selectivity;
 drop table t0,t1,t2;

=== modified file 'mysql-test/r/selectivity_innodb.result'
--- a/mysql-test/r/selectivity_innodb.result	2014-10-29 05:31:52 +0000
+++ b/mysql-test/r/selectivity_innodb.result	2014-11-11 16:59:31 +0000
@@ -1410,12 +1410,12 @@ Table	Op	Msg_type	Msg_text
 test.t2	analyze	status	Engine-independent statistics collected
 test.t2	analyze	status	OK
 explain extended
-select * from t2 A straight_join t2 B where A.a is null;
+select * from t2 a straight_join t2 b where a.a is null;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
-1	SIMPLE	A	ALL	NULL	NULL	NULL	NULL	1000	100.00	Using where
-1	SIMPLE	B	ALL	NULL	NULL	NULL	NULL	1000	100.00	Using join buffer (flat, BNL join)
+1	SIMPLE	a	ALL	NULL	NULL	NULL	NULL	1000	100.00	Using where
+1	SIMPLE	b	ALL	NULL	NULL	NULL	NULL	1000	100.00	Using join buffer (flat, BNL join)
 Warnings:
-Note	1003	select `test`.`A`.`a` AS `a`,`test`.`A`.`b` AS `b`,`test`.`B`.`a` AS `a`,`test`.`B`.`b` AS `b` from `test`.`t2` `A` straight_join `test`.`t2` `B` where isnull(`test`.`A`.`a`)
+Note	1003	select `test`.`a`.`a` AS `a`,`test`.`a`.`b` AS `b`,`test`.`b`.`a` AS `a`,`test`.`b`.`b` AS `b` from `test`.`t2` `a` straight_join `test`.`t2` `b` where isnull(`test`.`a`.`a`)
 set histogram_size=@save_histogram_size;
 set optimizer_use_condition_selectivity=@save_optimizer_use_condition_selectivity;
 drop table t0,t1,t2;

=== modified file 'mysql-test/t/selectivity.test'
--- a/mysql-test/t/selectivity.test	2014-10-29 05:31:52 +0000
+++ b/mysql-test/t/selectivity.test	2014-11-11 16:59:31 +0000
@@ -935,7 +935,7 @@ set optimizer_use_condition_selectivity=
 analyze table t2 persistent for all;
 
 explain extended
-select * from t2 A straight_join t2 B where A.a is null;
+select * from t2 a straight_join t2 b where a.a is null;
 
 set histogram_size=@save_histogram_size;
 set optimizer_use_condition_selectivity=@save_optimizer_use_condition_selectivity;



More information about the commits mailing list