Uploaded image for project: 'Apache Trafodion'
  1. Apache Trafodion
  2. TRAFODION-2127 enhance Trafodion implementation of WITH clause
  3. TRAFODION-2317

Implement relational operator for common subexpressions and transformation

    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Major
    • Resolution: Implemented
    • Affects Version/s: 2.1-incubating
    • Fix Version/s: 2.2.0
    • Component/s: sql-cmp
    • Labels:
      None

      Description

      This subtask provides the infrastructure for handling common subexpressions:

      • A relational CommonSubExprRef operator to track the locations of common subexpressions in the query tree.
      • Methods to analyze the common subexpressions in the tree and to determine whether a transformation is possible and what the temporary table would look like.
      • Methods to do the actual query tree transformation.
      • Some needed changes in bookkeeping and runtime.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                hzeller Hans Zeller
                Reporter:
                hzeller Hans Zeller
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: