Cycles in NTree - Teradata Vantage

A cycle is unidirectional; that is, the output can be different for Mode('up') and Mode('down'). For example, consider this table:

This query returns the following table:

SELECT * FROM NTree@coprocessor (
  ON emp_table_dept
  PARTITION BY department
  ORDER BY order_column
  Root_Node (mgr_id = 'none')
  Parent_ID (mgr_id)
  Node_ID (id)
  Starts_With (id = '11')
  "Mode" ('up')
  "Output" ('end')
  "Result" (PATH (name) AS path, path (id) AS path2, IS_CYCLE (*))
  AllowCycles ('true')
) ORDER BY path, path2;

If you specify "Mode('down')" in the preceding query, it returns the following table.