json_object returns buffer, not parsed to js object

[Enakers]

Hi,

I may be misunderstanding however I thought the mysql2 driver did the parsing of the returned query? when I do a json_object query a buffer is returned instead of the js object

psuedo code:

const [result] = await pool.query("SELECT something, (SELECT json_object('name', obj.name) FROM (SELECT name FROM person WHERE name = ?) as obj) as person FROM atable WHERE field = condition", "the name");

console.log(result[0]);
/*
{
 something: 'value',
 person: <buffer 22 74 ...>
*/

Am I misunderstanding or doing something wrong?

thanks.

[sidorares]

@Enakers could you check what is the type of json field returned by the server? E.g output of

const [rows, columns] = await pool.query("SELECT something, (SELECT json_object('name', obj.name) FROM (SELECT name FROM person WHERE name = ?) as obj) as person FROM atable WHERE field = condition", "the name");

console.log(columns)