Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-3819

missing constraints for spatial column types

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 5.5.28
        • Fix Version/s: 5.5.30
        • Component/s: None
        • Labels:
          None
        • Environment:
          all platforms

          Description

          SPATIAL columns which are not defined as GEOMETRY, e.g. POINT, LINE, POLYGON accept all kind of geometries.

          How to repeat:

          create table t1 (a point not null, spatial index(a));

SET @poly = 'Polygon((0 0,0 3,3 0,0 0),(1 1,1 2,2 1,1 1))';

insert into t1 values(GeomFromText(@poly));
>>Query OK, 1 row affected (0.29 sec)

          Testing the same with PostGIS:

          test=# insert into t1 values (GeomFromText('POLYGON(1 1, 2 2, 1 1)'));
ERROR:  column "a" is of type point but expression is of type geometry

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

                Bug - A problem which impairs or prevents the functions of the product. MDEV-3930 Spatial functions: Return error instead of NULL for non supported geometry types

                • Minor - Minor loss of function, or other problem where easy workaround is present.
                • Open

                  Activity

                  There are no comments yet on this issue.

                    People

                    • Assignee:
                      holyfoot Alexey Botchkov
                      Reporter:
                      georg Georg Richter
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved:

                        Time Tracking

                        Estimated:
                        Original Estimate - Not Specified
                        Not Specified
                        Remaining:
                        Remaining Estimate - 0 minutes
                        0m
                        Logged:
                        Time Spent - 1 day
                        1d