JSON target types only accept strings or numbers, found: {"latitude":null,"longitude":null}

[i-am-dev-Siddhesh]

Hi Prisma Team! My Prisma Client just crashed. This is the report:

Versions

Name	Version
Node	v16.20.0
OS	windows
Prisma Client	4.14.1
Query Engine	d9a4c5988f480fa576d43970d5a23641aa77bc9c
Database	postgresql

Logs

prisma:tryLoadEnv Environment variables loaded from E:\Mobile app\Bazaar\.env
prisma:client checkPlatformCaching:postinstall 
prisma:client checkPlatformCaching:ciName 
prisma:tryLoadEnv Environment variables loaded from E:\Mobile app\Bazaar\.env
prisma:client dirname E:\Mobile app\Bazaar\node_modules\.prisma\client
prisma:client relativePath ..\..\..\prisma
prisma:client cwd E:\Mobile app\Bazaar\prisma
prisma:client protocol graphql
prisma:client clientVersion 4.14.1
prisma:client clientEngineType library
prisma:client:libraryEngine internalSetup
prisma:client:libraryEngine:loader Searching for Query Engine Library in E:\Mobile app\Bazaar\node_modules\.prisma\client
prisma:client:libraryEngine:loader loadEngine using E:\Mobile app\Bazaar\node_modules\.prisma\client\query_engine-windows.dll.node
prisma:client:libraryEngine library starting
prisma:client:libraryEngine library started
prisma:client:libraryEngine sending request, this.libraryStarted: true

Client Snippet

export const fetchData= async (req: Request, res: Response) => {
  try {
    const items = await prisma.cattle.findMany({
      where: {
        location: {
          gte: {
            latitude: 12.34,
            longitude: 56.78,
          },
          lte: {
            latitude: 90.12,
            longitude: 180.34,
          },
        },
      },
    });

...reso logic
  } catch (error: any) {
    ...throw logic
  }
};

Schema

model test{
  id    Int     @id @default(autoincrement())

location Json
  createdAt  DateTime           @default(now())
  updatedAt  DateTime?          @updatedAt
} 

Prisma Engine Query

 const items = await prisma.test.findMany({
      where: {
        location: {
          gte: {
            latitude: 12.34,
            longitude: 56.78,
          },
          lte: {
            latitude: 90.12,
            longitude: 180.34,
          },
        },
      }
      ,
    });

[millsp]

Hey @i-am-dev-Siddhesh thanks for the report. Would you mind trying on the latest version? Thanks.

[millsp]

(Possibly related issue/domain in the past #10836)

[millsp]

Hey, I forwarded this internally, and my colleague suggested that you re-write your query as the following:

where: {
  AND: [
    { json: { path: ["latitude"], gte: 12.34 } },
    { json: { path: ["latitude"], lte: 90.12 } },
    { json: { path: ["longitude"], gte: 56.78 } },
    { json: { path: ["longitude"], lte: 180.34 } },
  ]
}

Because you are currently comparing two objects (json object >= json object), which might not be what you want.

[i-am-dev-Siddhesh]

Hey @i-am-dev-Siddhesh thanks for the report. Would you mind trying on the latest version? Thanks.

Yes. I'm

[i-am-dev-Siddhesh]

comparing two objects (json object >= json object), w

Anyways Currently I moved the lat and long from json to int in db which cause some changes in flow.
Thanks for your help.