SF.net SVN: ledger-smb:[6872] trunk/sql/consistency_checks.sql

[..hidden..]

Revision: 6872
          http://sourceforge.net/p/ledger-smb/code/6872
Author:   tshvr
Date:     2014-02-17 19:37:23 +0000 (Mon, 17 Feb 2014)
Log Message:
-----------
ap<->acc_trans

Modified Paths:
--------------
    trunk/sql/consistency_checks.sql

Modified: trunk/sql/consistency_checks.sql
===================================================================
--- trunk/sql/consistency_checks.sql	2014-02-17 13:42:21 UTC (rev 6871)
+++ trunk/sql/consistency_checks.sql	2014-02-17 19:37:23 UTC (rev 6872)
@@ -22,7 +22,13 @@
   raise exception 'unbalanced gl - acc_trans row_count=%',row_count;
  end if;
 
+ perform * from ap where id not in (select trans_id from acc_trans);
+ GET DIAGNOSTICS row_count = ROW_COUNT;
+ if row_count > 0 then
+  raise exception 'entries in ap but not in acc_trans row_count=%',row_count;
+ end if;
 
+
  rc=0;
  return rc;
 END;

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.


------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits