From 9fa1aca5bf60469daf8b86b4f31af7ecfdb7893f Mon Sep 17 00:00:00 2001 From: stuconnolly Date: Sun, 1 Nov 2009 01:09:41 +0000 Subject: When checking the existance of the ENGINES table within the information_schema database, use its exact name case-wise, to avoid problems on case sensitive filesystems (i.e. linux). --- Source/SPDatabaseData.m | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'Source') diff --git a/Source/SPDatabaseData.m b/Source/SPDatabaseData.m index dc5bf05c..d10b9107 100644 --- a/Source/SPDatabaseData.m +++ b/Source/SPDatabaseData.m @@ -300,7 +300,7 @@ const CHAR_SETS charsets[] = * Returns all of the database's available storage engines. */ - (NSArray *)getDatabaseStorageEngines -{ +{ if ([storageEngines count] == 0) { if ([connection serverMajorVersion] < 5) { [storageEngines addObject:[NSDictionary dictionaryWithObject:@"MyISAM" forKey:@"Engine"]]; @@ -348,7 +348,7 @@ const CHAR_SETS charsets[] = ([connection serverReleaseVersion] >= 5)) { // Check the information_schema.engines table is accessible - MCPResult *result = [connection queryString:@"SHOW TABLES IN information_schema LIKE 'engines'"]; + MCPResult *result = [connection queryString:@"SHOW TABLES IN information_schema LIKE 'ENGINES'"]; if ([result numOfRows] == 1) { // Table is accessible so get available storage engines -- cgit v1.2.3