Re: [Maria-developers] MDEV-17399: JSON_TABLE: Incorrect code with table elimination

2021-03-15 Thread Sergey Petrunia
A patch for this issue: http://lists.askmonty.org/pipermail/commits/2021-March/014500.html I'll need to check one more thing. On Sun, Mar 14, 2021 at 08:42:40PM +0300, Sergey Petrunia wrote: > On Sat, Mar 13, 2021 at 04:01:56PM +0400, Alexey Botchkov wrote: > > I've rewritten it using the

Re: [Maria-developers] MDEV-17399: JSON_TABLE: Incorrect code with table elimination

2021-03-14 Thread Sergey Petrunia
On Sat, Mar 13, 2021 at 04:01:56PM +0400, Alexey Botchkov wrote: > I've rewritten it using the json->select_lex->leaf_tables as you suggested. > So the JSON_TABLE is calculated properly and all the dependencies seem to > be marked. > Still your testcase query fails the same way, so needs some more

Re: [Maria-developers] MDEV-17399: JSON_TABLE: Incorrect code with table elimination

2021-03-13 Thread Alexey Botchkov
I've rewritten it using the json->select_lex->leaf_tables as you suggested. So the JSON_TABLE is calculated properly and all the dependencies seem to be marked. Still your testcase query fails the same way, so needs some more investigation. To me it looks more like optimizer issue than the

[Maria-developers] MDEV-17399: JSON_TABLE: Incorrect code with table elimination

2021-03-11 Thread Sergey Petrunia
Hi Alexey, > diff --git a/sql/opt_table_elimination.cc b/sql/opt_table_elimination.cc > index 3958797ec44..f2497d524ec 100644 > --- a/sql/opt_table_elimination.cc > +++ b/sql/opt_table_elimination.cc > @@ -637,6 +637,16 @@ void eliminate_tables(JOIN *join) >List_iterator