[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

ledgersmb 1.3 pre_upgrade_checks

Should we not test also on:

select * from lsmb12.vendor v,lsmb12.customer c where

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;

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

Herman Vierendeels