Hi Jian,
I reviewed and tested patch v2 .
Before applying the patch JSON_TABLE accepted only literal top-level
patch string such as '$.a' and rejected equivalent path expression
such as '$'||.'a' with:
ERROR :only string constants are supported in JSON_TABLE path specification
After applying the patch ,JSON_TABLE correctly accepts path
expressions and returns the expected results.
I verified cases using string concatenation (e.g. '$' || '.a' and '$'
|| '.' || 'a'),,while existing behavior with literal path strings
remained unchanged.
I also confirmed that JSON_QUERY already accepts such patch
expressions,so the patch makes JSON_TABLE behavior more consistent
with other SQL/JSON functions.
The patch applied successfully and tested queries behaved as expected.
Thanks for working on this improvement.
Regards
Solai
