Invalid serialization of JSON blobs
Has anyone gotten default values of JSON blobs to work with SQLite?
When I try using an empty array, the SQL migration does not have a default value (despite having the
If I use an object, the default value is the
I also posted an issue on GitHub since this seems like a bug, but asking here in case any of you have found a workaround.
https://github.com/drizzle-team/drizzle-orm/issues/1036
When I try using an empty array, the SQL migration does not have a default value (despite having the
DEFAULT keyword).If I use an object, the default value is the
toString serialization: [object Object], not the JSON.stringify serialization.I also posted an issue on GitHub since this seems like a bug, but asking here in case any of you have found a workaround.
https://github.com/drizzle-team/drizzle-orm/issues/1036
GitHub![[BUG]: SQLite JSON blog with empty array produces invalid migration...](https://images-ext-1.discordapp.net/external/W8DRBDunzlCk3nJr59salMsQ4RUI-PueE62Sd1utioY/https/opengraph.githubassets.com/7691d326b633f649568a47423dbaea983d1c804412cbc3c05f5138d653b28fce/drizzle-team/drizzle-orm/issues/1036)
What version of drizzle-orm are you using? 0.28.2 What version of drizzle-kit are you using? 0.19.12 Describe the Bug I have the following schema: array: blob("array", { mode: 'json&#...
