findUnique not excluding when compound key is used

[Georgegriff]

Thank you for this amazing library!

I have a work around for this issue but I thought i'd post to check if there is a potential bug:

I'd expect to not have to specify deletedAt

Example not working

  const collaboration = await ctx.prisma.collaborator.findUnique({
    where: {
      userId_planId: {
        userId: userId,
        planId: planId,
      },
    },
    select: {
      planAccessType: true,
    },
  });

It works when i do this

  const collaboration = await ctx.prisma.collaborator.findUnique({
    where: {
      userId_planId: {
        userId: userId,
        planId: planId,
      },
      deletedAt: null,
    },
    select: {
      planAccessType: true,
    },
  });

Here is my configuration:

  const extendedClient = client.$extends(
    createSoftDeleteExtension({
      models: {
        Collaborator: true,
      },
      defaultConfig: {
        field: "deletedAt",
        createValue: (deleted) => {
          if (deleted) return new Date();
          return null;
        },
      },
    })
  );

[olivierwilkinson]

Hi there,

Thank you for raising this! It's quite likely I need to add a special case for this, I'll look into it soon 😄

I'm glad you are finding the library helpful! Please let me know if you find any other issues or have any feedback 👍