Prisma stored procedure call does not returns keys

Viewed 12

I have a stored procedure in mysql which does a select query against some tables. I am executing this stored procedure using prisma raw querycall producer_name(${input}). Response from prisma does not have key name instead it look like this

[{
f0: 123,
f1: "fistname",
f2: "lastname"
}]

Instead of field name I am getting f0, f1 & f2 etc. Is this the internal design of prisma, or am I doing anything wrong here.

I am using prisma client 3.10.0 I have executed this and found the same issue. below is the response I got from the prisma client

[
    {
        "f0": 1,
        "f1": "first name",
        "f2": "last_name"
    }
]

and query is

prisma.$queryRaw`call db_schema_name.test_procedure();`
0 Answers
Related