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
