[MDEV-7510] GIS: IsRing returns false for a primitive triangle - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.1(EOL)
Fix Version/s: 10.1.4
Component/s: GIS
Labels:
- gis

Description

10.1 revision 0105bf349a...
MariaDB [test]> select ST_IsRing(ST_LineFromText('LINESTRING(0 0,0 10,10 10,0 0)'));
+--------------------------------------------------------------+
\| ST_IsRing(ST_LineFromText('LINESTRING(0 0,0 10,10 10,0 0)')) \|
+--------------------------------------------------------------+
\| 0 \|
+--------------------------------------------------------------+

PostgeSQL 9.4, PostGIS 2.1.5
pgis=# select ST_IsRing(ST_LineFromText('LINESTRING(0 0,0 10,10 10,0 0)'));
st_isring
-----------
t
(1 row)

Attachments

Issue Links

relates to

MDEV-7509 Testing for GIS extensions

Closed

Activity

Ascending order - Click to sort in descending order

Ian Gilfillan added a comment - 2015-02-03 13:25

IsRing is supposed to apply if IsSimple and IsClosed. In the above example, IsClosed is true, while IsSimple is false, when it seems it should be true.

select ST_IsSimple(ST_LineFromText('LINESTRING(0 0,0 10,10 10,0 0)'));

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

| ST_IsSimple(ST_LineFromText('LINESTRING(0 0,0 10,10 10,0 0)')) |

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

|                                                              0 |

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

select ST_IscLOSED(ST_LineFromText('LINESTRING(0 0,0 10,10 10,0 0)'));

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

| ST_IscLOSED(ST_LineFromText('LINESTRING(0 0,0 10,10 10,0 0)')) |

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

|                                                              1 |

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

Ian Gilfillan added a comment - 2015-02-03 13:25 IsRing is supposed to apply if IsSimple and IsClosed. In the above example, IsClosed is true, while IsSimple is false, when it seems it should be true. select ST_IsSimple(ST_LineFromText('LINESTRING(0 0,0 10,10 10,0 0)')); +----------------------------------------------------------------+ | ST_IsSimple(ST_LineFromText('LINESTRING(0 0,0 10,10 10,0 0)')) | +----------------------------------------------------------------+ | 0 | +----------------------------------------------------------------+ select ST_IscLOSED(ST_LineFromText('LINESTRING(0 0,0 10,10 10,0 0)')); +----------------------------------------------------------------+ | ST_IscLOSED(ST_LineFromText('LINESTRING(0 0,0 10,10 10,0 0)')) | +----------------------------------------------------------------+ | 1 | +----------------------------------------------------------------+

Alexey Botchkov added a comment - 2015-03-13 14:36

Fixing patch: http://lists.askmonty.org/pipermail/commits/2015-March/007583.html

Alexey Botchkov added a comment - 2015-03-13 14:36 Fixing patch: http://lists.askmonty.org/pipermail/commits/2015-March/007583.html

People

Assignee:: Alexey Botchkov

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2015-01-27 18:35

Updated:: 2015-03-13 14:36

Resolved:: 2015-03-13 14:36

Git Integration

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

MariaDB Server