Details
-
Sub-task
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
None
Description
Add a user-defined table function that has a count column N, and a number of other columns, and for each row, produces N copies of that row.
The purpose of this table function is to implement INTERSECT ALL and EXCEPT ALL. Observe that if have a table 'five' with 5 rows with the value 'x', and a table 'three' with 3 rows with the value 'x', then five INTERSECT ALL three will need to emit min(5, 3)) rows, and five EXCEPT ALL three will emit 5 - 3 rows.