Cycles in nTree - Aster Analytics

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

This query, which specifies Mode('up'), outputs the following table:

SELECT * FROM nTree (
  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 (*))
  Allow_Cycles ('true')
) ORDER BY path, path2;

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