Untitled

2020-01-08 00:18:21 brick05-head open-ils.cstore: [ERR :72530:oils_sql.c:5898:15784605447240195] open-ils.cstore: Error with query [SELECT * FROM unapi.metabib_virtual_record_feed( '{2361339}', 'marcxml', '{holdings_xml,mra,mmr.unapi}', 'PINES', '0', 'acn=>5,acp=>5,bre=>5', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ) AS "unapi.metabib_virtual_record_feed" ;]: 466560 466560: ERROR:  set-returning functions are not allowed in COALESCE#012LINE 11:                 WITH aou AS (SELECT COALESCE(id, (evergreen....#012                                                           ^#012HINT:  You might be able to move the set-returning function into a LATERAL FROM item.#012QUERY:  #012    SELECT  XMLELEMENT(#012        name attributes,#012        XMLATTRIBUTES(#012            CASE WHEN $9 THEN 'http://open-ils.org/spec/indexing/v1' ELSE NULL END AS xmlns,#012            'tag:open-ils.org:U2@mmr/' || $1 AS metarecord#012        ),#012        (SELECT XMLAGG(foo.y)#012          FROM (#012            WITH sourcelist AS (#012                WITH aou AS (SELECT COALESCE(id, (evergreen.org_top()).id) AS id FROM actor.org_unit WHERE shortname = $5 LIMIT 1),#012                     basevm AS (SELECT c_attrs FROM  asset.patron_default_visibility_mask()),#012                     circvm AS (SELECT search.calculate_visibility_attribute_test('circ_lib', ARRAY_AGG(aoud.id)) AS mask#012                                  FROM aou, LATERAL actor.org_unit_descendants(aou.id, $6) aoud)#012                SELECT  source#012                  FROM  aou, circvm, basevm, metabib.metarecord_source_map mmsm#012                  WHERE mmsm.metarecord = $1 AND (#012                    EXISTS (#012 ...