Feature request #20119
Support for MySQL 8
|Pull Request or Patch supplied:||No||Resolution:|
|Easy fix?:||No||Copied to github as #:||27941|
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)