Bug #92266 URL to open geometry point in a browser is wrongly Percent-encoded
Submitted: 2 Sep 2018 1:29 Modified: 19 Sep 2018 22:37
Reporter: Ryusuke Kajiyama Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:8.0.12 OS:MacOS (10.12.6 (16G1510))
Assigned to: CPU Architecture:x86

[2 Sep 2018 1:29] Ryusuke Kajiyama
Description:
: and ? in URL to open geometry point in a browser using either with OpenStreetMap or Google Map are wrongly Percent-encoded like below;

http://www.openstreetmap.org/?mlat=10.3948&mlon=63.4225
->
http%3a//www.openstreetmap.org/%3Fmlat=10.3948&mlon=63.4225

https://www.google.com/maps/?q=10.3948,63.4225
->
https%3a//www.google.com/maps/%3Fq=10.3948,63.4225

This issue does not happen on Windows.
I have't tested on Linux yet.

How to repeat:
1) Insert some geometry points
2) Select those data in SQL Editor
3) In the result grid, use context-menu "Open point in a browser"
4) Unable to open the URL, or even Workbench does not choose browser to open automatically

Then dialog message shows wrongly encoded URL. Please see attached.
[2 Sep 2018 1:30] Ryusuke Kajiyama
Screen shot of dialog box after clicking Open point in browser

Attachment: MWB8012-macos-gis.jpeg (image/jpeg, text), 36.97 KiB.

[2 Sep 2018 4:32] MySQL Verification Team
Hello Kajiyama-San,

Thank you for the report and feedback.
Observed this with MySQL Workbench Community (GPL) for Mac OS X version 8.0.12 CE build 13312926 (64 bit).

regards,
Umesh
[19 Sep 2018 22:37] Christine Cole
Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 8.0.13 release, and here's the changelog entry:

With valid geometry points inserted, the option to open the points in a
browser failed on macOS hosts because the URL was improperly formed.

Thank you for the bug report.