Unable to set any array while using Prisma datasource

nlk-jan · May 2, 2023, 10:32am

We are unable to set arrays defined in Prisma schema.
this doesn’t work for any type ie. String or enum MyEnumType arrays.

we found similar reference to this error in public

github.com/prisma/prisma

MongoDB embedding shows a wrong error type

opened 01:15PM - 19 Jun 22 UTC

indicozy

bug/1-unconfirmed kind/bug tech/typescript topic: runtime-validation team/client topic: mongodb

### Bug description I've decided to try embedding mongodb documents with the [n…ew update](https://www.mongodb.com/community/forums/t/prisma-orm-odm-v3-10-0-adds-support-for-embedded-documents/149381), however, when the transaction cannot pass the error shows the wrong error type. The error was in the different type of mutation data and the schema's type, however, the error shows that it cannot find the document that I'm trying to create. ### How to reproduce  1. Install prisma with mongodb with the schema described below. 2. Create new document with mutation: ```js prisma.submission.create( { data: { studentId: '62af1f5934486d50e3167535', blockId: '62af1f05f03ee66298116424', data: { dataCode: { ~~~~~~~~ code: 'x = 10', codeOutput: { stdout: '10\n', stderr: '', status: 1 // here it should be true, not 1 } } }, success: true } } ) ``` 3. Get error: ```js error - Error: Invalid `prisma.submission.create()` invocation: { data: { studentId: '62af1f5934486d50e3167535', blockId: '62af1f05f03ee66298116424', data: { dataCode: { ~~~~~~~~ code: 'x = 10', codeOutput: { stdout: '10\n', stderr: '', status: 1 // here it should be true, not 1 } } }, success: true } } Unknown arg `dataCode` in data.data.dataCode for type SubmissionDataCreateEnvelopeInput. Did you mean `set`? Available args: type SubmissionDataCreateEnvelopeInput { set?: SubmissionDataCreateInput } ``` 4. If the type of the `status` is the same as in schema (`Boolean`), everything works fine. ### Expected behavior It should give a different error, not `Unknown arg 'dataCode' in ...`. It should to be that the variable has a different type in the embedded document. ### Prisma information ## Prisma library: ```js import { PrismaClient } from '@prisma/client'; // eslint-disable-next-line import/no-mutable-exports let prisma; if (process.env.NODE_ENV === 'production') { prisma = new PrismaClient(); } else { if (!global.prisma) { global.prisma = new PrismaClient(); } prisma = global.prisma; } // Some non-related middleware export default prisma; ``` ## Schema snippet: ```prisma model Submission { id String @id @default(auto()) @map("_id") @db.ObjectId // createdAt DateTime @default(now()) // updatedAt DateTime @updatedAt // student Student @relation(fields: [studentId], references: [id]) // studentId String @db.ObjectId // block Block @relation(fields: [blockId], references: [id]) // blockId String @db.ObjectId data SubmissionData success Boolean // @@unique([studentId, blockId]) } type SubmissionData { dataQuiz SubmissionQuiz? dataCode SubmissionCode? } type SubmissionQuiz { guess Json } type SubmissionCode { code String codeOutput CodeOutput } ``` unused 'columns' were commented out. ### Environment & setup - OS: OpenSUSE Tumbleweed - Database: MongoDB - Node.js version: v16.15.0 ### Prisma Version ``` prisma : 3.15.1 @prisma/client : 3.15.1 Current platform : debian-openssl-1.1.x Query Engine (Node-API) : libquery-engine 461d6a05159055555eb7dfb337c9fb271cbd4d7e (at node_modules/.pnpm/@prisma+engines@3.15.1-1.461d6a05159055555eb7dfb337c9fb271cbd4d7e/node_modules/@prisma/engines/libquery_engine-debian-openssl-1.1.x.so.node) Migration Engine : migration-engine-cli 461d6a05159055555eb7dfb337c9fb271cbd4d7e (at node_modules/.pnpm/@prisma+engines@3.15.1-1.461d6a05159055555eb7dfb337c9fb271cbd4d7e/node_modules/@prisma/engines/migration-engine-debian-openssl-1.1.x) Introspection Engine : introspection-core 461d6a05159055555eb7dfb337c9fb271cbd4d7e (at node_modules/.pnpm/@prisma+engines@3.15.1-1.461d6a05159055555eb7dfb337c9fb271cbd4d7e/node_modules/@prisma/engines/introspection-engine-debian-openssl-1.1.x) Format Binary : prisma-fmt 461d6a05159055555eb7dfb337c9fb271cbd4d7e (at node_modules/.pnpm/@prisma+engines@3.15.1-1.461d6a05159055555eb7dfb337c9fb271cbd4d7e/node_modules/@prisma/engines/prisma-fmt-debian-openssl-1.1.x) Default Engines Hash : 461d6a05159055555eb7dfb337c9fb271cbd4d7e Studio : 0.462.0 ```

nlk-jan · May 2, 2023, 10:36am

WG error:
The current database provider doesn’t support a feature that the query used: Unhandled and unsupported value mapping for MongoDB
"error_code":"P2026"}}]}"}

{"component": "@wundergraph/wunderctl", "component": "@wundergraph/node", "request": "{\"query\":\"mutation{FE_createOneUserSgUi: createOneUserSgUi(data: {tenantUid: {set: {tenantUid: \\\"222222\\\"}},loginId: \\\"11111\\\",solutionGraphUid: {set: {solutionGraphUid: \\\"5beea202-9a35-4bb5-a64a-cf3baf48f2ce\\\"}},menuBarContext: {set:{neSolutionGraphAreas:{set:[\\\"INTENT\\\",\\\"OBJECT\\\"]},neSelectedCanvas:\\\"GRAPH_CANVAS\\\",neDefaultNodeStyling:\\\"DESIGNER\\\",neDesignerNodeStyling:{set:[\\\"IMAGE\\\",\\\"LABEL\\\"]},neDisplayLanguage:{countryIsoCode:\\\"US\\\",languageIsoCode:\\\"EN\\\",languageDisplayName:\\\"ENGLISH\\\"},neAppMode:\\\"AAA\\\",sgBranchSelectionId:{sgBranchId:\\\"BR111\\\"},sgBranchSelectionName:\\\"BBBB\\\",sgVersionSelectionId:{sgVersionId:\\\"1001\\\"},sgOptionSelectionId:{sgOptionId:\\\"555555\\\"},sgSoidSelectionIndex:0,sgSoidSelectionName:\\\"A\\\",sgOptionSelectionName:\\\"SP\\\"}},,,,}){menuBarContext {neSolutionGraphAreas neSelectedCanvas neDefaultNodeStyling neDesignerNodeStyling neDisplayLanguage {countryIsoCode languageIsoCode languageDisplayName} neAppMode sgBranchSelectionId {sgBranchId} sgBranchSelectionName sgVersionSelectionId {sgVersionId} sgOptionSelectionId {sgOptionId} sgSoidSelectionIndex sgSoidSelectionName sgOptionSelectionName}}}\",\"variables\":{}}", "response": "{\"errors\":[{\"error\":\"Error occurred during query execution:\\nConnectorError(ConnectorError { user_facing_error: Some(KnownError { message: \\\"The current database provider doesn't support a feature that the query used: Unhandled and unsupported value mapping for MongoDB: { \\\\\\\"set\\\\\\\": [Enum(\\\\\\\"INTENT\\\\\\\"), Enum(\\\\\\\"OBJECT\\\\\\\")] } as Enum(\\\\\\\"SolutionGraph\\\\\\\").\\\", meta: Object({\\\"feature\\\": String(\\\"Unhandled and unsupported value mapping for MongoDB: { \\\\\\\"set\\\\\\\": [Enum(\\\\\\\"INTENT\\\\\\\"), Enum(\\\\\\\"OBJECT\\\\\\\")] } as Enum(\\\\\\\"SolutionGraph\\\\\\\").\\\")}), error_code: \\\"P2026\\\" }), kind: UnsupportedFeature(\\\"Unhandled and unsupported value mapping for MongoDB: { \\\\\\\"set\\\\\\\": [Enum(\\\\\\\"INTENT\\\\\\\"), Enum(\\\\\\\"OBJECT\\\\\\\")] } as Enum(\\\\\\\"SolutionGraph\\\\\\\").\\\") })\",\"user_facing_error\":{\"is_panic\":false,\"message\":\"The current database provider doesn't support a feature that the query used: Unhandled and unsupported value mapping for MongoDB: { \\\"set\\\": [Enum(\\\"INTENT\\\"), Enum(\\\"OBJECT\\\")] } as Enum(\\\"SolutionGraph\\\").\",\"meta\":{\"feature\":\"Unhandled and unsupported value mapping for MongoDB: { \\\"set\\\": [Enum(\\\"INTENT\\\"), Enum(\\\"OBJECT\\\")] } as Enum(\\\"SolutionGraph\\\").\"},\"error_code\":\"P2026\"}}]}"}

jensneuse · May 2, 2023, 10:36am

Thank you for reporting.
Can you give us some steps or a simplified version of your Prisma schema to replicate this issue?
I think an abbreviated schema + Operation should be sufficient.

nlk-jan · May 2, 2023, 10:39am

prima schema:

type MenuBarContext {
    neSolutionGraphAreas  SolutionGraph[]          @default([INTENT, OBJECT])
    neSelectedCanvas      Canvas                   @default(GRAPH_CANVAS)
    neDefaultNodeStyling  NodeStyling              @default(DESIGNER)
    // is this correct defaults @Dilip @Raman
    neDesignerNodeStyling DesignerNodeComponents[] @default([PARENT_DIFF_TABLE])
    neDisplayLanguage     Language // composite type
    neAppMode             String?                  @default("")
    sgBranchSelectionId   Brid // composite type
    sgOptionSelectionId   Soid // composite type
}

enum SolutionGraph {
    INTENT
    OBJECT
    PRODUCT
    LOCATION
    ORPHAN
    DELETED
}

enum Canvas {
    GRAPH_CANVAS
    TABLE_CANVAS
}

enum NodeStyling {
    DESIGNER
    ANALYST
}

// is this correct enum considering all changes? @Raman @Dilip
enum DesignerNodeComponents {
    IMAGE
    LABEL
    PARENT_DIFF_TABLE
}

nlk-jan · May 2, 2023, 10:41am

mutation UpdateMenuBarContext (
$solutionGraphUid: String!
$userId: String!
$tenantId: String!
$menuBarContext: FE_MenuBarContextNullableCreateEnvelopeInput
) {
FE_createOneUserSgUi (
data: {
tenantUid: {
set : {
tenantUid: $tenantId
}
},
loginId: $userId,
solutionGraphUid: {
set: { solutionGraphUid: $solutionGraphUid}
},
menuBarContext: $menuBarContext
}
) {
menuBarContext {
...MenuBarContext
}
}
}
has context menu
Compose

nlk-jan · May 2, 2023, 10:42am

{
"solutionGraphUid": "5beea202-9a35-4bb5-a64a-cf3baf48f2ce",
"userId": "11111",
"tenantId": "222222",
"menuBarContext" :{
"set": {
"neSolutionGraphAreas": {
"set": ["INTENT", "OBJECT"]
},
"neSelectedCanvas": "GRAPH_CANVAS",
"neDefaultNodeStyling": "DESIGNER",
"neDesignerNodeStyling": {
"set": ["IMAGE", "LABEL"]
},
"neDisplayLanguage": {
"countryIsoCode": "US",
"languageIsoCode": "EN",
"languageDisplayName": "ENGLISH"
},
"neAppMode": "AAA",
"sgBranchSelectionId": {
"sgBranchId": "BR111"
},
"sgBranchSelectionName": "BBBB",
"sgVersionSelectionId": {
"sgVersionId": "1001"
},
"sgOptionSelectionId": {
"sgOptionId": "555555"
},
"sgSoidSelectionIndex": 0,
"sgSoidSelectionName": "A",
"sgOptionSelectionName": "SP"
}
}
}
has context menu

nlk-jan · May 2, 2023, 10:47am

Please let me know if you need more information.