svn commit: r1089889 - /subversion/trunk/subversion/libsvn_wc/wc-queries.sql

[hw...@apache.org]

Author: hwright
Date: Thu Apr  7 14:19:41 2011
New Revision: 1089889

URL: http://svn.apache.org/viewvc?rev=1089889&view=rev
Log:
Reorder trigger declarations, so that the changelist_clear trigger fires
before the changelist_set trigger.  Not only is this more intuitive, it fixes
a Ruby bindings test.

* subversion/libsvn_wc/wc-queries.sql
  (STMT_CREATE_CHANGELIST_LIST): Reorder triggers as above.

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=1089889&r1=1089888&r2=1089889&view=diff
==============================================================================
--- subversion/trunk/subversion/libsvn_wc/wc-queries.sql (original)
+++ subversion/trunk/subversion/libsvn_wc/wc-queries.sql Thu Apr  7 14:19:41 2011
@@ -373,15 +373,6 @@ BEGIN
     INSERT INTO changelist_list(wc_id, local_relpath, notify, changelist)
     VALUES (NEW.wc_id, NEW.local_relpath, 26, NEW.changelist);
 END;
-DROP TRIGGER IF EXISTS   trigger_changelist_list_actual_cl_set;
-CREATE TEMPORARY TRIGGER trigger_changelist_list_actual_cl_set
-BEFORE UPDATE ON actual_node
-WHEN NEW.CHANGELIST IS NOT NULL
-BEGIN
-    /* 26 corresponds to svn_wc_notify_changelist_set */
-    INSERT INTO changelist_list(wc_id, local_relpath, notify, changelist)
-    VALUES (NEW.wc_id, NEW.local_relpath, 26, NEW.changelist);
-END;
 DROP TRIGGER IF EXISTS   trigger_changelist_list_actual_cl_clear;
 CREATE TEMPORARY TRIGGER trigger_changelist_list_actual_cl_clear
 BEFORE UPDATE ON actual_node
@@ -391,6 +382,15 @@ BEGIN
     INSERT INTO changelist_list(wc_id, local_relpath, notify, changelist)
     VALUES (OLD.wc_id, OLD.local_relpath, 27, OLD.changelist);
 END;
+DROP TRIGGER IF EXISTS   trigger_changelist_list_actual_cl_set;
+CREATE TEMPORARY TRIGGER trigger_changelist_list_actual_cl_set
+BEFORE UPDATE ON actual_node
+WHEN NEW.CHANGELIST IS NOT NULL
+BEGIN
+    /* 26 corresponds to svn_wc_notify_changelist_set */
+    INSERT INTO changelist_list(wc_id, local_relpath, notify, changelist)
+    VALUES (NEW.wc_id, NEW.local_relpath, 26, NEW.changelist);
+END;
 
 -- STMT_DROP_CHANGELIST_LIST_TRIGGERS
 DROP TRIGGER IF EXISTS trigger_changelist_list_actual_cl_insert;