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 /Source | |
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)
Diffstat (limited to 'Source')
-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) { |