Consider the following relations: <div class="highlight highlight-source-sql notra

This is fixed by merging <a class="user-mention notranslate" data-hovercard-type="user

i can confirm the bug and also that <a class="user-mention notranslate" data-hovercard

Hello I confirm this issue My Table <div class="highlight highli

deleteBy creates a syntax error about postgraphile-plugin-nested-mutations HOT 3 CLOSED

mlipscombe commented on June 15, 2024 1

deleteBy creates a syntax error

from postgraphile-plugin-nested-mutations.

Comments (3)

mlipscombe commented on June 15, 2024 1

This is fixed by merging @phryneas PR #24. I'll be pushing a new release to npm later today.

from postgraphile-plugin-nested-mutations.

frisi commented on June 15, 2024

i can confirm the bug and also that @phryneas PR #24 solves the issues.

from postgraphile-plugin-nested-mutations.

AndresGnu commented on June 15, 2024

Hello I confirm this issue

My Table

CREATE TABLE "public"."app_permissions" (
  "id" bigserial PRIMARY KEY,
  "table_id" character varying(80) REFERENCES "public"."tables",
  "action" enum_crud,
  "group" character varying(40),
  "created_at" timestamp with time zone DEFAULT NOW(),
  "updated_at" timestamp with time zone,
  "deleted_at" timestamp with time zone
);
ALTER TABLE "public"."app_permissions"
  ADD CONSTRAINT "u_table_action_group_key" UNIQUE ("table_id", "action", "group");

table_id is ForeignKey
I have:

mutation{
  updateTableById(,input:{
    id:"BkBank",
    patch:{
      appPermissionsUsingId:{
         deleteByTableIdAndActionAndGroup:{
          group: "fastcont-sellers",
          action: C,
          tableId:"BkBank"
        }
      }
    }
  }){
    table{
      id
    }
  }
}

Response is:

{
  "errors": [
    {
      "message": "syntax error at or near \")\"",
      "locations": [
        {
          "line": 2,
          "column": 3
        }
      ],
      "path": [
        "updateTableById"
      ]
    }
  ],
  "data": {
    "updateTableById": null
  }
}