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