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

st_isvalid(NULL) should not end up with an error, but return NULL

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Critical
    • Resolution: Unresolved
    • None
    • 12.0
    • GIS
    • None

    Description

      MariaDB [test]> select st_isvalid(NULL);
      ERROR 3037 (22023): Invalid GIS data provided to function st_isvalid.
      

      Mysql returns NULL in all such cases, while Mariadb sometimes -1, sometimes NULL

      MariaDB [test]> select st_isempty(NULL);
      +------------------+
      | st_isempty(NULL) |
      +------------------+
      |             NULL |
      +------------------+
      1 row in set (0,000 sec)
       
      MariaDB [test]> select st_issimple(NULL);
      +-------------------+
      | st_issimple(NULL) |
      +-------------------+
      |                -1 |
      +-------------------+
      1 row in set (0,000 sec)
       
      MariaDB [test]> select st_isring(NULL);
      +-----------------+
      | st_isring(NULL) |
      +-----------------+
      |              -1 |
      +-----------------+
      1 row in set (0,000 sec)
      

      Attachments

        Issue Links

          Activity

            Transition Time In Source Status Execution Times
            Dave Gosselin made transition -
            Open In Progress
            2d 2h 18m 1
            Dave Gosselin made transition -
            In Progress In Review
            6s 1
            Alexey Botchkov made transition -
            In Review In Testing
            34d 5h 49m 1
            Alice Sherepa made transition -
            In Testing Stalled
            40d 18h 28m 1

            People

              Gosselin Dave Gosselin
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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