SyntaxError: Bad control character in string literal in JSON

[miles-kt-inkeep]

When updating a jsonb column to include a string with newlines I get the error: SyntaxError: Bad control character in string literal in JSON

Env

  "dependencies": {
    "drizzle-kit": "^0.31.7",
    "drizzle-orm": "^0.44.7",
    "pg": "^8.16.3",
    "tsx": "^4.20.6"
  },
  "devDependencies": {
    "@types/pg": "^8.15.6"
  }

Drizzle Schema

import { drizzle } from 'drizzle-orm/node-postgres';
import { Pool } from 'pg';
import { jsonb, pgTable, varchar } from 'drizzle-orm/pg-core';
import { eq, sql } from 'drizzle-orm';


  const testTable = pgTable('jsonb_test', {
    id: varchar('id', { length: 256 }).notNull().primaryKey(),
    jsonbColumn: jsonb('jsonb_column').$type<{ test: string }>(),
  });

Example

   // succeeds
    await db.insert(testTable).values({
        id: 'test',
        jsonbColumn: { test: 'value\n' },
    });

    // fails
    await db.update(testTable).set({
        jsonbColumn: { test: 'value\n' },
    }).where(eq(testTable.id, 'test')).returning();

[Hydrocharged]

I've been taking a look into this and running into a few issues with reproducing this in drizzle. I'll talk to @zachmu later today and see how he was able to get it set up on his side

[Hydrocharged]

@zachmu is running into the same issues that I am, so it's possible that we're missing a step to be able to replicate the behavior on our side. Would you mind sharing all of the contents of all files involved, along with the exact commands that were used?

[miles-kt-inkeep]

Here are all the files: https://github.com/miles-kt-inkeep/dolt-example

keep in mind I have the db url set to postgresql://postgres:password@localhost/test_db, so replace with your preferred doltgres url in drizzle.config.ts and test.ts.

I am running the following commands from the root of dolt-example:
pnpm install
pnpm drizzle-kit generate
pnpm drizzle-kit migrate
pnpm tsx test.ts

[Hydrocharged]

Thank you for the repository, I was able to successfully replicate the error and implement a fix. We'll get a release out once this is merged in.