Re: [Maria-developers] MDEV-17399: JSON_TABLE: final input

2021-03-13 Thread Alexey Botchkov
The Json_table_nested_path lives only inside the Table_function_json_table and that last one is the only class that manipulates the Json_table_nested_path internals. Using methods in your version, but it's the only class using these methods anyway. So to me it's seems more honest to declare classes

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 JSON_TAB