diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2012-04-04 21:35:34 +0400 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2012-04-04 21:35:34 +0400 |
| commit | cc2298ebb7e1225d6a293281bc949d746040d547 (patch) | |
| tree | a3d42b3eb3a680dec0ff7953a1b84c32175d912b /mysql-test/r/subselect_sj2_jcl6.result | |
| parent | e14d6ef4b77429313b563a79305a1775f52d9dc9 (diff) | |
| download | mariadb-git-cc2298ebb7e1225d6a293281bc949d746040d547.tar.gz | |
Make test results stable.
Diffstat (limited to 'mysql-test/r/subselect_sj2_jcl6.result')
| -rw-r--r-- | mysql-test/r/subselect_sj2_jcl6.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/r/subselect_sj2_jcl6.result b/mysql-test/r/subselect_sj2_jcl6.result index 172a4a40f4c..44cdb69e132 100644 --- a/mysql-test/r/subselect_sj2_jcl6.result +++ b/mysql-test/r/subselect_sj2_jcl6.result @@ -106,9 +106,9 @@ A.a + 10*B.a, A.a + 10*B.a, A.a + 10*B.a, A.a + 10*B.a from t0 A, t0 B where B.a <5; explain select * from t3 where b in (select a from t0); id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY t3 ALL b NULL NULL NULL 56 -1 PRIMARY <subquery2> eq_ref distinct_key distinct_key 4 func 1 -2 MATERIALIZED t0 ALL NULL NULL NULL NULL 10 +1 PRIMARY t3 ALL b NULL NULL NULL # +1 PRIMARY <subquery2> eq_ref distinct_key distinct_key 4 func # +2 MATERIALIZED t0 ALL NULL NULL NULL NULL # set @save_ecp= @@engine_condition_pushdown; set engine_condition_pushdown=0; select * from t3 where b in (select A.a+B.a from t0 A, t0 B where B.a<5); |