0

I got issues that cannot resolve, I have sql query that when add semicolon its error. here my query:

INSERT INTO engine_migrations ("name", "description", "schema", "created_at", "up", "down", "active")
VALUES (
    'Create Table users',
    'undefined',
    '{"resource":"Table","migration":{"name":"users","primaryKey":"SERIAL"},"operation":"Create"}',
    '2023-08-18T09:40:49.55656Z',
    '',
    'DELETE FROM "public"."engine_tables" WHERE name = ''users'';DROP TABLE "public"."users";',
    true
);

return like this

`unterminated quoted string at or near "'delete from "public."engine_tables" where name = ''users''"

this is what I found. when remove ;DROP TABLE "public"."users"; its working fine. but I cannot remove it since required.

Dicky Raambo
  • 531
  • 2
  • 14
  • 28
  • Cannot reproduce (https://www.db-fiddle.com/f/fkQ1dzpZgnoNF8stEyGJx3/1). The problem would seem to be on your client side, which you haven't specified, or in some other part of the code you haven't shown. – jjanes Aug 18 '23 at 14:02
  • @jjanes yeah its to difficult. gonna skip this. thanks – Dicky Raambo Aug 28 '23 at 09:28

0 Answers0