+ " UNION "\r
+ " SELECT c.id, depth + 1 "\r
+ " FROM fragment c INNER JOIN parent_search p ON c.parent_id = p.id"\r
- + " WHERE depth <= (SELECT CASE WHEN :maxDepth = -1 THEN " + Integer.MAX_VALUE + " ELSE :maxDepth END) "\r
+ + " WHERE depth < (SELECT CASE WHEN :maxDepth = -1 THEN " + Integer.MAX_VALUE + " ELSE :maxDepth END) "\r
+ ") "\r
+ "SELECT f.id, anchor_id AS anchorId, xpath, f.parent_id AS parentId, CAST(attributes AS TEXT) AS attributes "\r
+ "FROM fragment f INNER JOIN parent_search p ON f.id = p.id",\r
+ " UNION "\r
+ " SELECT c.id, depth + 1 "\r
+ " FROM fragment c INNER JOIN parent_search p ON c.parent_id = p.id"\r
- + " WHERE depth <= (SELECT CASE WHEN :maxDepth = -1 THEN " + Integer.MAX_VALUE + " ELSE :maxDepth END) "\r
+ + " WHERE depth < (SELECT CASE WHEN :maxDepth = -1 THEN " + Integer.MAX_VALUE + " ELSE :maxDepth END) "\r
+ ") "\r
+ "SELECT f.id, anchor_id AS anchorId, xpath, f.parent_id AS parentId, CAST(attributes AS TEXT) AS attributes "\r
+ "FROM fragment f INNER JOIN parent_search p ON f.id = p.id",\r