3 replies

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()

.varchar().array().array()

or a

.jsonb()

.jsonb()

field. The error is:

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

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

Drizzle Team•15mo ago•

3 replies

dafky2000

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()

.varchar().array().array()

or a

.jsonb()

.jsonb()

field. The error is:

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

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

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

Similar Threads

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

Similar Threads

Similar Threads

Similar Threads