Procedure: nornix_site.find_sibling_docs

Information
DeterministicData accessMode
NOREADS SQL DATA

Code

Find siblings of document

CREATE DEFINER=`root`@`localhost` PROCEDURE `find_sibling_docs`(IN vNo INTEGER)
    READS SQL DATA
    COMMENT 'Find siblings of document'
BEGIN
 DECLARE l, r, levl, parent INTEGER;
 SET parent = find_parent_doc(vNo);
 SELECT Lft, Rgt, (`Level` + 1) INTO l, r, levl FROM document WHERE `No` = parent;
 SELECT *
 FROM document
 WHERE `No` != vNo AND `Level` = levl AND Lft > l AND Rgt < r
 ORDER BY Lft;
END