ledgersmb 1.3 pre_upgrade_checks

[herman vierendeels <..hidden..>]

Should we not test also on:

select * from lsmb12.vendor v,lsmb12.customer c where
c.customernumber=v.vendornumber;

if so:
there will be double meta_number in entity_credit_account

SELECT max(id),meta_number FROM entity_credit_account e group by
meta_number having count(*) > 1 order by meta_number;

and
UPDATE lsmb12.vendor SET credit_id = (SELECT id FROM
entity_credit_account e WHERE e.meta_number = vendornumber);
will fail

ERROR:  more than one row returned by a subquery used as an expression


Greetings,
Herman Vierendeels