|
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.
|