summaryrefslogtreecommitdiff
path: root/scripts
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2019-04-10 10:08:42 +0300
committerSergei Golubchik <serg@mariadb.org>2019-04-24 16:06:54 +0200
commit2a6f00ed6ad2787ff21194b26282a09e2ff295b4 (patch)
tree76be3732a969adf1cf350abea55d15842b14bfcb /scripts
parent932e29d4ad3cd6ffb445f0080191c88c8b2693c0 (diff)
downloadmariadb-git-2a6f00ed6ad2787ff21194b26282a09e2ff295b4.tar.gz
use the correct SQL SECURITY type for OpenGIS stored procedures
Diffstat (limited to 'scripts')
-rw-r--r--scripts/maria_add_gis_sp.sql.in4
1 files changed, 2 insertions, 2 deletions
diff --git a/scripts/maria_add_gis_sp.sql.in b/scripts/maria_add_gis_sp.sql.in
index 3a5dd49b95b..5826cc1a038 100644
--- a/scripts/maria_add_gis_sp.sql.in
+++ b/scripts/maria_add_gis_sp.sql.in
@@ -24,12 +24,12 @@ DROP PROCEDURE IF EXISTS AddGeometryColumn;
DROP PROCEDURE IF EXISTS DropGeometryColumn;
CREATE DEFINER=`root`@`localhost` PROCEDURE AddGeometryColumn(catalog varchar(64), t_schema varchar(64),
- t_name varchar(64), geometry_column varchar(64), t_srid int)
+ t_name varchar(64), geometry_column varchar(64), t_srid int) SQL SECURITY INVOKER
begin
set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' ADD ', geometry_column,' GEOMETRY REF_SYSTEM_ID=', t_srid); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end @ADD_GIS_SP_EOL@
CREATE DEFINER=`root`@`localhost` PROCEDURE DropGeometryColumn(catalog varchar(64), t_schema varchar(64),
- t_name varchar(64), geometry_column varchar(64))
+ t_name varchar(64), geometry_column varchar(64)) SQL SECURITY INVOKER
begin
set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' DROP ', geometry_column); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end @ADD_GIS_SP_EOL@