On Fri, Mar 22, 2024 at 12:08 AM Amit Langote <amitlangot...@gmail.com> wrote: > > On Wed, Mar 20, 2024 at 9:53 PM Amit Langote <amitlangot...@gmail.com> wrote: > > I'll push 0001 tomorrow. > > Pushed that one. Here's the remaining JSON_TABLE() patch. > I know v45 is very different from v47. but v45 contains all the remaining features to be implemented.
I've attached 2 files. v45-0001-propagate-passing-clause-to-every-json_ta.based_on_v45 after_apply_jsonpathvar.sql. the first file should be applied after v45-0001-JSON_TABLE.patch the second file has all kinds of tests to prove that applying JsonPathVariable to the NESTED PATH is ok. I know that v45 is not the whole patch we are going to push for postgres17. I just want to point out that applying the PASSING clause to the NESTED PATH works fine with V45. that means, I think, we can safely apply PASSING clause to NESTED PATH for feature "PLAN DEFAULT clause", "specific PLAN clause" and "sibling NESTED COLUMNS clauses".
v45-0001-propagate-passing-clause-to-every-json_ta.based_on_v45
Description: Binary data
after_apply_jsonpathvar.sql
Description: application/sql