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

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

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Minor
        • Resolution: Fixed
        • Affects Version/s: N/A
        • Fix Version/s: 10.1.6
        • Component/s: GIS
        • Labels:
        • Sprint:
          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.

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

                Technical task - A technical task. MDEV-7509 Testing for GIS extensions

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

                  Activity

                  Hide
                  Permalink
                  holyfoot Alexey Botchkov added a comment -

                  http://lists.askmonty.org/pipermail/commits/2015-June/008079.html

                  Show
                  holyfoot Alexey Botchkov added a comment - http://lists.askmonty.org/pipermail/commits/2015-June/008079.html

                    People

                    • Assignee:
                      holyfoot Alexey Botchkov
                      Reporter:
                      elenst Elena Stepanova
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      3 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 - 3 hours
                        3h

                          Agile