Hi, I was experimenting with the v42 patches, and I tried testing without providing the path explicitly. There is one difference between the two test cases that I have highlighted in blue. The full_name column is empty in the second test case result. Let me know if this is an issue or expected behaviour.
*CASE 1:* ----------- SELECT * FROM JSON_TABLE(jsonb '{ "id" : 901, "age" : 30, "*full_name*" : "KATE DANIEL"}', '$' COLUMNS( FULL_NAME varchar(20), ID int, AGE int ) ) as t; *RESULT:* full_name | id | age -------------+-----+----- KATE DANIEL | 901 | 30 (1 row) *CASE 2:* ------------------ SELECT * FROM JSON_TABLE(jsonb '{ "id" : 901, "age" : 30, "*FULL_NAME*" : "KATE DANIEL"}', '$' COLUMNS( FULL_NAME varchar(20), ID int, AGE int ) ) as t; *RESULT:* full_name | id | age -----------+-----+----- | 901 | 30 (1 row) Thanks & Regards, Shruthi K C EnterpriseDB: http://www.enterprisedb.com