Drizzle Team•2mo ago

malformed array literal when trying to insert a 2d array of strings

I am getting this error when trying to insert a 2d array of string into a .varchar().array().array() or a .jsonb() field. The error is:

An internal error occurred.: malformed array literal: \"[[\"saddas\",\"dasdsad\",\"dadad\",\"sdasda\"],[\"123213\",\"1321312\",\"1231313\"],[\"111111111\"],[\"aaaaaaaaa\"]]\"

It seems to me that drizzle is converting this array of arrays into this invalid serialized string. When I use .jsonb column type, the above is the error, when I use the varchar().array().array() I get the same error but with curly braces instead of square brackets. Pulling my hair out to figure out why this is isn't working as expected and I'm out of options. Thank you in advance 🙂

1 Reply

dafky2000OP•2mo ago

"drizzle-kit": "^0.28.1", "drizzle-orm": "^0.36.3" And... It's on a postgresql db using import { drizzle } from "drizzle-orm/node-postgres"; Ended up (temporarily) solving this by manually creating the sql array and inserting that. I don't think this is a permanent solution because it opens up sql-injection risks. Hopefully it might help someone else with a temporary solution.

const sqlFrom2DArray = (arr: string[][]) => {
  return sql`array[${sql.join(
    arr.filter(a => a).map((subArray) => sql`[${sql.join(
      subArray.filter(s => s).map((item) => sql.raw(`'${item}'`)), sql`, `
    )}]`),
    sql`, `
  )}]::varchar[]`;
}

const sqlFrom2DArray = (arr: string[][]) => {
  return sql`array[${sql.join(
    arr.filter(a => a).map((subArray) => sql`[${sql.join(
      subArray.filter(s => s).map((item) => sql.raw(`'${item}'`)), sql`, `
    )}]`),
    sql`, `
  )}]::varchar[]`;
}

Gaming

Programming

malformed array literal when trying to insert a 2d array of strings