From d3ac918c1d066800b32e023658aeb75aadef804f Mon Sep 17 00:00:00 2001 From: Max Lohrmann Date: Sat, 10 Jun 2017 18:31:18 +0200 Subject: Fix an error where Sequel Pro would crash when loading the list of Stored Procs/Funcs (probably related to MySQL 5.8/8.0) --- Source/SPTablesList.m | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'Source') 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) { -- cgit v1.2.3