diff options
| author | Max Lohrmann <dmoagx@users.noreply.github.com> | 2017-06-10 18:31:18 +0200 |
|---|---|---|
| committer | Max Lohrmann <dmoagx@users.noreply.github.com> | 2017-06-10 18:31:18 +0200 |
| commit | d3ac918c1d066800b32e023658aeb75aadef804f (patch) | |
| tree | 5a95283c3f252adab6a1466b88c664b0634b4588 | |
| parent | 38d40d03969967a186ec57f86cd257ff4dab9fd0 (diff) | |
| download | sequelpro-d3ac918c1d066800b32e023658aeb75aadef804f.tar.gz sequelpro-d3ac918c1d066800b32e023658aeb75aadef804f.tar.bz2 sequelpro-d3ac918c1d066800b32e023658aeb75aadef804f.zip | |
Fix an error where Sequel Pro would crash when loading the list of Stored Procs/Funcs (probably related to MySQL 5.8/8.0)
| -rw-r--r-- | Source/SPTablesList.m | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/Source/SPTablesList.m b/Source/SPTablesList.m index 27810898..c75198b7 100644 --- a/Source/SPTablesList.m +++ b/Source/SPTablesList.m @@ -232,7 +232,8 @@ static NSString *SPDuplicateTable = @"SPDuplicateTable"; NSString *pQuery = [NSString stringWithFormat:@"SELECT * FROM information_schema.routines WHERE routine_schema = %@ ORDER BY routine_name", [[tableDocumentInstance database] tickQuotedString]]; theResult = [mySQLConnection queryString:pQuery]; [theResult setDefaultRowReturnType:SPMySQLResultRowAsArray]; - + [theResult setReturnDataAsStrings:YES]; //see tables above + // Check for mysql errors - if information_schema is not accessible for some reasons // omit adding procedures and functions if(![mySQLConnection queryErrored] && theResult != nil && [theResult numberOfRows] && [theResult numberOfFields] > 3) { |