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

1.5 test for unbalanced acc_trans


If following is a good test for unbalanced transactions,
could we add it to setup- and upgrade-scripts?

select *|(or only relevant data)  from acc_trans where trans_id in
 ( select trans_id from acc_trans  group by trans_id having sum(amount) <> 0 );

Best wishes,