SQL Writer Semantics for No Partitioning Support

Valid example queries when the UDF does not support any partitioning.

Example 1

SELECT * FROM my_tpf( 
  TABLE( SELECT T.x, T.y FROM T )
  OVER( PARTITION BY ANY )

In this example, the SQL writer requests PARTITION BY ANY partitioning. However, the UDF does not support any partitioning, and as a result, the server executes the query without runtime partitioning.

Example 2

SELECT * FROM my_tpf( 
  TABLE( SELECT T.x, T.y FROM T )

SELECT * FROM my_tpf( 
  TABLE( SELECT T.x, T.y FROM T )
  OVER ( PARTITION BY DEFAULT )

This example shows that the SQL writer does not include the PARTITION BY clause or the PARTITION BY DEFAULT clause. The server uses the partition requested by the UDF and since the UDF does not supports any partitioning, the server executes the query without performing any partitioning.

Example 3

SELECT * FROM my_tpf( 
  TABLE( SELECT T.x, T.y FROM T )
  OVER( NO PARTITION BY )

In this example, the SQL writer requests no partitioning, and as a result, the server executes the query without runtime partitioning.