Error when using "multiSchema" with custom database schema and implicit Many To Many relation

[leidison]

Bug description

I coded a ManyToMany relationship between Organization and Repository entities, with the custom schema called "organization". However, when trying to connect a Repository in Organization, the following error occurs:

[Nest] 2119  - 12/13/2022, 12:14:13 AM   ERROR [ExceptionsHandler] 
Invalid `prisma.organization.create()` invocation in
/workspace/app/src/services/organization/organization.service.ts:31:50

  28   },
  29 });
  30 
  31 const organization = await prisma.organization.create(
The table `public._OrganizationToRepository` does not exist in the current database.
Error: 
Invalid `prisma.organization.create()` invocation in
/workspace/app/src/services/organization/organization.service.ts:31:50

  28   },
  29 });
  30 
  31 const organization = await prisma.organization.create(
The table `public._OrganizationToRepository` does not exist in the current database.
    at RequestHandler.handleRequestError (/workspace/app/node_modules/@prisma/client/runtime/index.js:34869:13)
    at RequestHandler.handleAndLogRequestError (/workspace/app/node_modules/@prisma/client/runtime/index.js:34841:12)
    at RequestHandler.request (/workspace/app/node_modules/@prisma/client/runtime/index.js:34836:12)
    at PrismaService._request (/workspace/app/node_modules/@prisma/client/runtime/index.js:35926:16)
    at /workspace/app/src/services/organization/organization.service.ts:31:28
    at Proxy._transactionWithCallback (/workspace/app/node_modules/@prisma/client/runtime/index.js:35858:18)
    at OrganizationService.create (/workspace/app/src/services/organization/organization.service.ts:16:12)
    at /workspace/app/node_modules/@nestjs/core/router/router-execution-context.js:46:28
    at Object.<anonymous> (/workspace/app/node_modules/@nestjs/core/router/router-proxy.js:9:17)

How to reproduce

1. Go to prisma schema
2. Create ManyToMany relation, with @@Schema("organization")
3. Create a object with prisma create method
4. Create another object with prisma create method, using connect to bind object created on step 3
5. Run your application
6. See error

The table public._OrganizationToRepository does not exist in the current database.

Expected behavior

The correct thing would be to use the "organization" schema. But, the "public" schema was used.

Prisma information

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["multiSchema"]
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
  schemas  = ["organization", "security"]
}

model Organization {
  id           String       @id @default(uuid())
  name     String
  //
  repositories Repository[]
  //

  @@schema("organization")
}

model Repository {
  id            BigInt         @id @default(autoincrement())
  name      String
  //
  organizations Organization[]

  @@schema("organization")
}

const repository = await prisma.repository.create({
  data: {
    name: 'Repository 1',
  },
});

const organization = await em.organization.create({
  data: {
    name: 'Organization 1',
    repositories: {
      // exception throw here
      connect: {
        id: repository.id,
      },
    },
  },
});

Environment & setup

• OS: Ubuntu 20.04
• Database: PostgreSQL
• Node.js version: v18.12.1

Prisma Version

prisma                  : 4.7.1
@prisma/client          : 4.7.1
Current platform        : debian-openssl-1.1.x
Query Engine (Node-API) : libquery-engine 272861e07ab64f234d3ffc4094e32bd61775599c (at node_modules/@prisma/engines/libquery_engine-debian-openssl-1.1.x.so.node)
Migration Engine        : migration-engine-cli 272861e07ab64f234d3ffc4094e32bd61775599c (at node_modules/@prisma/engines/migration-engine-debian-openssl-1.1.x)
Introspection Engine    : introspection-core 272861e07ab64f234d3ffc4094e32bd61775599c (at node_modules/@prisma/engines/introspection-engine-debian-openssl-1.1.x)
Format Binary           : prisma-fmt 272861e07ab64f234d3ffc4094e32bd61775599c (at node_modules/@prisma/engines/prisma-fmt-debian-openssl-1.1.x)
Format Wasm             : @prisma/prisma-fmt-wasm 4.7.1-1.272861e07ab64f234d3ffc4094e32bd61775599c
Default Engines Hash    : 272861e07ab64f234d3ffc4094e32bd61775599c
Studio                  : 0.477.0
Preview Features        : multiSchema