Bug #75318 Spatial viewer resolution for larger shapes

• Submitted: 27 Dec 2014 19:14
• Modified: 22 May 2018 22:22
• Reporter: Daniël van Eeden (OCA)
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 6.2.4
• OS: Any
• CPU Architecture: Any
• Tags: geo, gis, spatial, viewer

[27 Dec 2014 19:14] Daniël van Eeden

Description:
The spatial viewer in Workbench doesn't render bigger shapes in the correct resolution.

How to repeat:
Install Workbench and QGIS.
Download the WKT of the Netherlands from Openstretmap Nominatim and add it to the database.
Open both apps and load the shapes and compare the differences.

The table:
CREATE TABLE `geo1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `g` geometry DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1

[27 Dec 2014 19:14] Daniël van Eeden

Workbench screenshot

Attachment: Screenshot from 2014-12-27 20:10:20.png (image/png, text), 138.98 KiB.

[27 Dec 2014 19:14] Daniël van Eeden

QGIS screenshot

Attachment: Screenshot from 2014-12-27 20:10:07.png (image/png, text), 118.08 KiB.

[27 Dec 2014 19:19] Daniël van Eeden

Dump file with example data

Attachment: geo1.sql (application/sql, text), 1.22 MiB.

[27 Dec 2014 19:20] Daniël van Eeden

This is how I got the data:

wget -O nl.json 'http://nominatim.openstreetmap.org/search?country=The%20Netherlands&format=json&polygon_te...;

[29 Dec 2014 7:58] MySQL Verification Team

Hello Daniël,

Thank you for the report and test case.

Thanks,
Umesh

[22 May 2018 22:22] Christine Cole

Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 8.0.12 release, and here's the changelog entry:

The Zoom + icon in the spatial view toolbar produced deteriorating
resolution as an image was enlarged. For better results, use the Zoom to
area icon to recompute a portion of the whole shape, instead of simply
magnifying the visible area with the Zoom + tool.

Thank you for the bug report.