Fixes for issue #1098:

- Fix logic for enabling/disabling the index storage type popup button when changing the index type.
- Add a number formatter to the index length field.

1 files changed, 4 insertions, 3 deletions

diff --git a/Source/SPIndexesController.m b/Source/SPIndexesController.m
index f045c9b3..8058ff3f 100644
--- a/Source/SPIndexesController.m
+++ b/Source/SPIndexesController.m
@@ -150,13 +150,12 @@ static const NSString *SPNewIndexKeyBlockSize   = @"IndexKeyBlockSize";
  */
 - (IBAction)addIndex:(id)sender
 {
-
 	// Check whether table editing is permitted (necessary as some actions - eg table double-click - bypass validation)
 	if ([dbDocument isWorking] || [tablesList tableType] != SPTableTypeTable) return;
 	
 	// Check whether a save of the current field row is required.
 	if (![tableStructure saveRowOnDeselect]) return;
-
+	
 	// Reset visibility of the primary key item
 	[[[indexTypePopUpButton menu] itemWithTag:SPPrimaryKeyMenuTag] setHidden:NO];
 
@@ -340,8 +339,10 @@ static const NSString *SPNewIndexKeyBlockSize   = @"IndexKeyBlockSize";
 		}
 		
 #ifndef SP_REFACTOR
+		NSString *engine = [[tableData statusValues] objectForKey:@"Engine"];
+		
 		// Specifiying an index storage type (i.e. HASH or BTREE) is not permitted with SPATIAL indexes
-		[indexStorageTypePopUpButton setEnabled:(indexType != SPSpatialMenuTag)];
+		[indexStorageTypePopUpButton setEnabled:(indexType != SPSpatialMenuTag) && !([engine isEqualToString:@"MyISAM"] || [engine isEqualToString:@"InnoDB"])];
 #endif
 	}
 }