Uploaded image for project: 'Apache Trafodion'
  1. Apache Trafodion
  2. TRAFODION-1798

Support Transactions for DDL statements

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.0-incubating
    • Component/s: None
    • Labels:
      None

      Description

      This work to support transaction for DDL operations started before Trafodion became part of incubation as Apache Trafodion. The initial link to the blueprint is https://blueprints.launchpad.net/trafodion/+spec/dtm-ddl-support

      Some of the implementation to support this feature is already in code base, however there are some more additional changes needed to support completely.
      Additional changes include:

      0. Enable existing transactional DDL support in transaction manager. Also enable corresponding regression test.
      1. SQL executor changes to leverage transactional DDL support by transaction manager.
      2. Issue with simultaneous transactional update to the table followed by drop. This manifests as a hang when a drop schema is performed.
      3. Recovery in case of HA failure scenario.

        Attachments

        1. TransactionsDDL_Apache.pdf
          697 kB
          Prashanth Vasudev

          Issue Links

            Activity

              People

              • Assignee:
                vasudevp Prashanth Vasudev
                Reporter:
                vasudevp Prashanth Vasudev
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: