SQL Exceptions for No Partitioning Support

Invalid example queries, because the UDF does not support any partitioning. Each example raises a SQL exception.

Example 1

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

This example results in a SQL error because the SQL writer requested partitioning on column T.x, and the UDF does not support any partitioning on any columns.

Example 2

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

This example results in a SQL error because the SQL writer requested partitioning on column T.y, and the UDF does not support any partitioning on any columns.

Example 3

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

This example results in a SQL error because the SQL writer requested partitioning on columns T.y and T.x, and the UDF does not support any partitioning on any columns.