Apply a tweaked version of a patch by Aaron Linville (http://www.linville.org/) to handle table linking in .dot exports on case-insensitive servers:

 - Adds a new checkbox on the .dot export interface controlling the case sensitivty of link handling
 - Improve .dot export to use lowercase link references when the option is enabled, fixing .dot exports of table relations of table names with uppercase characters on case-insensitive servers
 - Check the server's case-sensitivity setting and use that to control the checkbox when using the export interface to select .dot export
This addresses Issue #920.

1 files changed, 16 insertions, 2 deletions

diff --git a/Source/SPExportController.m b/Source/SPExportController.m
index 755a4f74..1d70f88f 100644
--- a/Source/SPExportController.m
+++ b/Source/SPExportController.m
@@ -93,7 +93,8 @@ static const NSString *SPTableViewDropColumnID      = @"drop";
 		
 		showAdvancedView = NO;
 		showCustomFilenameView = NO;
-		
+		serverLowerCaseTableNameValue = NSNotFound;
+
 		heightOffset1 = 0;
 		heightOffset2 = 0;
 		windowMinWidth = [[self window] minSize].width;
@@ -706,10 +707,23 @@ static const NSString *SPTableViewDropColumnID      = @"drop";
 	// Set the tooltip
 	[[exportTableList tableColumnWithIdentifier:SPTableViewContentColumnID] setHeaderToolTip:(enable) ? @"" : NSLocalizedString(@"Include content", @"include content table column tooltip")];
 	
+	// When switching to Dot export, ensure the server's lower_case_table_names value is checked the first time
+	// to set the export's link case sensitivity setting
+	if (isDot && serverLowerCaseTableNameValue == NSNotFound) {
+		MCPResult *caseResult = [connection queryString:@"SHOW VARIABLES LIKE 'lower_case_table_names'"];
+		[caseResult setReturnDataAsStrings:YES];
+		if ([caseResult numOfRows] == 1) {
+			serverLowerCaseTableNameValue = [[[caseResult fetchRowAsDictionary] objectForKey:@"Value"] integerValue];
+		} else {
+			serverLowerCaseTableNameValue = 0;
+		}
+		[exportDotForceLowerTableNamesCheck setState:(serverLowerCaseTableNameValue == 0)?NSOffState:NSOnState];
+	}
+
 	[exportCSVNULLValuesAsTextField setStringValue:[prefs stringForKey:SPNullValue]]; 
 	[exportXMLNULLValuesAsTextField setStringValue:[prefs stringForKey:SPNullValue]];
 	
-	[self _displayExportTypeOptions:(isSQL || isCSV || isXML)];
+	[self _displayExportTypeOptions:(isSQL || isCSV || isXML || isDot)];
 	[self updateAvailableExportFilenameTokens];
 	
 	if (!showCustomFilenameView) [self updateDisplayedExportFilename];