So approximately a SQL standard (aggregation "tree-climb") combined with a non-standard (LIMIT) which prevents an error yield an unexpected behavior.