You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@subversion.apache.org by ph...@apache.org on 2011/04/01 17:51:50 UTC
svn commit: r1087780 - /subversion/trunk/subversion/libsvn_wc/wc-queries.sql
Author: philip
Date: Fri Apr 1 15:51:50 2011
New Revision: 1087780
URL: http://svn.apache.org/viewvc?rev=1087780&view=rev
Log:
* subversion/libsvn_wc/wc-queries.sql
(STMT_CREATE_REVERT_CACHE): Make actual_node triggers more efficient by
combining the insert and the update.
Modified:
subversion/trunk/subversion/libsvn_wc/wc-queries.sql
Modified: subversion/trunk/subversion/libsvn_wc/wc-queries.sql
URL: http://svn.apache.org/viewvc/subversion/trunk/subversion/libsvn_wc/wc-queries.sql?rev=1087780&r1=1087779&r2=1087780&view=diff
==============================================================================
--- subversion/trunk/subversion/libsvn_wc/wc-queries.sql (original)
+++ subversion/trunk/subversion/libsvn_wc/wc-queries.sql Fri Apr 1 15:51:50 2011
@@ -933,12 +933,11 @@ BEFORE DELETE ON actual_node
BEGIN
INSERT OR REPLACE INTO revert_cache(local_relpath, conflict_old,
conflict_new, conflict_working,
- prop_reject)
+ prop_reject, notify)
SELECT OLD.local_relpath,
OLD.conflict_old, OLD.conflict_new, OLD.conflict_working,
- OLD.prop_reject;
- UPDATE revert_cache SET notify = 1
- WHERE OLD.properties IS NOT NULL;
+ OLD.prop_reject,
+ CASE WHEN OLD.properties IS NOT NULL THEN 1 ELSE NULL END;
END;
DROP TRIGGER IF EXISTS trigger_revert_cache_update;
CREATE TEMPORARY TRIGGER trigger_revert_cache_actual_update
@@ -946,12 +945,11 @@ BEFORE UPDATE ON actual_node
BEGIN
INSERT OR REPLACE INTO revert_cache(local_relpath, conflict_old,
conflict_new, conflict_working,
- prop_reject)
+ prop_reject, notify)
SELECT OLD.local_relpath,
OLD.conflict_old, OLD.conflict_new, OLD.conflict_working,
- OLD.prop_reject;
- UPDATE revert_cache SET notify = 1
- WHERE OLD.properties IS NOT NULL;
+ OLD.prop_reject,
+ CASE WHEN OLD.properties IS NOT NULL THEN 1 ELSE NULL END;
END
-- STMT_DROP_REVERT_CACHE_TRIGGERS