Hi All,
I've managed to make the MySQL module work with both MySQL 5 (5.6/5.7)
as well as MySQL 8 (8.0) resolving GEOT-6690 / GEOT-6692.
There's some trickery around the "envelope" and "srid" functions involved.
If anyone cares to review PR 3191? I will squash and merge after OK to
clean up t
Hi Mark,
Actually it seems that there are a number of functions that do not support
geography in 8.0 (more precisely this happened from version 8.0.11 and
above). In 5.7 there was no issue because independently of the SRID you
provided the actual computations were in cartesian space (no geography
O Joy, it gets better.
In MySQL 8 if you store epsg 4326 data you must be wanting to store
geography and not geometry so let's demand that you flip the axis:
https://dba.stackexchange.com/a/242004
and then ofcourse things like this fail (on MySQL 8.0.21)...
SELECT ST_Envelope(ST_GeomFromText
Ok, thanks.
I'll get to work on it
Op wo 2 sep. 2020 om 13:57 schreef Nikolaos Pringouris :
> Hmm probably I have missed/overlooked these 2 functions when adding
> support for ST_... functions in geotools 19.x.
> In any case as you already mentioned the flag is direct available there so
> you eas
Hmm probably I have missed/overlooked these 2 functions when adding support
for ST_... functions in geotools 19.x.
In any case as you already mentioned the flag is direct available there so
you easily add support for the corresponding ST_ functions at that point.
Concerning Mysql v5.5 I think you
On 2020-09-01 19:24, Nikolaos Pringouris wrote:
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 the
Just as a note, the Postgis store can detect the version of Postgis and
apply different behavior based in this. We used to use this when Postgis
switched to st_ prefixing, not sure if that code is still there thought,
been a long while
Cheers
Andrea
Il mar 1 set 2020, 18:26 Jody Garnett ha scrit
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 D
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 t
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 drop
10 matches
Mail list logo
