diff options
author | unknown <pem@mysql.comhem.se> | 2004-10-22 19:05:17 +0200 |
---|---|---|
committer | unknown <pem@mysql.comhem.se> | 2004-10-22 19:05:17 +0200 |
commit | 35588c9dd0aef7db1c89731b0c4899b41576df9c (patch) | |
tree | bcc3c64a109a454f469b5e05f9f3ada2bdc7158d /mysql-test/r/sp.result | |
parent | b24dd9336681880dc72f27fc346a2e1e9775d394 (diff) | |
download | mariadb-git-35588c9dd0aef7db1c89731b0c4899b41576df9c.tar.gz |
Fixed BUG#6027: Stored procedures can be renamed.
Removed the support for renaming SPs. It's non-standard, conflicted with a standard
syntax, and was a bit broken anyway.
mysql-test/r/sp-error.result:
Removed test for renaming procedures with alter.
mysql-test/r/sp.result:
Removed test for renaming procedures with alter.
mysql-test/t/sp-error.test:
Removed test for renaming procedures with alter.
mysql-test/t/sp.test:
Removed test for renaming procedures with alter.
sql/sp.cc:
Removed support for renaming SPs. It's non-standard, conflicted with a standard
syntax, and was a bit broken anyway.
sql/sp.h:
Removed support for renaming SPs. It's non-standard, conflicted with a standard
syntax, and was a bit broken anyway.
sql/sql_parse.cc:
Removed support for renaming SPs. It's non-standard, conflicted with a standard
syntax, and was a bit broken anyway.
sql/sql_yacc.yy:
Removed support for renaming SPs. It's non-standard, conflicted with a standard
syntax, and was a bit broken anyway.
Diffstat (limited to 'mysql-test/r/sp.result')
-rw-r--r-- | mysql-test/r/sp.result | 20 |
1 files changed, 10 insertions, 10 deletions
diff --git a/mysql-test/r/sp.result b/mysql-test/r/sp.result index 3a3a72708a4..d19c3c5355e 100644 --- a/mysql-test/r/sp.result +++ b/mysql-test/r/sp.result @@ -893,15 +893,15 @@ select * from t1| id data chistics 1 delete from t1| -alter procedure chistics sql security invoker name chistics2| -show create procedure chistics2| +alter procedure chistics sql security invoker| +show create procedure chistics| Procedure sql_mode Create Procedure -chistics2 CREATE PROCEDURE `test`.`chistics2`() +chistics CREATE PROCEDURE `test`.`chistics`() MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'Characteristics procedure test' insert into t1 values ("chistics", 1) -drop procedure chistics2| +drop procedure chistics| create function chistics() returns int language sql deterministic @@ -918,18 +918,18 @@ return 42 select chistics()| chistics() 42 -alter function chistics name chistics2 +alter function chistics no sql comment 'Characteristics function test'| -show create function chistics2| +show create function chistics| Function sql_mode Create Function -chistics2 CREATE FUNCTION `test`.`chistics2`() RETURNS int +chistics CREATE FUNCTION `test`.`chistics`() RETURNS int NO SQL DETERMINISTIC SQL SECURITY INVOKER COMMENT 'Characteristics function test' return 42 -drop function chistics2| +drop function chistics| insert into t1 values ("foo", 1), ("bar", 2), ("zip", 3)| set @@sql_mode = 'ANSI'| create procedure modes(out c1 int, out c2 int) @@ -2136,8 +2136,8 @@ insert into test.t1 values (x, y)| show procedure status like 'bar'| Db Name Type Definer Modified Created Security_type Comment test bar PROCEDURE root@localhost 0000-00-00 00:00:00 0000-00-00 00:00:00 INVOKER 111111111111 -alter procedure bar name bar2 comment "2222222222" sql security definer| -alter procedure bar2 name bar comment "3333333333"| +alter procedure bar comment "2222222222" sql security definer| +alter procedure bar comment "3333333333"| alter procedure bar| show create procedure bar| Procedure sql_mode Create Procedure |