maria-developers team mailing list archive

[Sergey Petrunya <psergey@xxxxxxxxxxxx>]

At file:///home/psergey/dev/maria-5.3-subqueries-r12/

------------------------------------------------------------
revno: 2790
revision-id: psergey@xxxxxxxxxxxx-20100406083401-36tcbqvit0wtilcx
parent: psergey@xxxxxxxxxxxx-20100406081058-ihhw7esolj0mzc9a
committer: Sergey Petrunya <psergey@xxxxxxxxxxxx>
branch nick: maria-5.3-subqueries-r12
timestamp: Tue 2010-04-06 12:34:01 +0400
message:
  MWL#90: Subqueries: Inside-out execution for non-semijoin materialized
    subqueries that are AND-parts of the WHERE
  - Update test results (checked, we get 0 because the subquery is actually
    evaluated by the EXPLAIN).
=== modified file 'mysql-test/r/myisam_mrr.result'
--- a/mysql-test/r/myisam_mrr.result	2010-03-11 21:43:31 +0000
+++ b/mysql-test/r/myisam_mrr.result	2010-04-06 08:34:01 +0000
@@ -347,7 +347,7 @@
 );
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
 1	PRIMARY	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	Impossible WHERE
-2	SUBQUERY	t2	ALL	int_key	int_key	5		3	33.33	Using index condition; Using filesort
+2	SUBQUERY	t2	ALL	int_key	int_key	5		0	0.00	Using index condition; Using filesort
 Warnings:
 Note	1003	select min(`test`.`t1`.`pk`) AS `MIN(t1.pk)` from `test`.`t1` where 0
 DROP TABLE t1, t2;