Author: rhuijben
Date: Fri May 6 20:39:07 2011
New Revision: 1100367
URL: http://svn.apache.org/viewvc?rev=1100367&view=rev
Log:
Remove a few more unused queries.
* subversion/libsvn_wc/wc-queries.sql
(STMT_DELETE_ALL_WORKING_NODES,
STMT_DELETE_NODES,
STMT_SELECT_NOT_PRESENT,
STMT_UPDATE_CHECKSUM): Remove queries.
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=1100367&r1=1100366&r2=1100367&view=diff
==============================================================================
--- subversion/trunk/subversion/libsvn_wc/wc-queries.sql (original)
+++ subversion/trunk/subversion/libsvn_wc/wc-queries.sql Fri May 6 20:39:07
2011
@@ -469,18 +469,10 @@ WHERE wc_id = ?1 AND local_relpath = ?2
WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth > 0)
AND presence = 'base-deleted'
--- STMT_DELETE_ALL_WORKING_NODES
-DELETE FROM nodes
-WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth > 0
-
-- STMT_DELETE_ALL_LAYERS
DELETE FROM nodes
WHERE wc_id = ?1 AND local_relpath = ?2
--- STMT_DELETE_NODES
-DELETE FROM nodes
-WHERE wc_id = ?1 AND local_relpath = ?2
-
-- STMT_DELETE_NODES_RECURSIVE
DELETE FROM nodes
WHERE wc_id = ?1 AND (local_relpath = ?2 OR local_relpath LIKE ?3 ESCAPE '#')
@@ -842,11 +834,6 @@ INSERT OR REPLACE INTO actual_node (
tree_conflict_data)
VALUES (?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, NULL, ?10)
--- STMT_SELECT_NOT_PRESENT
-SELECT 1 FROM nodes
-WHERE wc_id = ?1 AND local_relpath = ?2 AND presence = 'not-present'
- AND op_depth = 0
-
-- STMT_SELECT_FILE_EXTERNAL
SELECT file_external FROM nodes
WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0
@@ -900,10 +887,6 @@ WHERE NOT ((prop_reject IS NULL) AND (co
AND (conflict_new IS NULL) AND (conflict_working IS NULL)
AND (tree_conflict_data IS NULL))
--- STMT_UPDATE_CHECKSUM
-UPDATE nodes SET checksum = ?4
-WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3
-
/* ------------------------------------------------------------------------- */
/* PROOF OF CONCEPT: Complex queries for callback walks, caching results
in a temporary table. */
