Re: [Maria-developers] [Commits] 922f970: MDEV-12882 - Assertion failed in MDL_context::upgrade_shared_lock

2017-06-22 Thread Sergey Vojtovich
Sergei, On Thu, Jun 22, 2017 at 07:57:21PM +0200, Sergei Golubchik wrote: > Hi, Sergey! > > On Jun 22, Sergey Vojtovich wrote: > > revision-id: 922f9700a7fb084e3f7d6cff56e27e24fc603ed7 > > (mariadb-10.2.6-58-g922f970) > > parent(s): 62021f391a42c5577190aa43cb8ad91e56235b46 > > committer: Sergey

[Maria-developers] Condition pushdown into derived tables and outer joins.

2017-06-22 Thread Sergey Petrunia
Hello Igor, While reviewing MDEV-12845, I've found this piece in sql_select.cc: while ((tbl= li++)) { /* Do not push conditions from where into materialized inner tables of outer joins: this is not valid. */ if (tbl->is_materialized_derived()) {

Re: [Maria-developers] [Commits] 922f970: MDEV-12882 - Assertion failed in MDL_context::upgrade_shared_lock

2017-06-22 Thread Sergei Golubchik
Hi, Sergey! On Jun 22, Sergey Vojtovich wrote: > revision-id: 922f9700a7fb084e3f7d6cff56e27e24fc603ed7 > (mariadb-10.2.6-58-g922f970) > parent(s): 62021f391a42c5577190aa43cb8ad91e56235b46 > committer: Sergey Vojtovich > timestamp: 2017-06-22 17:35:36 +0400 > message: > > MDEV-12882 - Assertion f