Thanks Ian, I've started going through the functions.

On https://mariadb.com/kb/en/mariadb/st_convexhull/, the note says "ST_ConvexHull() was introduced in MariaDB 10.1.2" -- per your last email, it sounds like that means that ConvexHull (no ST_) should've been in MariaDB in all versions.

Since MySQL didn't add ConvexHull until 5.7.5, I'm wondering if

I'm misinterpreting that,
MariaDB really did have ConvexHull since the start
MySQL's docs are off and it did have it previously
MariaDB's docs are off and ConvexHull was also added in 10.1.2

Also, MySQL 5.7.6 deprecated several functions, including ConvexHull() -- are any functions currently deprecated in MariaDB, and if so, are they noted as such? Or would that come in a future version?

Once again, thanks for your help!

Michael Moore

On Fri, May 27, 2016 at 8:43 AM, Ian Gilfillan <ian@mariadb.org> wrote:

Hi Michael

The versions have been added to the function documentation.

If no version is listed, it's available in all versions of MariaDB, for example https://mariadb.com/kb/en/mariadb/glength/

Some have had synonyms added, for example https://mariadb.com/kb/en/mariadb/st_geomcollfromwkb/ where GeomCollFromWKB is available in all versions, and ST_GeomCollFromWKB since 5.3.3

Looking forward to seeing the table!

On 25/05/2016 14:35, Michael Moore wrote:

Thanks Ian!

That will help a lot.

I look forward to your updates.

--

Michael Moore

On Wed, May 25, 2016 at 5:43 AM, Ian Gilfillan <ian@mariadb.org> wrote:

Hi Michael

Great, thanks for the initiative!

Unfortunately, most of the function pages don't specify the version they were introduced. They should all do so, as on https://mariadb.com/kb/en/mariadb/st-within/ and https://mariadb.com/kb/en/mariadb/st_boundary/ for example. The ones that don't mention the version are the older articles, so for early versions of MariaDB.

I'll look at adding this version information to the pages in the next few days, and then you can base your table on that.

On 25/05/2016 07:31, Michael Moore wrote:

Hi,

I'm trying to put together a table of which spatial functions are supported by MySQL and MariaDB at which version numbers.

Something like https://dev.mysql.com/doc/refman/5.5/en/spatial-function-reference.html for different versions would be awesome, but I can't find it.

Checking wiki history isn't very helpful because it just shows a date that it was changed, with no mention of why.

Is there a better approach I could be taking?

I'm making the table for WordPress plugin developers, who have to deal with sometimes old versions of MySQL and MariaDB on their hosts without control over the upgrade schedule.

Once I have the table compiled I'd love to share it back on the MariaDB KB for future people looking for the same thing.

Many thanks,
Michael Moore

_______________________________________________
Mailing list: https://launchpad.net/~maria-docs
Post to : maria-docs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-docs
More help : https://help.launchpad.net/ListHelp