Many-to-many relation started silently failing to perform joins

Hi Prisma team!

My jaw has dropped to the floor. I've a critical problem with the ORM. Many-to-many relations are not joining.

As you can see in the code snippet below the query fetches a row and joins the "rawRequirements". There are 311 relations. The count is correct. The join is not working.

No I can't reproduce this issue in a fresh repo. I assume this problem is caused by upgrading prisma?

const requirements = await prisma.universityProgramRequirement.findUnique(
  {
    where: { id: "Engelska 6" },
    select: {
      id: true,
      _count: {
        select: {
          rawRequirements: true,
        },
      },
      rawRequirements: {
        select: {
          id: true,
        },
      },
    },
  },
);
console.log(requirements);

const requirements = await prisma.universityProgramRequirement.findUnique(
  {
    where: { id: "Engelska 6" },
    select: {
      id: true,
      _count: {
        select: {
          rawRequirements: true,
        },
      },
      rawRequirements: {
        select: {
          id: true,
        },
      },
    },
  },
);
console.log(requirements);

const requirements = await prisma.universityProgramRequirement.findUnique(
  {
    where: { id: "Engelska 6" },
    select: {
      id: true,
      _count: {
        select: {
          rawRequirements: true,
        },
      },
      rawRequirements: {
        select: {
          id: true,
        },
      },
    },
  },
);
console.log(requirements);

const requirements = await prisma.universityProgramRequirement.findUnique(
  {
    where: { id: "Engelska 6" },
    select: {
      id: true,
      _count: {
        select: {
          rawRequirements: true,
        },
      },
      rawRequirements: {
        select: {
          id: true,
        },
      },
    },
  },
);
console.log(requirements);

model UniversityRawRequirements {
  id String @id @default(cuid())

  programs        UniversityProgram[]
  rawRequirements String                          @unique
  requirements    UniversityProgramRequirement[]
  source          UniversityRawRequirementsSource
  status          UniversityRawRequirementsStatus
}

model UniversityProgramRequirement {
  id String @id

  name            String
  description     String?
  rawRequirements UniversityRawRequirements[]

  @@index([name])
}

model UniversityRawRequirements {
  id String @id @default(cuid())

  programs        UniversityProgram[]
  rawRequirements String                          @unique
  requirements    UniversityProgramRequirement[]
  source          UniversityRawRequirementsSource
  status          UniversityRawRequirementsStatus
}

model UniversityProgramRequirement {
  id String @id

  name            String
  description     String?
  rawRequirements UniversityRawRequirements[]

  @@index([name])
}

model UniversityRawRequirements {
  id String @id @default(cuid())

  programs        UniversityProgram[]
  rawRequirements String                          @unique
  requirements    UniversityProgramRequirement[]
  source          UniversityRawRequirementsSource
  status          UniversityRawRequirementsStatus
}

model UniversityProgramRequirement {
  id String @id

  name            String
  description     String?
  rawRequirements UniversityRawRequirements[]

  @@index([name])
}

model UniversityRawRequirements {
  id String @id @default(cuid())

  programs        UniversityProgram[]
  rawRequirements String                          @unique
  requirements    UniversityProgramRequirement[]
  source          UniversityRawRequirementsSource
  status          UniversityRawRequirementsStatus
}

model UniversityProgramRequirement {
  id String @id

  name            String
  description     String?
  rawRequirements UniversityRawRequirements[]

  @@index([name])
}

Many-to-many relation started silently failing to perform joins

Similar Threads

Similar Threads

Similar Threads