Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
5.5(EOL)
-
None
Description
main.subselect_sj2_jcl6 'innodb_plugin' w1 [ fail ]
|
Test ended at 2015-03-17 20:35:53
|
 |
CURRENT_TEST: main.subselect_sj2_jcl6
|
--- /usr/local/mariadb-5.5.42-linux-x86_64/mysql-test/r/subselect_sj2_jcl6,innodb_plugin.result~ 2015-03-17 20:35:53.000000000 +0100
|
+++ /usr/local/mariadb-5.5.42-linux-x86_64/mysql-test/r/subselect_sj2_jcl6,innodb_plugin.reject 2015-03-17 20:35:53.000000000 +0100
|
@@ -1272,7 +1272,7 @@
|
);
|
id select_type table type possible_keys key key_len ref rows Extra
|
1 PRIMARY T3_0_ ref PRIMARY,FK_T3_T2Id PRIMARY 8 const 3 Using index; Start temporary
|
-1 PRIMARY T2_1_ eq_ref PRIMARY,FK_T2_T1Id PRIMARY 8 test.T3_0_.t2idref 1 Using join buffer (flat, BKA join); Key-ordered scan
|
+1 PRIMARY T2_1_ eq_ref PRIMARY,FK_T2_T1Id PRIMARY 8 test.T3_0_.t2idref 1
|
1 PRIMARY T1_1_ eq_ref PRIMARY PRIMARY 8 test.T2_1_.t1idref 1 Using index
|
1 PRIMARY T2_0_ ref FK_T2_T1Id FK_T2_T1Id 8 test.T2_1_.t1idref 1 Using index; End temporary
|
drop table t3,t2,t1;
|
The test started failing with this revision:
Change #46036
Category None
Changed by Sergei Petrunia <psergey@askmonty.org>
Changed at Tue 17 Mar 2015 12:26:33
Repository https://github.com/MariaDB/server
Branch 5.5
Revision c020d362b68d0cfad03cabdeef508ca22e26d485
Comments
MDEV-7474: Semi-Join's DuplicateWeedout strategy skipped ...JOIN::cur_dups_producing_tables was not maintained correctly in
the cases of greedy optimization (search_depth < n_tables).Moved it to POSITION structure where it will be maintained automatically.
Removed POSITION::prefix_dups_producing_tables since its value can now
be calculated.
Only InnoDB plugin combination fails.
Attachments
Issue Links
- blocks
-
MDEV-7069 Fix buildbot failures in main server trees
- Stalled