Bug #92642 Results Grid does now show
Submitted: 2 Oct 2018 19:08 Modified: 2 Oct 2018 20:34
Reporter: Jeff Chen Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:8.0.12 OS:MacOS (macOS 10.13.x High Sierra x86_64)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[2 Oct 2018 19:08] Jeff Chen
Description:
11:52:37 [INF][      Workbench]: Starting up Workbench
11:52:37 [INF][   WBContext UI]: Initializing workbench context UI with these values:
	base dir: /Applications/MySQLWorkbench.app/Contents/Resources
	plugin path: /Applications/MySQLWorkbench.app/Contents/PlugIns
	struct path: /Applications/MySQLWorkbench.app/Contents/Resources/grt
	module path: /Applications/MySQLWorkbench.app/Contents/PlugIns:/Applications/MySQLWorkbench.app/Contents/Resources/plugins
	library path: /Applications/MySQLWorkbench.app/Contents/Resources/libraries
	user data dir: /Users/chenje02/Library/Application Support/MySQL/Workbench
	open at start: 
	open type: 
	run at startup: 
	run type: 
	Force SW rendering: No
	Force OpenGL: No
	quit when done: No
11:52:37 [INF][      WBContext]: WbContext::init
11:52:37 [INF][            WBA]: Looking for extension modules for WBA...
11:52:37 [INF][            WBA]: 0 extension modules found
11:52:37 [WRN][            grt]: /Applications/MySQLWorkbench.app/Contents/Resources/modules/data/mysql_rdbms_info.xml:1401: link 'om.mysql.rdbms.mysql.driver.native_sshtun' <object > key=owner could not be resolved
11:52:37 [WRN][            grt]: /Users/chenje02/Library/Application Support/MySQL/Workbench/connections.xml:26: link '00881E77-2AE0-4D47-936D-4BCFB19F2347' <object GrtObject> key=owner could not be resolved
11:52:37 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Mac OS X version 8.0.12 CE build 13312926 (64 bit)
	Configuration Directory: /Users/chenje02/Library/Application Support/MySQL/Workbench
	Data Directory: /Applications/MySQLWorkbench.app/Contents/Resources
	Cairo Version: 1.10.2
	OS: macOS 10.13.x High Sierra x86_64
	CPU: 8x Intel(R) Core(TM) i7-6820HQ CPU @ 2.70GHz - 16.00GiB RAM
No video adapter info available

11:52:40 [INF][SQL Editor Form]: Opened connection 'Live Db' to MySQL Community Server (GPL) version 5.6.35-log
11:53:12 [ERR][SQL Editor Form]: Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
11:53:30 [WRN][SQL Editor Form]: 0 row(s) affected, 1 warning(s):
1050 Table 'TempAvailableClients' already exists
11:53:37 [ERR][SQL Editor Form]: Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
11:53:49 [ERR][SQL Editor Form]: Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
11:55:52 [ERR][SQL Editor Form]: Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
11:56:03 [INF][SQL Editor Form]: Opened connection 'Live Db' to MySQL Community Server (GPL) version 5.6.35-log
11:58:38 [ERR][SQL Editor Form]: Error Code: 1146. Table 'SolarDb.AvailableClients2' doesn't exist
11:59:26 [ERR][      WBContext]: WBContext: exception in flush idle task: Exception: 
11:59:36 [ERR][SQL Editor Form]: Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GetCallTypeselect a.*, IFNULL(b.LastSale, '2000-01-01')  as LastSale
from TempAv' at line 1
11:59:55 [ERR][SQL Editor Form]: Error Code: 1146. Table 'SolarDb.TempAvailableClients2' doesn't exist
12:00:18 [ERR][SQL Editor Form]: Error Code: 1146. Table 'SolarDb.TempAvailableClients2' doesn't exist
12:00:45 [WRN][SQL Editor Form]: 0 row(s) affected, 1 warning(s):
1050 Table 'TempAvailableClients' already exists
12:03:00 [ERR][      utilities]: Could not open URL http://bugs.mysql.com/report.php?in[status]=Open&in[php_version]=8.0.12&in[os]=6&in[os_det... 10.13.x High Sierra x86_64&in[tags]=WBBugReporter&in[really]=0&in[ldesc]=----[For better reports, please attach the log file after submitting. You can find it in /Users/chenje02/Library/Application Support/MySQL/Workbench/log/wb.log]

How to repeat:
Everytime i run a SQL query that produces an error, if i fix the query and it runs successfully, the result grid does now show, unless i restart SQL workbench completely.

This started happening when i upgraded my Mac OS to High Sierra 10.13.2.

I tried uninstalling SQL workbench and reinstalling.  Still same problems.

Suggested fix:
Please help fix!
[2 Oct 2018 20:34] MySQL Verification Team
Thank you for the report.
This is duplicate of Bug #91265, please see Bug #91265