dynamobi/dynamobi — Issue #560: [FRG-312] create index on existing data should not hold catalog lock during execution
Author: dynamobi-build
Created: 2011-12-30 03:35:16+00:00
State: open
Labels: DDL, FRG

[reporter="jvs", created="Tue, 4 Mar 2008 16:43:53 -0500 (GMT-05:00)"]
Should take lock at beginning to update catalog, store index definition, and mark it as build-pending, then drop lock; then after execution, update state to reflect completion. Optimizer has to avoid trying to use index while build-pending, and if a crash occurs, need to figure out how to deal with the bad index.