git » sdk » commit 8dbdf56

Cannot use jsonb function in default

author Stephen Paul Weber
2026-04-29 03:06:31 UTC
committer Stephen Paul Weber
2026-04-29 03:13:01 UTC
parent 698fc6ee516ccb9c2cc7b1d675baae4dece48e4e

Cannot use jsonb function in default

borogove/persistence/Sqlite.hx +2 -1

diff --git a/borogove/persistence/Sqlite.hx b/borogove/persistence/Sqlite.hx
index e241790..fd8e71b 100644
--- a/borogove/persistence/Sqlite.hx
+++ b/borogove/persistence/Sqlite.hx
@@ -223,7 +223,8 @@ class Sqlite implements Persistence implements KeyValueStore {
 					return Promise.resolve(null);
 				}).then(_ -> {
 					if (version < 9) {
-						return exec(["ALTER TABLE chats ADD COLUMN meta BLOB NOT NULL DEFAULT jsonb('{}')",
+						// 0C is jsonb empty object, since the jsonb function isn't allowed here
+						return exec(["ALTER TABLE chats ADD COLUMN meta BLOB NOT NULL DEFAULT X'0C'",
 						"PRAGMA user_version = 9"]);
 					}
 					return Promise.resolve(null);