Feature request #20119
Support for MySQL 8
| Status: | Open | ||
|---|---|---|---|
| Priority: | Normal | ||
| Assignee: | - | ||
| Category: | Data Provider | ||
| Pull Request or Patch supplied: | No | Resolution: | |
| Easy fix?: | No | Copied to github as #: | 27941 |
Description
When upgrading the MySQL databases to MySQL 8 we are experiencing some issues:
- Upon opening a table through the Data Source Manager, nothing appears in the map window. This can be solved by adding a Provider feature filter (such as 1=1), but it makes drawing data slower and editing impossible.
- When editing a layer, use of the functions such as GeometryFromText is no longer supported by MySQL. The corresponding functions such as ST_GeometryFromText should be used.
- When data types are Bigint, all numbers appears to be 2147483647 (max of int)
History
#1
Updated by Giovanni Manghi about 6 years ago
- Tracker changed from Bug report to Feature request