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

[..hidden..]

Revision: 6837
          http://sourceforge.net/p/ledger-smb/code/6837
Author:   tshvr
Date:     2014-02-10 16:20:58 +0000 (Mon, 10 Feb 2014)
Log Message:
-----------
consistency_checks adding

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

Modified: trunk/sql/consistency_checks.sql
===================================================================
--- trunk/sql/consistency_checks.sql	2014-02-10 16:10:52 UTC (rev 6836)
+++ trunk/sql/consistency_checks.sql	2014-02-10 16:20:58 UTC (rev 6837)
@@ -15,6 +15,14 @@
   raise exception 'unbalanced transactions row_count=%',row_count;
  end if;
 
+ --tshvr4 not sure about this test. can anyone confirm?
+ perform * from gl where id not in (select trans_id from acc_trans);
+ GET DIAGNOSTICS row_count = ROW_COUNT;
+ if row_count > 0 then
+  raise exception 'unbalanced gl - 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=121051231&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits