Eric Herman wrote:

What is the proper behavior?

Anyone know what other database do?

HADB is basically transactional in it's DDL, but some operations must be run in auto-commit mode. This is because of a limitation in the transaction machinery when a "catchup" is needed after a table transformation. This is needed by an online ALTER TABLE or CREATE/DROP INDEX. Then we throw an exception when in manual commit mode.

Techra (another database I was involved in) had transactional DDL except for file creation operations (for CREATE TABLESPACE type of command) :(

Roy

_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to