lp:~maria-captains/maria/5.3-optimizer-debugging

Branch merges

Propose for merging

No branches dependent on this one.

Related source package recipes

No recipes using this branch. (?)

Create packaging recipe

Related snap packages

Related bugs

Related blueprints

3397. By Sergey Petrunia on 2012-03-01

Merge 5.3 -> 5.3-optimizer-debugging

3396. By Sergey Petrunia on 2012-02-21

Merge 5.3 -> 5.3-optimizer-debugging

3395. By Sergey Petrunia on 2012-01-25

Merge 5.3->main -> 5.3-optimizer_debugging

3394. By Sergey Petrunia on 2012-01-24

Merge 5.3-main -> 5.3-optimizer-debugging

3393. By Oleksandr "Sanja" Byelkin on 2012-01-23

Fixed creating limit for exists subquery.

3392. By Igor Babaev on 2012-01-22

Back-ported test cases for bugs #54437, #55955, #52329, #57623 from subquery_sj
of mysql-5.6 code line. The bugs could not be reproduced in the latest release
of mariadb-5.3 as they were fixed either when the code of subquery optimization
was back-ported from mysql-6.0 or later when some other bugs were fixed.

3391. By Igor Babaev on 2012-01-22

Back-ported test cases for bugs #53060, #53305, #50358, #49453 from subquery_sj
of mysql-5.6 code line. The bugs could not be reproduced in the latest release
of mariadb-5.3 as they were fixed either when the code of subquery optimization
was back-ported from mysql-6.0 or later when some other bugs were fixed.

3390. By Sergey Petrunia on 2012-01-19

BUG#912513: Wrong result (missing rows) with join_cache_hashed+materialization+semijoin=on
- equality substitution code was geared towards processing WHERE/ON clauses.
  that is, it assumed that it was doing substitions on the code that
   = wasn't attached to any particular join_tab yet
   = was going to be fed to make_join_select() which would take the condition
     apart and attach various parts of it to tables inside/outside semi-joins.
- However, somebody added equality substition for ref access. That is, if
  we have a ref access on TBL.key=expr, they would do equality substition in
  'expr'. This possibility wasn't accounted for.
- Fixed equality substition code by adding a mode that does equality
  substition under assumption that the processed expression will be
  attached to a certain particular table TBL.

3389. By Sergey Petrunia on 2012-01-19

BUG#912538: Wrong result (missing rows) with semijoin=on, firstmatch=on, ...
- setup_semijoin_dups_elimination() would incorrectly set join_tab->do_firstmatch
  when the join order had outer tables interleaved with inner.

3388. By Vladislav Vaintroub on 2012-01-19

Fix compiler warning on Windows.