test(cli): fix limited role creation in integration test

Nik Samokhvalov · Nik Samokhvalov · commit 74de2861bfc7 · 2025-12-13T10:01:44.000-08:00
- Avoid dynamic EXECUTE with nested quotes

- Use exception handler for duplicate_object
diff --git a/cli/test/init.integration.test.cjs b/cli/test/init.integration.test.cjs
@@ -256,7 +256,11 @@ test("integration: init reports nicely when lacking permissions", { skip: !haveP
     await c.connect();
     await c.query(`do $$ begin
       if not exists (select 1 from pg_roles where rolname='limited') then
-        execute 'create role limited login password ${sqlLiteral(limitedPw)}';
+        begin
+          create role limited login password ${sqlLiteral(limitedPw)};
+        exception when duplicate_object then
+          null;
+        end;
       end if;
     end $$;`);
     await c.query("grant connect on database testdb to limited");
