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

Reply via email to