Author: philip Date: Wed Mar 16 11:48:30 2011 New Revision: 1082131 URL: http://svn.apache.org/viewvc?rev=1082131&view=rev Log: * subversion/libsvn_wc/wc-queries.sql (STMT_CLEAR_ACTUAL_NODE_LEAVING_CHANGELIST, STMT_CLEAR_ACTUAL_NODE_LEAVING_CONFLICT): Use upper case for keyword. (STMT_CLEAR_ACTUAL_NODE_LEAVING_CHANGELIST_RECURSIVE): Use upper case for keyword and add brackets for mixed AND/OR.
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=1082131&r1=1082130&r2=1082131&view=diff ============================================================================== --- subversion/trunk/subversion/libsvn_wc/wc-queries.sql (original) +++ subversion/trunk/subversion/libsvn_wc/wc-queries.sql Wed Mar 16 11:48:30 2011 @@ -407,7 +407,7 @@ SET properties = NULL, older_checksum = NULL, left_checksum = NULL, right_checksum = NULL -WHERE wc_id = ?1 and local_relpath = ?2; +WHERE wc_id = ?1 AND local_relpath = ?2; -- STMT_CLEAR_ACTUAL_NODE_LEAVING_CHANGELIST_RECURSIVE UPDATE actual_node @@ -421,7 +421,7 @@ SET properties = NULL, older_checksum = NULL, left_checksum = NULL, right_checksum = NULL -WHERE wc_id = ?1 and local_relpath = ?2 OR local_relpath LIKE ?3 ESCAPE '#'; +WHERE wc_id = ?1 AND (local_relpath = ?2 OR local_relpath LIKE ?3 ESCAPE '#'); -- STMT_CLEAR_ACTUAL_NODE_LEAVING_CONFLICT UPDATE actual_node @@ -435,7 +435,7 @@ SET properties = NULL, older_checksum = NULL, left_checksum = NULL, right_checksum = NULL -WHERE wc_id = ?1 and local_relpath = ?2; +WHERE wc_id = ?1 AND local_relpath = ?2; -- STMT_UPDATE_NODE_BASE_DEPTH UPDATE nodes SET depth = ?3