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
        2. geozone.ibd
          160 kB
        3. my.cnf
          5 kB

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              dvorak Pavel Dvorak
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration