2 replies

Using default with `text` json mode creates empty `DEFAULT`

Hi all,

entries: text('entries', { mode: 'json' }).$type<number[]>().default([]),

entries: text('entries', { mode: 'json' }).$type<number[]>().default([]),

results in

CREATE TABLE `User` (
    `id` integer PRIMARY KEY NOT NULL,
    `entries` text DEFAULT ,
    `createdAt` integer DEFAULT CURRENT_TIMESTAMP,
    `updatedAt` integer NOT NULL,
    `lastSyncedAt` integer
);

CREATE TABLE `User` (
    `id` integer PRIMARY KEY NOT NULL,
    `entries` text DEFAULT ,
    `createdAt` integer DEFAULT CURRENT_TIMESTAMP,
    `updatedAt` integer NOT NULL,
    `lastSyncedAt` integer
);

which then throws an error when i try to push to Turso. I suspect it's the empty

entries

entries

default, when i remove all works fine.

Is this expected or show i create a issue on github?

Drizzle Team•2y ago•

2 replies

jpcafe

Using default with `text` json mode creates empty `DEFAULT`

Hi all,

entries: text('entries', { mode: 'json' }).$type<number[]>().default([]),

entries: text('entries', { mode: 'json' }).$type<number[]>().default([]),

results in

CREATE TABLE `User` (
    `id` integer PRIMARY KEY NOT NULL,
    `entries` text DEFAULT ,
    `createdAt` integer DEFAULT CURRENT_TIMESTAMP,
    `updatedAt` integer NOT NULL,
    `lastSyncedAt` integer
);

CREATE TABLE `User` (
    `id` integer PRIMARY KEY NOT NULL,
    `entries` text DEFAULT ,
    `createdAt` integer DEFAULT CURRENT_TIMESTAMP,
    `updatedAt` integer NOT NULL,
    `lastSyncedAt` integer
);

which then throws an error when i try to push to Turso. I suspect it's the empty

entries

entries

default, when i remove all works fine.

Is this expected or show i create a issue on github?

Using default with `text` json mode creates empty `DEFAULT`

Similar Threads

Using default with `text` json mode creates empty `DEFAULT`

Similar Threads

Similar Threads

Similar Threads