Re: [Maria-developers] MDEV-17399: Columns of JSON datatype?

2021-02-14 Thread Alexey Botchkov
> What do you think? Returning the JSON subdocument would violate the standard. I think it makes sense as the user normally expects the scalar value and if there is the JSON subdocument in the searched field, it's rather an error and must be detected. I'd add the FORMAT JSON keyword to handle th

Re: [Maria-developers] MDEV-17399: Name resolution and handling dependencies

2021-02-14 Thread Alexey Botchkov
Well i just did that end_lateral_table trick for now. HF On Tue, Feb 9, 2021 at 3:05 PM Sergey Petrunia wrote: > Hi Alexey, > > At the moment, name resolution of JSON_TABLE's first argument is done > "like in > the WHERE clause" - one can refer to any table that is defined in the WHERE > claus