ALTER TABLE didn't remember the exact

geometry type (POINT, LINESTRING, etc)
and changed all into "GEOMETRY".

1 files changed, 19 insertions, 0 deletions

diff --git a/mysql-test/t/gis.test b/mysql-test/t/gis.test
index 179dd12e6a3..73ee45e7754 100644
--- a/mysql-test/t/gis.test
+++ b/mysql-test/t/gis.test
@@ -121,3 +121,22 @@ Intersects(g1.g, g2.g) as i, Crosses(g1.g, g2.g) as r
 FROM gc g1, gc g2 ORDER BY first, second;
 
 DROP TABLE pt, ls, p, mpt, mls, mp, gc, geo;
+
+#
+# Check that ALTER TABLE doesn't loose geometry type
+#
+CREATE TABLE g1 (
+  pt  point,
+  ln  linestring,
+  pg  polygon,
+  mpt multipoint,
+  mln multilinestring,
+  mpg multipolygon,
+  gc  geometrycollection,
+  gm  geometry
+);
+
+SHOW FIELDS FROM g1;
+ALTER TABLE g1 ADD fid INT NOT NULL;
+SHOW FIELDS FROM g1;
+DROP TABLE g1;