Bug #101273 Geometry collection fields break MySQL Workbench
Submitted: 22 Oct 2020 11:40 Modified: 22 Oct 2020 11:50
Reporter: Reuben Thompson Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:8.0.22 OS:Microsoft Windows
Assigned to: CPU Architecture:x86

[22 Oct 2020 11:40] Reuben Thompson
GEOMETRYCOLLECTION fields are returned from MySQL server with type GEOMCOLLECTION. This type is not known to MySQL Workbench so it is not possible to import these fields using the reverse engineer tool.

How to repeat:
1. Create a table with a field of type GEOMETRYCOLLECTION from the table editor.
2. An error will show saying the command ran but the type GEOMCOLLECTION was not recognised in the response
3. Go to Reverse Engineer in the Database menu
4. Import the table you just created
5. The error "ERROR: (198, 13) "geomcollection" is not valid at this position, expecting BIGINT, BINARY, BIT, BLOB, BOOLEAN, BOOL, ..." will be returned and the table will not be added to the diagram

Suggested fix:
Make MySQL Workbench understand that GEOMETRYCOLLECTION and GEOMCOLLECTION are synonymous.
[22 Oct 2020 11:50] MySQL Verification Team
Hello Reuben Thompson

Thank you for the report and feedback.