SELECT statements throw MySQL Workbench into an infinite loop under MacOS 10.13
SELECT statements cause Workbench 6.3.9 to go into an infinite loop under MacOS 10.13 (High Sierra). This does not happen if the same SELECT is typed into the MySQL shell (i.e. run the mysql command from a terminal window). This behavior
began when I upgraded from MacOS Sierra 10.12.6 to 10.13.
Sample Database:
SHOW CREATE TABLE gives nothing under Workbench
FROM the mysql shell I get:
+----------+--------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+----------+--------------------------------------------------------------------------------------------------------------------------+
| somedata | CREATE TABLE `somedata` (
`numbers` int(11) NOT NULL,
PRIMARY KEY (`numbers`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+----------+--------------------------------------------------------------------------------------------------------------------------+
A single record is created by INSERT INTO somedata (numbers) VALUES(1);
The desired output is a single record containing the number 1.
Under Workbench, SELECT Version() goes into an infinite loop.
Under the Mysql Shell, Select Version() gives 5.7.19
Running SELECT * FROM somedata; under Workbench causes an infinite loop.
Running SELECT * FROM somedata; under the Mysql shell gives the desired output.
Walter ("Larry") Griffith
Subject
Views
Written By
Posted
SELECT statements throw MySQL Workbench into an infinite loop under MacOS 10.13
1208
October 09, 2017 12:00PM
660
October 10, 2017 06:36AM
695
October 11, 2017 11:17AM
594
October 11, 2017 07:44PM
413
December 15, 2017 12:12PM
558
October 20, 2017 02:26AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.