Skip to main content
summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMorgan E. Cook2017-07-03 20:22:22 +0000
committerMorgan E. Cook2017-07-03 20:22:49 +0000
commit8d50e3472d456fbb519461e0c9de17b640ea84cd (patch)
tree54cd8490b0f77ca2e8231980eac67b7644878c8f
parent915954c1827bf4274c27b42f4a164b39a0b853e5 (diff)
downloadorg.eclipse.osee-8d50e3472d456fbb519461e0c9de17b640ea84cd.tar.gz
org.eclipse.osee-8d50e3472d456fbb519461e0c9de17b640ea84cd.tar.xz
org.eclipse.osee-8d50e3472d456fbb519461e0c9de17b640ea84cd.zip
bug: Update purge unused data to use tuple table
Signed-off-by: Morgan E. Cook <morgan.e.cook@boeing.com>
-rw-r--r--plugins/org.eclipse.osee.orcs.db/src/org/eclipse/osee/orcs/db/internal/callable/PurgeUnusedBackingDataAndTransactions.java3
1 files changed, 2 insertions, 1 deletions
diff --git a/plugins/org.eclipse.osee.orcs.db/src/org/eclipse/osee/orcs/db/internal/callable/PurgeUnusedBackingDataAndTransactions.java b/plugins/org.eclipse.osee.orcs.db/src/org/eclipse/osee/orcs/db/internal/callable/PurgeUnusedBackingDataAndTransactions.java
index 7c5f57f2502..86def151435 100644
--- a/plugins/org.eclipse.osee.orcs.db/src/org/eclipse/osee/orcs/db/internal/callable/PurgeUnusedBackingDataAndTransactions.java
+++ b/plugins/org.eclipse.osee.orcs.db/src/org/eclipse/osee/orcs/db/internal/callable/PurgeUnusedBackingDataAndTransactions.java
@@ -38,7 +38,8 @@ public class PurgeUnusedBackingDataAndTransactions {
private static final String NONEXISTENT_GAMMAS = "SELECT branch_id, gamma_id FROM %s txs WHERE " + //
"NOT EXISTS (SELECT 1 FROM osee_attribute att WHERE txs.gamma_id = att.gamma_id union all " + //
"SELECT 1 FROM osee_artifact art WHERE txs.gamma_id = art.gamma_id union all " + //
- "SELECT 1 FROM osee_relation_link rel WHERE txs.gamma_id = rel.gamma_id)";
+ "SELECT 1 FROM osee_relation_link rel WHERE txs.gamma_id = rel.gamma_id union all " + //
+ "SELECT 1 FROM osee_tuple2 tup WHERE txs.gamma_id = tup.gamma_id)";
private static final String DELETE_GAMMAS = "DELETE FROM %s WHERE gamma_id = ?";
private static final String DELETE_GAMMAS_BY_BRANCH = "DELETE FROM %s WHERE branch_id = ? and gamma_id = ?";

Back to the top