MySQL Forums
Forum List  »  MySQL Workbench

SELECT statements throw MySQL Workbench into an infinite loop under MacOS 10.13
Posted by: Walter Griffith
Date: October 09, 2017 12:00PM

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

Options: ReplyQuote




Sorry, only registered users may post in this forum.

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.