Hi All, A couple of years ago I worked on jdbc-mysql module and provided support for the newly introduced ST_ functions in Mysql5.6 & Mysql 5.7. I think these functions are also supported in Mysql8.0 with the same signature so I do not think there is an issue of incompatibility. If you check the Data Store factory for Mysql (MySQLDataStoreFactory) you will see that there is a static function isMySqlVersion56(...) which is called during creation of the dataStore and if figures out that mysql 5.6 or above is used in enables enhancedSpatialSupport flag automatically and the use of the corresponding ST_ functions (check also visitBinarySpatialOperatorEnhanced(...) function in MySQLFilterToSQL class). Of course mysql 8.0 may have additional spatial features (to be honest I am still using version 5.7.x in my geotools related projects) and probably the mysql module can still be improved but I am pretty sure that the module will still be functional when the underline Mysql DB is v8.0 (in addition to 5.5, 5.6, 5.7).
kind regards, Nikolaos Pringouris Στις Τρί, 1 Σεπ 2020 στις 7:25 μ.μ., ο/η Jody Garnett < jody.garn...@gmail.com> έγραψε: > My understanding is MySQL reimplemented their geometry to be based on > Boost (indeed right around MySQL 5.7). This thankfully drops a lot of > their previous native implementation of geometry. > > I would fully support you dropping support for older versions if that > makes the code easier, > If we wanted to have both it may be wise to treat it as a new datastore, > and have the factory choose between implementations (like shapefile > factory), or leave the previous implementation as a community module for > those still working with 5.6/5.7. > -- > Jody Garnett > > > On Tue, 1 Sep 2020 at 08:51, Mark Prins <mc.pr...@gmail.com> wrote: > >> Hi, >> I've opened [0] which I ran into after setting up online testing with >> MySQL 8 and will be taking a stab at that, but before I take off I'm >> wondering which versions of MySQL we want to support in GeoTools. >> >> The MySQL project is already dropping support for 5.6 on some platforms >> [1] and dropping that in GeoTools (24.x/master) would make the >> migration/upgrade easier as 5.7 is supposed to have both ST_ prefixed >> and plain named (but deprecated) spatial functions. >> We could leave 23.x as is (without MySQL 8 support, but with 5.6/5.7 >> support) >> >> Mark >> >> [0] https://osgeo-org.atlassian.net/browse/GEOT-6690 >> [1] https://www.mysql.com/support/supportedplatforms/database.html >> >> >> _______________________________________________ >> GeoTools-Devel mailing list >> GeoTools-Devel@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/geotools-devel >> > _______________________________________________ > GeoTools-Devel mailing list > GeoTools-Devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geotools-devel >
_______________________________________________ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
