Example: Error - Combine Two JSON ARRAYs and State the Result Is a JSON OBJECT - Advanced SQL Engine - Teradata Database

The example specifies the 'OBJECT' parameter; however, the data being combined are both JSON array instances, so the result must be a JSON ARRAY. This example results in an error because 'OBJECT' was specified.

/*Error case*/

SELECT edata.Combine(edata2, 'OBJECT') FROM my_table WHERE eno=3;