I have two buckets, order and history. I am trying to create a new field in order that matches something in history. However history references an order via a
uuid while the actual document has
order::uuid. When i try to perform my MERGE i get
error:5030, invalid merge key of <nil>
for reference paidDate doesn’t exist in the order document yet. So I might need to change this into an insert. I am just trying to get it to run
MERGE INTO order as o USING history AS h ON KEY 'order::' || history.orderId WHEN MATCHED THEN UPDATE SET o.paidDate = h.date
Is it possible for me to be able to run a query like this or am i looking into using something different.