select filename from inode where filename > ‘/tmp’ and filename < ‘/tmq’ and sentinel = ‘x’;
Wouldn't that return files from directories '/tmp1', '/tmp2', for example? I thought the goal was to return files and subdirectories recursively inside '/tmp'.
If we store the slash with the parent_path, so '/tmp/', maybe we can search for:
select filename from inode where filename >= ‘/tmp/’ and filename < ‘/tmp0’ and sentinel = ‘x’;
Would this work?