[TRAFODION-1798] Support Transactions for DDL statements

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0-incubating
• External issue URL: https://blueprints.launchpad.net/trafodion/+spec/dtm-ddl-support
• Assignee: Prashanth Vasudev
• Reporter: Prashanth Vasudev
• Created: 01/Feb/16 22:56
• Updated: 15/Sep/18 07:30
• Resolved: 13/May/16 00:09

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.

Issue Links

• Dependent: TRAFODION-979 LP Bug: 1418142 - Parallel DDL operations sees error 8810