|Workbench 8.0.15 will draw the polygon with the Spatial View Option|
So how do you get there?
Start Workbench, create a new SQL Tab in your favorite scratch schema, and crate the table below.
CREATE TABLE `test` (
`id` INT NOT NULL AUTO_INCREMENT,
`geom` GEOMETRY NULL,
PRIMARY KEY (`id`));
Next add some data.
INSERT INTO `test`
('polygon((0 0,0 3,3 0, 2 2,0 0),(1 1,1 2,2 1,2 2, 1 1))')
The run the query.
select geom from test;
However the result will default to the Result Grid. Look off to the right hand side of the results window to see a series of stacked icons and the default is the Result Grid. And that 'BLOB' is the result of the query. But that result is not exactly visually stunning.
|The 'BLOB' is the result of the query.|
Click on the Form Editor icon. It is directly below the Result Grid Icon
|Select the Form Editor Icon|
Now scroll down below the Form Editor icon and select Spatial View.
|Spatial View of the Query|