prisma: Prisma Client upsert returns count instead of data

Bug description

When using the upsert method to do a findOrCreate implementation, count: { 1 } is returned rather than the data itself.

How to reproduce

Using the following code returns count rather than the user object

const user = await prisma.user.upsert({
  where: { email: emails[0].value },
  update: { lastLoggedIn: new Date() },
  create: {
    email: emails[0].value,
    name: displayName,
    avi: photos[0].value,
    profile: {
      create: {
        name: displayName,
        avi: photos[0].value,
        email: emails[0].value,
      },
    },
  },
});

console.log({ user });

Expected behavior

I expect the user’s data to be returned.

Prisma information

model User {
  id           String   @id @default(uuid())
  email        String   @unique
  name         String
  avi          String?
  createdAt    DateTime @default(now())
  updatedAt    DateTime @updatedAt
  lastLoggedIn DateTime @default(now())

  log           Log[]
  items         Item[]
  rsvps         Rsvp[]   @relation("rsvp_user")
  createdEvents Event[]  @relation(name: "created_event")
  profile       Profile? @relation("profile_user")
}

Environment & setup

OS: Mac OS
Database: MySQL
Node.js version: v14.17.3

Prisma Version

prisma                  : 3.6.0
@prisma/client          : 3.7.0

About this issue

Original URL
State: closed
Created 2 years ago
Reactions: 7
Comments: 42 (17 by maintainers)

Most upvoted comments

yup! CleanShot 2022-01-25 at 10 22 04@2x

nkrekow on Jan 25, 2022

Yes

uvalus on Jan 25, 2022

We’re also experiencing this issue in production with v3.8.1. It was working fine on v3.5.0.

I can share my schema privately if it would help.

flybayer on Jan 21, 2022

Can also confirm this; using PlanetScale on production but also happens locally with MySQL Returns fine if the identifier doesn’t exist, but if it does it just returns {"count": number}

datasource db {
  provider             = "mysql"
  url                  = env("DATABASE_URL")
  referentialIntegrity = "prisma"
}

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["referentialIntegrity", "interactiveTransactions"]
}

ponei on Apr 21, 2022

@janpio, I can confirm that the reproduction reproduces. Is it helpful?

cdinu on Mar 28, 2022

Oh sorry, I missed that it was you who posted that - this way my message of course does not make a lot of sense. We did not have the time to appraoch that reproduction yet unfortunately. If anyone else can confirm the reproduction reproduces, that would be helpful.

janpio on Mar 13, 2022

Can you help us get to a reproduction then @ramiel? What is different in your project vs. what we already spent considerable amount of time trying to reproduce above?

Sorry, I missed this comment one week ago. I’ll try to create a reproducible repo or something

ramiel on Feb 24, 2022

Also using Planetscale

flybayer on Jan 25, 2022

Can confirm, I am using PlanetScale as well

uvalus on Jan 25, 2022

@pantharshit00 this is on PlanetScale and it looks like they’re using mysql version 8.0.23

nkrekow on Jan 25, 2022