Feature request #20119

Support for MySQL 8

Added by Hans Johansen about 2 years ago. Updated about 2 years ago.

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 2 years ago

  • Tracker changed from Bug report to Feature request

Also available in: Atom PDF