fix Maria 10.2 returning null instead of 0 for nonexistant json attrs

1 files changed, 1 insertions, 1 deletions

diff --git a/worker.js b/worker.js
index 9a5ce47..f3995a6 100644
--- a/worker.js
+++ b/worker.js
@@ -92,7 +92,7 @@ amqp.connect(RABBITMQ_URI).then(async (rabbit) => {
         const pad = (i) => i.toString().padStart(3, "0");
         if (doCreate) {  // insert
             return active_items.map((i) =>
-                `sum(column_get(${tableName}.item_uses, '${i}' as int)) ` +
+                `sum(coalesce(column_get(${tableName}.item_uses, '${i}' as int), 0)) ` +
                     `as item_${pad(i)}_use`
             ).join(",\n");
         } else {