When invoking table function, should OrderBy clause in table argument subquery be ignored?

[Cpaulyz]

I used the RepeatFunction(https://github.com/trinodb/trino/blob/master/core/trino-main/src/test/java/io/trino/connector/TestingTableFunctions.java#L693) for test.

When invoking table function with order by clause in table argument subquery, I noticed that the order by clause will be ignored.
For example, in the SQL below, ORDER BY invocations desc will be ignored and report that WARNING: ORDER BY in subquery may have no effect

select * from TABLE(repeat(
  input => TABLE(
    select * 
    from system.runtime.optimizer_rule_stats
    ORDER BY invocations desc
  ) PARTITION BY matches, 
  N => 2));

I wonder that if this is as expected? If it's a bug, I'd like to help fix it!

[hashhar]

This is expected and not a bug.

Any order by in subquery is ignored, if you use a normal subquery without using the PTF you'll see the same warning.