Querying using [mode:derivedFrom] path for sequenced nodes, yields no results

After a node has been sequenced and the output placed in another location than the original node (i.e. an output path has been configured), issuing the following query:

SELECT [jcr:path] 
FROM [mode:derived] AS d 
WHERE d.[mode:derivedFrom] IN (
  SELECT u.[jcr:path] FROM [nt:unstructured] as u
)

produces 0 results.

It should always produce at least 1 result, possibly more, depending on the number of nodes that have been sequenced.