On Mon, May 30, 2016 at 12:37 PM, Ian Gilfillan <ian@mariadb.org> wrote:

On 28/05/2016 17:30, Michael Moore wrote:

I've got the table compiled here.

https://docs.google.com/spreadsheets/d/1R7vwdctsoGQADY9i24yArvz8wQ59GSr59wKY6dUstbI/edit#gid=0

The table is proving useful in spotting some oversights in the MariaDB documentation! The CENTROID function exists (but has no article in the MariaDB docs). I also want to look into a few other cases, which may just be missing from the MariaDB documentation.

Besides X() and Y(), Area is listed as missing in MariaDB, but is present - https://mariadb.com/kb/en/mariadb/st_area/

Thanks for all your help Ian!

I've updated X(),Y(), Centroid() and Area and created a page in the KB here: https://mariadb.com/kb/en/mariadb/mysqlmariadb-spatial-support-matrix/

I couldn't get the color markup to work correctly. When I used the syntax listed here (http://wiki.wikicreole.org/HelpOnTables) it just printed the <bgcolor> and <style> tags. I'd be happy to color the table if you can tell me what syntax to use.

Michael Moore