sqlite DEFAULT is not JSON-encoded

When using

text("...", { mode: "json" })

text("...", { mode: "json" })

text("...", { mode: "json" })

text("...", { mode: "json" }) with

.default()

.default()

.default()

.default(), the default value is not JSON encoded leading to invalid SQL generation by drizzle-kit.

import { sqliteTable, text } from "drizzle-orm/sqlite-core";

export const table = sqliteTable("table", {
    row: text("row", { mode: "json" }).$type<string>().default("")
})

import { sqliteTable, text } from "drizzle-orm/sqlite-core";

export const table = sqliteTable("table", {
    row: text("row", { mode: "json" }).$type<string>().default("")
})

import { sqliteTable, text } from "drizzle-orm/sqlite-core";

export const table = sqliteTable("table", {
    row: text("row", { mode: "json" }).$type<string>().default("")
})

import { sqliteTable, text } from "drizzle-orm/sqlite-core";

export const table = sqliteTable("table", {
    row: text("row", { mode: "json" }).$type<string>().default("")
})

generates:

CREATE TABLE `table` (
    `row` text DEFAULT ''
);

CREATE TABLE `table` (
    `row` text DEFAULT ''
);

CREATE TABLE `table` (
    `row` text DEFAULT ''
);

CREATE TABLE `table` (
    `row` text DEFAULT ''
);

(should be

'""'

'""'

'""'

'""' instead)

Using an empty array

.$type<string[]>().default([])

.$type<string[]>().default([])

.$type<string[]>().default([])

.$type<string[]>().default([]) generates nothing:

CREATE TABLE `table` (
    `row` text DEFAULT 
);

CREATE TABLE `table` (
    `row` text DEFAULT 
);

CREATE TABLE `table` (
    `row` text DEFAULT 
);

CREATE TABLE `table` (
    `row` text DEFAULT 
);

(should be

'[]'

'[]'

'[]'

'[]')

sqlite DEFAULT is not JSON-encoded

Similar Threads

Similar Threads

Similar Threads