RecordDoesNotExist Comeback!

[yovanoc]

Hello today I see that in the prisma2@2.0.0-alpha.293, binary version: 54c4d8ce690254b5d0c77a21361896a6ca3fc4b7 we have a comeback from the findOne method of the old

instead of returning null :/

[pantharshit00]

I can confirm this regression.

(Original feature issue: prisma/prisma-client-js#245)

[janpio]

Reproduction in prisma/prisma-client-js#245 (comment)

[timsuchanek]

Fixed in https://github.com/prisma/prisma2/releases/tag/2.0.0-preview016.2

[dpetrick]

Fixed in the query-engine as well now, we can remove the Photon workarounds with preview 17.

[tvvignesh]

I am not sure why, but I am getting this error. To test, I ran 2 queries against database with no records.

This works (with findMany):

photon.userAuthentications.findMany({
            where: {
              email: "test@xyz.com",
              mobile: "123456789"
            },
            select: {
                id: true,
                local: true,
                username: true,
                email: true,
                mobile: true,
                status: true,
                password: true
            }
        });

This does not (with findOne) - It just says error in Photon:

photon.userAuthentications.findOne({
            where: {
              email: "test@xyz.com"
            },
            select: {
                id: true,
                local: true,
                username: true,
                email: true,
                mobile: true,
                status: true,
                password: true
            }
        });

When I open the details of the error, it says:

Cannot convert undefined or null to object

My Schema:

model UserAuthentication {
    id                String   @default(cuid()) @id
    email             String   @unique
    mobile            String?  @unique
    local             String
    username          String   @unique
    password          String?
    facebook          String?
    google            String?
    github            String?
    microsoft         String?
    amazon            String?
    status            String
    connectedAccounts String[]
    metadata          String?
    tagIDList         String[]
    createdDate       DateTime @default(now())
    updatedDate       DateTime @updatedAt
}

Prisma2 version: prisma2@2.0.0-preview018.2, binary version: 3c4da1d6caa0c40a0210a346ec982c77f74e18c7