# HG changeset patch # User jbe # Date 1520856019 -3600 # Node ID 257dd2933ab2e1694031cc45725690f1906b9fe1 # Parent b19a6b4f61f35f2708eff500b12dc76cada242ff Avoid including duplicate IDs when fetching referenced records diff -r b19a6b4f61f3 -r 257dd2933ab2 libraries/mondelefant/mondelefant.lua --- a/libraries/mondelefant/mondelefant.lua Mon Jan 15 20:13:32 2018 +0100 +++ b/libraries/mondelefant/mondelefant.lua Mon Mar 12 13:00:19 2018 +0100 @@ -1521,11 +1521,15 @@ local options = options or {} local model = get_model() -- TODO: too many records cause PostgreSQL command stack overflow + local ids_used = {} local ids = { sep = ", " } for i, object in ipairs(list) do local id = object[this_key] if id ~= nil then - ids[#ids+1] = {"?", id} + if not ids_used[id] then + ids[#ids+1] = {"?", id} + ids_used[id] = true + end end end if #ids == 0 then