[MDEV-36166] support for notation with brackets inside MULTIPOINT - Jira

MariaDB [test]> SELECT  st_astext(st_geomfromtext('multipoint((0 0))'));

+-------------------------------------------------+

| st_astext(st_geomfromtext('multipoint((0 0))')) |

+-------------------------------------------------+

| NULL                                            |

+-------------------------------------------------+

1 row in set (0,000 sec)

MariaDB [test]> SELECT  st_astext(st_geomfromtext('multipoint((0 0),(1 1))'));

+-------------------------------------------------------+

| st_astext(st_geomfromtext('multipoint((0 0),(1 1))')) |

+-------------------------------------------------------+

| NULL                                                  |

+-------------------------------------------------------+

1 row in set (0,001 sec)

MariaDB [test]> SELECT  st_astext(st_geomfromtext('multipoint(0 0,1 1)'));

+---------------------------------------------------+

| st_astext(st_geomfromtext('multipoint(0 0,1 1)')) |

+---------------------------------------------------+

| MULTIPOINT(0 0,1 1)                               |

+---------------------------------------------------+

1 row in set (0,001 sec)

Mysql supports both ways - with brackets or without, but not the mix of them:

mysql>  SELECT  st_astext(st_geomfromtext('multipoint(0 0,1 1)'));

+---------------------------------------------------+

| st_astext(st_geomfromtext('multipoint(0 0,1 1)')) |

+---------------------------------------------------+

| MULTIPOINT((0 0),(1 1))                           |

+---------------------------------------------------+

1 row in set (0,00 sec)

mysql> SELECT ST_EQUALS( st_geomfromtext('point (0 0)') , st_geomfromtext('multipoint((0 0))'));

+-----------------------------------------------------------------------------------+

| ST_EQUALS( st_geomfromtext('point (0 0)') , st_geomfromtext('multipoint((0 0))')) |

+-----------------------------------------------------------------------------------+

|                                                                                 1 |

+-----------------------------------------------------------------------------------+

1 row in set (0,00 sec)

mysql>  SELECT  st_astext(st_geomfromtext('multipoint((0 0),1 1)'));

ERROR 3037 (22023): Invalid GIS data provided to function st_geomfromtext.

mysql>  SELECT  st_astext(st_geomfromtext('multipoint((0 0),(1 1))'));

+-------------------------------------------------------+

| st_astext(st_geomfromtext('multipoint((0 0),(1 1))')) |

+-------------------------------------------------------+

| MULTIPOINT((0 0),(1 1))                               |

+-------------------------------------------------------+

1 row in set (0,00 sec)

No workflow transitions have been executed yet.

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server