aboutsummaryrefslogtreecommitdiffstats
path: root/Source
diff options
context:
space:
mode:
authorMax Lohrmann <dmoagx@users.noreply.github.com>2017-06-10 18:31:18 +0200
committerMax Lohrmann <dmoagx@users.noreply.github.com>2017-06-10 18:31:18 +0200
commitd3ac918c1d066800b32e023658aeb75aadef804f (patch)
tree5a95283c3f252adab6a1466b88c664b0634b4588 /Source
parent38d40d03969967a186ec57f86cd257ff4dab9fd0 (diff)
downloadsequelpro-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.m3
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) {