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

GIS: Functions return NULL instead of specified -1 for NULL arguments

Details

    • 10.1.6-1

    Description

      MariaDB [test]> select ST_IsRing(NULL);
      		 
      +-----------------+
      		 
      | ST_IsRing(NULL) |
      		 
      +-----------------+
      		 
      |            NULL |
      		 
      +-----------------+
      		 
      1 row in set (0.00 sec)

      etc.

      Specification in the email said:

      IsRing(ln)
      The return type is Integer, with a return value of 1 for
      TRUE, 0 for FALSE, and -1 for UNKNOWN
      corresponding to a function invocation on NULL

      etc.

      Possibly it's just a documentation issue. PostgreSQL also returns NULL.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-7509 Testing for GIS extensions

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35960 st_isvalid(NULL) should not end up with an error, but return NULL

          • Critical - Crashes, loss of data, severe memory leak.
          • In Testing

          Activity

            Ascending order - Click to sort in descending order
            elenst Elena Stepanova created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            elenst Elena Stepanova made changes -
            Description {code:sql}
            MariaDB [test]> select ST_IsRing(NULL);
            +-----------------+
            | ST_IsRing(NULL) |
            +-----------------+
            | NULL |
            +-----------------+
            1 row in set (0.00 sec)
            {code}
            etc.

            Specification in the email said:
            {quote}
                IsRing(ln)
                    The return type is Integer, with a return value of 1 for
                    TRUE, 0 for FALSE, and -1 for UNKNOWN
                    corresponding to a function invocation on NULL
            {code}
            etc.

            Possibly it's just a documentation issue. PostgreSQL also returns NULL.             		{code:sql}
            MariaDB [test]> select ST_IsRing(NULL);
            +-----------------+
            | ST_IsRing(NULL) |
            +-----------------+
            | NULL |
            +-----------------+
            1 row in set (0.00 sec)
            {code}
            etc.

            Specification in the email said:
            {quote}
                IsRing(ln)
                    The return type is Integer, with a return value of 1 for
                    TRUE, 0 for FALSE, and -1 for UNKNOWN
                    corresponding to a function invocation on NULL
            {quote}
            etc.

            Possibly it's just a documentation issue. PostgreSQL also returns NULL.
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 59358 ] MariaDB v3 [ 66316 ]
            serg Sergei Golubchik made changes -
            Sprint 10.1.6-1 [ 6 ]
            holyfoot Alexey Botchkov made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            holyfoot Alexey Botchkov made changes -
            Fix Version/s 10.1.6 [ 19401 ]
            Fix Version/s 10.1 [ 16100 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 66316 ] MariaDB v4 [ 148765 ]
            Gosselin Dave Gosselin made changes -

            People

              holyfoot Alexey Botchkov
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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