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

wrong geometry type

    XMLWordPrintable

Details

    Description

      server returns random column type

      describe geozone;
      polygon       | polygon      | NO   |     | NULL    |                |
      describe geozone;
      polygon       | geometry     | NO   |     | NULL    |                |

      CREATE TABLE `geozone` (
        `id` int(11) NOT NULL,
        `name` varchar(255) NOT NULL,
        `user_id` int(11) NOT NULL COMMENT 'creator',
        `active` tinyint(4) DEFAULT '1',
        `ride_end` tinyint(1) DEFAULT NULL COMMENT 'Jestli se v teto oblasti ma ukoncit jizda',
        `min_lat` double DEFAULT NULL,
        `min_lon` double DEFAULT NULL,
        `max_lat` double DEFAULT NULL,
        `max_lon` double DEFAULT NULL,
        `polygon` geometry NOT NULL,
        `polygonBackup` polygon DEFAULT NULL,
        `ride_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 soukroma/2 sluzebni'
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='geozone';

      Attachments

        1. geozone.frm
          3 kB
          Pavel Dvorak
        2. geozone.ibd
          160 kB
          Pavel Dvorak
        3. my.cnf
          5 kB
          Pavel Dvorak

        Issue Links

          Activity

            People

              Unassigned Unassigned
              dvorak Pavel Dvorak
              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.