Raw query returning a bigint for an int field #24136
Labels
bug/2-confirmed
Bug has been reproduced and confirmed.
kind/bug
A reported bug.
team/client
Issue for team Client.
topic: mysql
topic: raw
$queryRaw(Unsafe) and $executeRaw(Unsafe): https://www.prisma.io/docs/concepts/components/prisma-cli
topic: unsigned
Bug description
When using
prisma.$queryRaw
to query data, columns of theInt.Unsigned
type in MySQL will be converted to and returned as the Bigint type.How to reproduce
Table Structure & Example Data:
Execute the following query:
Returns rows:
Expected behavior
Int.Unsigned is 4-byte (32-bit). According to the documentation, it should return a
Number
type, not aBigInt
.Expected returns rows:
Prisma information
Environment & setup
Prisma Version
The text was updated successfully, but these errors were encountered: