MySQL Bugs: #101273: Geometry collection fields break MySQL Workbench

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:	None
Category:	MySQL Workbench: Modeling	Severity:	S3 (Non-critical)
Version:	8.0.22	OS:	Windows
Assigned to:		CPU Architecture:	x86

Description:
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.

Hello Reuben Thompson

Thank you for the report and feedback.

regards,
Umesh