Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

malformed array literal #377

Open
i8ramin opened this issue Apr 24, 2024 · 1 comment
Open

malformed array literal #377

i8ramin opened this issue Apr 24, 2024 · 1 comment

Comments

@i8ramin
Copy link

i8ramin commented Apr 24, 2024

The latest version of drizzle-kit studio throws a "malformed array literal" error when trying to save array values in a jsonb column (this did not happen in a previous version)

worked in
"drizzle-kit": "^0.20.14"

broken in
"drizzle-kit": "^0.20.17"

column causing the error in schema:

strategies: text('strategies').array(),

value input which throws the eror:

["foo","bar"]

Details about the error in console logs:

  length: 223,
  severity: 'ERROR',
  code: '22P02',
  detail: '"[" must introduce explicitly-specified array dimensions.',
  hint: undefined,
  position: undefined,
  internalPosition: undefined,
  internalQuery: undefined,
  where: "unnamed portal parameter $1 = '...'",
  schema: undefined,
  table: undefined,
  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: 'arrayfuncs.c',
  line: '272',
  routine: 'array_in'
@i8ramin
Copy link
Author

i8ramin commented Apr 24, 2024

It looks like the following syntax works

{amazon_rainforest:api,diffbot:analyze}

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant