3 replies

sqlite DEFAULT is not JSON-encoded

When using

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

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

with

.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("")
})

generates:

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

generates nothing:

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

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

(should be

'[]'

'[]'

)

Drizzle Team•3y ago•

3 replies

ShiroDev

sqlite DEFAULT is not JSON-encoded

When using

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

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

with

.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("")
})

generates:

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

generates nothing:

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

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

(should be

'[]'

'[]'

)

sqlite DEFAULT is not JSON-encoded

Similar Threads

sqlite DEFAULT is not JSON-encoded

Similar Threads

Similar Threads

Similar Threads