summaryrefslogtreecommitdiffstats
path: root/mysql-test/main/gis_notembedded.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/gis_notembedded.test')
-rw-r--r--mysql-test/main/gis_notembedded.test24
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/main/gis_notembedded.test b/mysql-test/main/gis_notembedded.test
new file mode 100644
index 00000000..d25d6a70
--- /dev/null
+++ b/mysql-test/main/gis_notembedded.test
@@ -0,0 +1,24 @@
+source include/not_embedded.inc;
+#
+# MDEV-60 Support for Spatial Reference systems for the GIS data.
+#
+show create procedure mysql.AddGeometryColumn;
+show create procedure mysql.DropGeometryColumn;
+create table t1 (a int, b int);
+call mysql.AddGeometryColumn('', 'test', 't1', 'c', 10);
+show create table t1;
+call mysql.DropGeometryColumn('', 'test', 't1', 'c');
+show create table t1;
+call mysql.DropGeometryColumn('', 'test', 't1', 'b');
+show create table t1;
+drop table t1;
+
+create user foo@localhost;
+grant execute on mysql.* to foo@localhost;
+connect (foo, localhost, foo);
+--error ER_TABLEACCESS_DENIED_ERROR
+call mysql.AddGeometryColumn('', 'mysql', 'proc', 'c', 10);
+disconnect foo;
+connection default;
+drop user foo@localhost;
+