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