Package org.tmatesoft.svn.core.internal.wc17.db.statement
package org.tmatesoft.svn.core.internal.wc17.db.statement
-
ClassDescriptionUPDATE nodes SET presence = ?3, revision = ?4, repos_path = ?5 WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;INSERT OR REPLACE INTO nodes ( wc_id, local_relpath, op_depth, parent_relpath, repos_id, repos_path, revision, presence, depth, kind, changed_revision, changed_date, changed_author, checksum, properties, dav_cache, symlink_target, file_external ) VALUES (?1, ?2, 0, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12, ?13, ?14, ?15, ?16, ?17);UPDATE actual_node SET conflict_old = NULL, conflict_new = NULL, conflict_working = NULL WHERE wc_id = ?1 AND local_relpath = ?2;UPDATE actual_node SET conflict_old = NULL, conflict_new = NULL, conflict_working = NULL WHERE wc_id = ?1 AND (?2 = '' OR local_relpath = ?2 OR (local_relpath > ?2 || '/' AND local_relpath < ?2 || '0'))UPDATE actual_node SET properties = NULL, text_mod = NULL, changelist = NULL, tree_conflict_data = NULL, conflict_old = NULL, conflict_new = NULL, conflict_working = NULL, prop_reject = NULL, older_checksum = NULL, left_checksum = NULL, right_checksum = NULL WHERE wc_id = ?1 and local_relpath = ?2;-- STMT_CLEAR_BASE_NODE_RECURSIVE_DAV_CACHE UPDATE nodes SET dav_cache = NULL WHERE dav_cache IS NOT NULL AND wc_id = ?1 AND op_depth = 0 AND (?2 = '' OR local_relpath = ?2 OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2)) primary index: wc_id, local_relpath, op_depthUPDATE nodes SET moved_here = NULL WHERE wc_id = ?1 AND (local_relpath = ?2 OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2)) AND op_depth = ?3UPDATE nodes SET moved_to = NULL WHERE wc_id = ?1 AND IS_STRICT_DESCENDANT_OF(moved_to, ?2)UPDATE NODES SET moved_to = NULL WHERE wc_id = ?1 AND moved_to = ?2UPDATE actual_node SET prop_reject = NULL WHERE wc_id = ?1 AND local_relpath = ?2;UPDATE actual_node SET conflict_old = NULL, conflict_new = NULL, conflict_working = NULL WHERE wc_id = ?1 AND local_relpath = ?2;-- STMT_COMMIT_DESCENDANT_TO_BASE UPDATE NODES SET op_depth = 0, repos_id = ?4, repos_path = ?5, revision = ?6, moved_here = NULL, moved_to = NULL, dav_cache = NULL, presence = CASE presence WHEN 'normal' THEN 'normal' WHEN 'excluded' THEN 'excluded' ELSE 'not-present' END WHERE wc_id = ?1 AND local_relpath = ?2 and op_depth = ?3DELETE FROM actual_node WHERE wc_id = ?1 AND properties IS NULL AND conflict_old IS NULL AND conflict_new IS NULL AND prop_reject IS NULL AND changelist IS NULL AND text_mod IS NULL AND tree_conflict_data IS NULL AND older_checksum IS NULL AND right_checksum IS NULL AND left_checksum IS NULLDELETE FROM actual_node WHERE wc_id = ?1 AND local_relpath = ?2 AND properties IS NULL AND conflict_old IS NULL AND conflict_new IS NULL AND prop_reject IS NULL AND changelist IS NULL AND text_mod IS NULL AND tree_conflict_data IS NULL AND older_checksum IS NULL AND right_checksum IS NULL AND left_checksum IS NULL;DELETE FROM actual_node WHERE wc_id = ?1 AND IS_STRICT_DESCENDANT_OF(local_relpath, ?2) AND EXISTS(SELECT 1 FROM NODES b WHERE b.wc_id = ?1 AND b.local_relpath = actual_node.local_relpath AND op_depth = 0) AND NOT EXISTS(SELECT 1 FROM NODES w WHERE w.wc_id = ?1 AND w.local_relpath = actual_node.local_relpath AND op_depth > 0 AND presence in (MAP_NORMAL, MAP_INCOMPLETE, MAP_NOT_PRESENT))DELETE FROM actual_node WHERE wc_id = ?1 AND local_relpath = ?2;-- STMT_DELETE_ACTUAL_NODE_LEAVING_CHANGELIST_RECURSIVE DELETE FROM actual_node WHERE wc_id = ?1 AND local_relpaht = ?2 AND (changelist IS NULL OR NOT EXISTS (SELECT 1 FROM nodes_current c WHERE c.wc_id = ?1 AND c.local_relpath = local_relpath AND kind = 'file'))-- STMT_DELETE_ACTUAL_NODE_LEAVING_CHANGELIST_RECURSIVE DELETE FROM actual_node WHERE wc_id = ?1 AND (?2 = '' OR local_relpath = ?2 OR (local_relpath > ?2 || '/' AND local_relpath < ?2 || '0')) AND (changelist IS NULL OR NOT EXISTS (SELECT 1 FROM nodes_current c WHERE c.wc_id = ?1 AND c.local_relpath = local_relpath AND kind = 'file'))-- STMT_DELETE_ACTUAL_NODE_RECURSIVE DELETE FROM actual_node WHERE wc_id = ?1 AND (?2 = '' OR local_relpath = ?2 OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2))DELETE FROM actual_node WHERE wc_id = ?1 AND local_relpath = ?2 AND tree_conflict_data IS NULL;-- STMT_DELETE_ALL_LAYERS DELETE FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2DELETE FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth > 0;DELETE FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;DELETE FROM nodes WHERE wc_id = ?1 AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) AND op_depth = 0DELETE FROM externals WHERE wc_id = ?1 AND IS_STRICT_DESCENDANT_OF(local_relpath, ?2)DELETE FROM externals WHERE wc_id = ?1 AND IS_STRICT_DESCENDANT_OF(local_relpath, ?2) AND kind != MAP_DIRDELETE FROM nodes WHERE wc_id = ?1 AND IS_STRICT_DESCENDANT_OF(local_relpath, ?2) AND op_depth = 0 AND file_external IS NOT NULLDELETE FROM lock WHERE repos_id = ?1 AND repos_relpath = ?2DELETE FROM wc_lock WHERE wc_id = ?1 AND (?2 = '' OR local_dir_relpath = ?2 OR (local_dir_relpath > ?2 || '/' AND local_dir_relpath < ?2 || '0')) AND NOT EXISTS (SELECT 1 FROM nodes WHERE nodes.wc_id = ?1 AND nodes.local_relpath = wc_lock.local_dir_relpath)DELETE FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = (SELECT MIN(op_depth) FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth > 0) AND presence = 'base-deleted';DELETE FROM nodes WHERE wc_id = ?1 AND (local_relpath = ?2 OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2)) AND op_depth = ?3DELETE FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2;DELETE FROM nodes WHERE wc_id = ?1 AND (?2 = '' OR local_relpath = ?2 OR (local_relpath > ?2 || '/' AND local_relpath < ?2 || '0')) AND op_depth >= ?3DELETE FROM pristine WHERE checksum = ?1-- STMT_DELETE_PRISTINE_IF_UNREFERENCED DELETE FROM pristine WHERE checksum = ?1 AND refcount = 0-- STMT_DELETE_SHADOWED_RECURSIVE DELETE FROM nodes WHERE wc_id = ?1 AND (local_relpath = ?2 OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2)) AND (op_depth < ?3 OR (op_depth = ?3 AND presence = 'base-deleted')) *DELETE FROM wc_lock WHERE wc_id = ?1 AND local_dir_relpath = ?2;DELETE FROM wc_lock WHERE wc_id = ?1 AND local_dir_relpath = ?2 AND NOT EXISTS (SELECT 1 FROM nodes WHERE nodes.wc_id = ?1 AND nodes.local_relpath = wc_lock.local_dir_relpath)DELETE FROM nodes WHERE wc_id = ?1 AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) AND presence = 'base-deleted' AND op_depth > 0 AND op_depth = (SELECT MIN(op_depth) FROM nodes n WHERE n.wc_id = ?1 AND n.local_relpath = nodes.local_relpath AND op_depth > 0)DELETE FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = (SELECT MAX(op_depth) FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth > 0);DELETE FROM nodes WHERE wc_id = ?1 AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) AND op_depth > 0DELETE FROM work_queue WHERE id = ?1;SELECT 1 FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 LIMIT 1SELECT local_dir_relpath FROM wc_lock WHERE wc_id = ?1 AND local_dir_relpath LIKE ?2 ESCAPE '#';SELECT local_relpath FROM nodes WHERE wc_id = ?1 AND IS_STRICT_DESCENDANT_OF(local_relpath, ?2) AND op_depth = 0 AND presence = MAP_SERVER_EXCLUDED LIMIT 1INSERT INTO actual_node ( wc_id, local_relpath, conflict_data, parent_relpath) VALUES (?1, ?2, ?3, ?4);-- STMT_INSERT_ACTUAL_EMPTIES INSERT OR IGNORE INTO actual_node ( wc_id, local_relpath, parent_relpath, properties, conflict_old, conflict_new, conflict_working, prop_reject, changelist, text_mod, tree_conflict_data ) SELECT wc_id, local_relpath, parent_relpath, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL FROM targets_list-- STMT_INSERT_ACTUAL_NODE INSERT OR REPLACE INTO actual_node ( wc_id, local_relpath, parent_relpath, properties, changelist, conflict_data) VALUES (?1, ?2, ?3, ?4, ?5, ?6)INSERT INTO actual_node ( wc_id, local_relpath, prop_reject, parent_relpath) VALUES (?1, ?2, ?3, ?4)INSERT INTO actual_node (wc_id, local_relpath, parent_relpath, properties) VALUES (?1, ?2, ?3, ?4);INSERT INTO actual_node ( wc_id, local_relpath, conflict_old, conflict_new, conflict_working, parent_relpath) VALUES (?1, ?2, ?3, ?4, ?5, ?6);INSERT INTO actual_node ( wc_id, local_relpath, tree_conflict_data, parent_relpath) VALUES (?1, ?2, ?3, ?4);INSERT INTO nodes ( wc_id, local_relpath, op_depth, parent_relpath, presence, kind) SELECT wc_id, local_relpath, ?3 depth, parent_relpath, 'base-deleted', kind FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0INSERT INTO nodes ( wc_id, local_relpath, op_depth, parent_relpath, presence, kind) SELECT wc_id, local_relpath, ?4 _op_depth_, parent_relpath, 'base-deleted', kind FROM nodes WHERE wc_id = ?1 AND (local_relpath = ?2 OR (local_relpath > ?2 || '/' AND local_relpath < ?2 || '0')) AND op_depth = ?3 AND presence NOT IN ('base-deleted', 'not-present', 'excluded', 'absent') AND file_external IS NULL-- STMT_INSERT_EXTERNAL INSERT OR REPLACE INTO externals ( wc_id, local_relpath, parent_relpath, presence, kind, def_local_relpath, repos_id, def_repos_relpath, def_operational_revision, def_revision) VALUES (?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10)-- STMT_INSERT_EXTERNAL_UPGRADE INSERT OR REPLACE INTO externals ( wc_id, local_relpath, parent_relpath, presence, kind, def_local_relpath, repos_id, def_repos_relpath, def_operational_revision, def_revision) VALUES (?1, ?2, ?3, ?4, CASE WHEN (SELECT file_external FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0) IS NOT NULL THEN 'file' ELSE 'unknown' END, ?5, ?6, ?7, ?8, ?9)INSERT INTO lock (repos_id, repos_relpath, lock_token, lock_owner, lock_comment, lock_date) VALUES (?1, ?2, ?3, ?4, ?5, ?6);INSERT OR REPLACE INTO nodes ( wc_id, local_relpath, op_depth, parent_relpath, repos_id, repos_path, revision, presence, depth, kind, changed_revision, changed_date, changed_author, checksum, properties, translated_size, last_mod_time, dav_cache, symlink_target, file_external, moved_to, moved_here, inherited_props ) VALUES (?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12, ?13, ?14, ?15, ?16, ?17, ?18, ?19, ?20, ?21, ?22, ?23);-- STMT_INSERT_OR_IGNORE_PRISTINE INSERT OR IGNORE INTO pristine (checksum, md5_checksum, size, refcount) VALUES (?1, ?2, ?3, 0)INSERT OR IGNORE INTO pristine (checksum, md5_checksum, size, refcount) VALUES (?1, ?2, ?3, 0);INSERT INTO repository (root, uuid) VALUES (?1, ?2);INSERT INTO wc_lock (wc_id, local_dir_relpath, locked_levels) VALUES (?1, ?2, ?3);INSERT INTO wcroot (local_abspath) VALUES (?1);INSERT OR REPLACE INTO nodes ( wc_id, local_relpath, op_depth, parent_relpath, presence, kind, checksum, changed_revision, changed_date, changed_author, depth, symlink_target, translated_size, last_mod_time, properties) SELECT wc_id, local_relpath, ?3 AS op_depth, parent_relpath, ?4 AS presence, kind, checksum, changed_revision, changed_date, changed_author, depth, symlink_target, translated_size, last_mod_time, properties FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;INSERT INTO nodes ( wc_id, local_relpath, op_depth, parent_relpath, repos_id, repos_path, revision, presence, depth, kind, changed_revision, changed_date, changed_author, checksum, properties, translated_size, last_mod_time, symlink_target ) SELECT wc_id, local_relpath, ?3 AS op_depth, parent_relpath, repos_id, repos_path, revision, presence, depth, kind, changed_revision, changed_date, changed_author, checksum, properties, translated_size, last_mod_time, symlink_target FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;INSERT INTO nodes ( wc_id, local_relpath, op_depth, parent_relpath, repos_id, repos_path, revision, presence, depth, kind, changed_revision, changed_date, changed_author, checksum, properties, translated_size, last_mod_time, symlink_target ) SELECT wc_id, local_relpath, ?3 AS op_depth, parent_relpath, repos_id, repos_path, revision, ?4 AS presence, depth, kind, changed_revision, changed_date, changed_author, checksum, properties, translated_size, last_mod_time, symlink_target FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;INSERT INTO nodes ( wc_id, local_relpath, op_depth, parent_relpath, repos_id, repos_path, revision, presence, depth, kind, changed_revision, changed_date, changed_author, checksum, properties, translated_size, last_mod_time, symlink_target ) SELECT wc_id, local_relpath, ?3 AS op_depth, parent_relpath, repos_id, repos_path, revision, 'normal', depth, kind, changed_revision, changed_date, changed_author, checksum, properties, translated_size, last_mod_time, symlink_target FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;INSERT INTO nodes ( wc_id, local_relpath, op_depth, parent_relpath, repos_id, repos_path, revision, presence, kind, changed_revision, changed_date, changed_author ) SELECT wc_id, local_relpath, ?3 as op_depth, parent_relpath, repos_id, repos_path, revision, 'not-present', kind, changed_revision, changed_date, changed_author FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;INSERT INTO work_queue (work) VALUES (?1);INSERT OR REPLACE INTO nodes ( wc_id, local_relpath, op_depth, parent_relpath, presence, kind) VALUES(?1, ?2, ?3, ?4, 'base-deleted', ?5)SELECT id FROM work_queue LIMIT 1STMT_MARK_SKIPPED_CHANGELIST_DIRS INSERT INTO changelist_list (wc_id, local_relpath, notify, changelist) SELECT wc_id, local_relpath, 7, ?1 FROM targets_list WHERE kind = 'dir'CREATE VIEW NODES_BASE AS SELECT * FROM nodes WHERE op_depth = 0;CREATE VIEW NODES_CURRENT AS SELECT * FROM nodes AS n WHERE op_depth = (SELECT MAX(op_depth) FROM nodes AS n2 WHERE n2.wc_id = n.wc_id AND n2.local_relpath = n.local_relpath);REPLACE INTO actual_node ( wc_id, local_relpath, parent_relpath, changelist) VALUES (?1, ?2, ?3, ?4);SELECT local_relpath, tree_conflict_data FROM actual_node WHERE wc_id = ?1 AND parent_relpath = ?2 AND tree_conflict_data IS NOT NULL;SELECT local_relpath, changelist, properties, conflict_data FROM actual_node WHERE wc_id = ?1 AND parent_relpath = ?2SELECT local_relpath FROM actual_node WHERE wc_id = ?1 AND parent_relpath = ?2 AND NOT((prop_reject IS NULL) AND (conflict_old IS NULL) AND (conflict_new IS NULL) AND (conflict_working IS NULL) AND (tree_conflict_data IS NULL))select prop_reject, changelist, conflict_old, conflict_new, conflict_working, tree_conflict_data, properties from actual_node where wc_id = ?1 and local_relpath = ?2;select properties from actual_node where wc_id = ?1 and local_relpath = ?2;SELECT tree_conflict_data FROM actual_node WHERE wc_id = ?1 AND local_relpath = ?2 AND tree_conflict_data IS NOT NULL;-- STMT_SELECT_ALL_FILES SELECT DISTINCT local_relpath FROM nodes WHERE wc_id = ?1 AND parent_relpath = ?2 AND kind = 'file'-- STMT_SELECT_ALL_SERVER_EXCLUDED_NODES SELECT local_relpath FROM nodes WHERE wc_id = ?1 AND (?2 = '' OR local_relpath = ?2 OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2)) AND op_depth = 0 AND presence = 'absent'SELECT local_dir_relpath, locked_levels FROM wc_lock WHERE wc_id = ?1 AND ((local_dir_relpath <= ?2 AND local_dir_relpath >= ?3) OR local_dir_relpath = '') ORDER BY local_dir_relpath DESCSELECT 1 FROM nodes WHERE checksum = ?1 OR checksum = ?2 UNION ALL SELECT 1 FROM actual_node WHERE older_checksum = ?1 OR older_checksum = ?2 OR left_checksum = ?1 OR left_checksum = ?2 OR right_checksum = ?1 OR right_checksum = ?2 LIMIT 1-- STMT_SELECT_BASE_DAV_CACHE SELECT dav_cache FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0SELECT repos_id, repos_path, presence, kind, revision, checksum, translated_size, changed_revision, changed_date, changed_author, depth, symlink_target, last_mod_time, properties FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;SELECT local_relpath FROM nodes WHERE wc_id = ?1 AND parent_relpath = ?2 AND op_depth = 0;SELECT nodes.repos_id, nodes.repos_path, presence, kind, revision, checksum, translated_size, changed_revision, changed_date, changed_author, depth, symlink_target, last_mod_time, properties, lock_token, lock_owner, lock_comment, lock_date FROM nodes LEFT OUTER JOIN lock ON nodes.repos_id = lock.repos_id AND nodes.repos_path = lock.repos_relpath WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;SELECT local_relpath, kind FROM nodes n WHERE wc_id = ?1 AND IS_STRICT_DESCENDANT_OF(local_relpath, ?2) AND op_depth = 0 AND presence in (MAP_NORMAL, MAP_INCOMPLETE) AND NOT EXISTS(SELECT 1 FROM NODES w WHERE w.wc_id = ?1 AND w.local_relpath = n.local_relpath AND op_depth > 0) ORDER BY local_relpath DESCSELECT properties FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;STMT_SELECT_CHANGELIST_LIST SELECT wc_id, local_relpath, notify, changelist FROM changelist_list ORDER BY wc_id, local_relpathSELECT local_relpath, kind, def_repos_relpath, (SELECT root FROM repository AS r WHERE r.id = e.repos_id) FROM externals e WHERE wc_id = ?1 AND IS_STRICT_DESCENDANT_OF(e.local_relpath, ?2) AND parent_relpath = ?2 AND def_revision IS NULL AND repos_id = (SELECT repos_id FROM nodes AS n WHERE n.wc_id = ?1 AND n.local_relpath = '' AND n.op_depth = 0) AND ((kind='dir') OR EXISTS (SELECT 1 FROM nodes WHERE nodes.wc_id = e.wc_id AND nodes.local_relpath = e.parent_relpath))SELECT prop_reject, conflict_old, conflict_new, conflict_working, tree_conflict_data FROM actual_node WHERE wc_id = ?1 AND local_relpath = ?2;SELECT n.checksum, md5_checksum, size FROM nodes_current n LEFT JOIN pristine p ON n.checksum = p.checksum WHERE wc_id = ?1 AND n.local_relpath = ?2 AND n.checksum IS NOT NULL UNION ALL SELECT n.checksum, md5_checksum, size FROM nodes n LEFT JOIN pristine p ON n.checksum = p.checksum WHERE wc_id = ?1 AND IS_STRICT_DESCENDANT_OF(n.local_relpath, ?2) AND op_depth >= (SELECT MAX(op_depth) FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2) AND n.checksum IS NOT NULLSELECT (SELECT b.presence FROM nodes AS b WHERE b.wc_id = ?1 AND b.local_relpath = ?2 AND b.op_depth = 0), work.presence, work.op_depth FROM nodes_current AS work WHERE work.wc_id = ?1 AND work.local_relpath = ?2 AND work.op_depth > 0 LIMIT 1SELECT repos_id, repos_path, presence, kind, revision, checksum, translated_size, changed_revision, changed_date, changed_author, depth, symlink_target, last_mod_time, properties FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3SELECT IFNULL((SELECT properties FROM actual_node a WHERE a.wc_id = ?1 AND A.local_relpath = n.local_relpath), properties), local_relpath, depth FROM nodes n WHERE wc_id = ?1 AND (?2 = '' OR local_relpath = ?2 OR (local_relpath > ?2 || '/' AND local_relpath < ?2 || '0')) AND kind = 'dir' AND presence='normal' AND op_depth=(SELECT MAX(op_depth) FROM nodes o WHERE o.wc_id = ?1 AND o.local_relpath = n.local_relpath)SELECT local_relpath, def_local_relpath FROM externals WHERE wc_id = ?1 AND (?2 = '' OR def_local_relpath = ?2 OR (def_local_relpath > ?2 || '/' AND def_local_relpath < ?2 || '0'))SELECT file_external FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;SELECT 1 FROM nodes WHERE wc_id = ?1 AND IS_STRICT_DESCENDANT_OF(parent_relpath, ?2) AND op_depth = 0 AND file_external IS NULLSELECT 1 FROM nodes WHERE wc_id = ?1 AND parent_relpath = ?2 AND op_depth = 0 AND kind != MAP_FILESELECT local_relpath, repos_path FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0 AND (inherited_props not null)SELECT op_depth, presence, kind, moved_to FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth > ?3 ORDER BY op_depth LIMIT 1SELECT MIN(revision), MAX(revision), MIN(changed_revision), MAX(changed_revision) FROM nodes WHERE wc_id = ?1 AND (local_relpath = ?2 OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2)) AND presence IN (MAP_NORMAL, MAP_INCOMPLETE) AND file_external IS NULL AND op_depth = 0SELECT local_relpath, moved_to, op_depth, (SELECT CASE WHEN r.moved_here THEN r.op_depth END FROM nodes r WHERE r.wc_id = ?1 AND r.local_relpath = n.local_relpath AND r.op_depth < n.op_depth BY r.op_depth DESC LIMIT 1) AS moved_here_op_depth FROM nodes n WHERE wc_id = ?1 AND (local_relpath = ?2 OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2)) AND moved_to IS NOT NULL AND op_depth >= ?3SELECT local_relpath, op_depth, (SELECT CASE WHEN r.moved_here THEN r.op_depth END FROM nodes r WHERE r.wc_id = ?1 AND r.local_relpath = n.local_relpath AND r.op_depth < n.op_depth ORDER BY r.op_depth DESC LIMIT 1) AS moved_here_op_depth FROM nodes n WHERE wc_id = ?1 AND moved_to = ?2 AND op_depth > 0SELECT local_relpath, op_depth FROM nodes WHERE wc_id = ?1 AND moved_to = ?2 AND op_depth > 0SELECT moved_to, local_relpath FROM nodes WHERE wc_id = ?1 AND op_depth > 0 AND IS_STRICT_DESCENDANT_OF(moved_to, ?2)SELECT local_relpath, moved_to FROM nodes WHERE wc_id = ?1 AND (local_relpath = ?2 OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2)) AND op_depth >= ?3 AND moved_to IS NOT NULL AND NOT IS_STRICT_DESCENDANT_OF(moved_to, ?2)SELECT local_relpath, moved_to, op_depth, kind FROM nodes WHERE wc_id = ?1 AND (local_relpath = ?2 OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2)) AND op_depth > ?3 AND moved_to IS NOT NULLSELECT moved_to FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3SELECT op_depth, nodes.repos_id, nodes.repos_path, presence, kind, revision, checksum, translated_size, changed_revision, changed_date, changed_author, depth, symlink_target, last_mod_time, properties, lock_token, lock_owner, lock_comment, lock_date, local_relpath FROM nodes LEFT OUTER JOIN lock ON nodes.repos_id = lock.repos_id AND nodes.repos_path = lock.repos_relpath WHERE wc_id = ?1 AND parent_relpath = ?2SELECT local_relpath, op_depth, presence, kind FROM nodes WHERE wc_id = ?1 AND parent_relpath = ?2 GROUP BY local_relpath ORDER BY op_depth DESC We omit GROUP BY, it is not really needed, and ORDER BY is achieved by use of a reverse cursor.SELECT op_depth, repos_id, repos_path, presence, kind, revision, checksum, translated_size, changed_revision, changed_date, changed_author, depth, symlink_target, last_mod_time, properties FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 ORDER BY op_depth DESCSELECT op_depth, nodes.repos_id, nodes.repos_path, presence, kind, revision, checksum, translated_size, changed_revision, changed_date, changed_author, depth, symlink_target, last_mod_time, properties, lock_token, lock_owner, lock_comment, lock_date FROM nodes LEFT OUTER JOIN lock ON nodes.repos_id = lock.repos_id AND nodes.repos_path = lock.repos_relpath WHERE wc_id = ?1 AND local_relpath = ?2 ORDER BY op_depth DESCSELECT properties, presence FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 ORDER BY op_depth DESC;-- STMT_SELECT_NOT_PRESENT_DESCENDANTS SELECT local_relpath FROM nodes WHERE wc_id = ?1 AND op_depth = ?3 AND (parent_relpath = ?2 OR IS_STRICT_DESCENDANT_OF(parent_relpath, ?2)) AND presence == 'not-present'SELECT local_relpath FROM nodes WHERE wc_id = ?1 AND parent_relpath = ?2 AND op_depth = ?3;SELECT md5_checksum FROM pristine WHERE checksum = ?1SELECT id FROM repository WHERE root = ?1;select root, uuid from repository where id = ?1;SELECT checksum FROM pristine WHERE md5_checksum = ?1SELECT local_relpath FROM targets_list WHERE kind = 'file' AND wc_id = ?1-- STMT_SELECT_UNREFERENCED_PRISTINES SELECT checksum FROM pristine WHERE refcount = 0SELECT locked_levels FROM WC_LOCK WHERE wc_id = ?1 AND local_dir_relpath = ?2;select id from wcroot where local_abspath is null;SELECT local_relpath FROM nodes WHERE wc_id = ?1 AND parent_relpath = ?2 AND (op_depth > (SELECT MAX(op_depth) FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2) OR (op_depth = (SELECT MAX(op_depth) FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2) AND presence != 'base-deleted'))SELECT presence, kind, checksum, translated_size, changed_revision, changed_date, changed_author, depth, symlink_target, repos_id, repos_path, revision, moved_here, moved_to, last_mod_time, properties FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth > 0 ORDER BY op_depth DESC LIMIT 1;SELECT local_relpath FROM nodes WHERE wc_id = ?1 AND parent_relpath = ?2 AND (op_depth > (SELECT MAX(op_depth) FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2) OR (op_depth = (SELECT MAX(op_depth) FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2) AND presence != 'base-deleted'))SELECT id, work FROM work_queue ORDER BY id LIMIT 1;UPDATE actual_node SET changelist = ?3 WHERE wc_id = ?1 AND local_relpath = ?2UPDATE actual_node SET conflict_data = ?3 WHERE wc_id = ?1 AND local_relpath = ?2;UPDATE actual_node SET prop_reject = ?3 WHERE wc_id = ?1 AND local_relpath = ?2;UPDATE actual_node SET properties = ?3 WHERE wc_id = ?1 AND local_relpath = ?2;UPDATE actual_node SET conflict_old = ?3, conflict_new = ?4, conflict_working = ?5 WHERE wc_id = ?1 AND local_relpath = ?2;UPDATE actual_node SET tree_conflict_data = ?3 WHERE wc_id = ?1 AND local_relpath = ?2;-- STMT_UPDATE_BASE_NODE_DAV_CACHE UPDATE nodes SET dav_cache = ?3 WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0UPDATE nodes SET revision = ?3 WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;UPDATE nodes SET repos_id = ?3, repos_path = ?4 WHERE wc_id = ?1 AND local_relpath = ?2; AND op_depth = (SELECT MAX(op_depth) FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth > 0);UPDATE nodes SET moved_to = RELPATH_SKIP_JOIN(?2, ?3, moved_to) WHERE wc_id = ?1 AND IS_STRICT_DESCENDANT_OF(moved_to, ?2)UPDATE nodes SET moved_to = ?4 WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3UPDATE nodes SET depth = ?3 WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;UPDATE nodes SET presence = ?3 WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;UPDATE nodes SET translated_size = ?3, last_mod_time = ?4 WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = (SELECT MAX(op_depth) FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2);-- STMT_UPDATE_NODE_PROPS UPDATE nodes SET properties = ?4 WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3UPDATE nodes SET depth = ?3 WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = (SELECT MAX(op_depth) FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth > 0);