Fix getting all information about geometry columns for mysql8
Open
Nobody has claimed this yet.
feature
- Dominant language
- PHP
- Stars
- 4.5k
- Forks
- 884
- PR merge metrics
- No merged PRs in 30d
Description
As part of their changes to improve the story for geometries, mysql added the information_schema.ST_GEOMETRY_COLUMNS table which stores various useful bits of info like SRID, shape, etc, which is not available in the regular information_schema.COLUMNS table.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
No file or test is named. Start by locating the MySQL schema-introspection code that reads information_schema.COLUMNS, then compare its geometry handling with MySQL 8's ST_GEOMETRY_COLUMNS table; done means geometry metadata such as SRID and shape is returned for geometry columns.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mysql, php
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100