Details

    • Type: Sub-task
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      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.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              pxiong Pengcheng Xiong
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: