[MDEV-12830] CREATE TABLE t1 (<defs>) SELECT... does not preserve new geometry type - Jira

XML

Word

Printable

DROP TABLE IF EXISTS t1,t2;

CREATE TABLE t1 (a POINT);

CREATE TABLE t2 (a GEOMETRY) AS SELECT * FROM t1;

SHOW CREATE TABLE t2;

+-------+-------------------------------------------------------------------------------------+

| Table | Create Table                                                                        |

+-------+-------------------------------------------------------------------------------------+

| t2    | CREATE TABLE `t2` (

  `a` point DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1 |

+-------+-------------------------------------------------------------------------------------+

The expected column type for t2.a should be GEOMETRY rather than POINT.

relates to

MDEV-12828 CREATE TABLE t1 (<defs>) SELECT... does not preserve new SRID

MDEV-12829 CREATE TABLE t1 (<defs>) SELECT... does not preserve new COMMENT

MDEV-12831 CREATE TABLE t1 (<defs>) SELECT... does not preserve new CHECK constraint

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