diff options
| author | pem@mysql.comhem.se <> | 2004-10-14 18:07:09 +0200 |
|---|---|---|
| committer | pem@mysql.comhem.se <> | 2004-10-14 18:07:09 +0200 |
| commit | 4043c0f3dba2070f2b53568dace8fa6091d66ba0 (patch) | |
| tree | 60fbcabd11aa23d99818bc782b6d0eedaf744703 /mysql-test/r/sp.result | |
| parent | 7f55e8eab2ea3494a132f335b6660f1c8f353b6e (diff) | |
| download | mariadb-git-4043c0f3dba2070f2b53568dace8fa6091d66ba0.tar.gz | |
Implemented the stored procedure data access characteristics:
NO SQL
CONTAINS SQL (default)
READS SQL DATA
MODIFIES SQL DATA
These are needed as hints for the replication.
(Before this, we did have the default in the mysql.proc table, but no support in the parser.)
Diffstat (limited to 'mysql-test/r/sp.result')
| -rw-r--r-- | mysql-test/r/sp.result | 24 |
1 files changed, 21 insertions, 3 deletions
diff --git a/mysql-test/r/sp.result b/mysql-test/r/sp.result index 7544fbe5d60..3a3a72708a4 100644 --- a/mysql-test/r/sp.result +++ b/mysql-test/r/sp.result @@ -877,10 +877,17 @@ drop table t3| drop procedure cur2| create procedure chistics() language sql +modifies sql data not deterministic sql security definer comment 'Characteristics procedure test' - insert into t1 values ("chistics", 1)| + insert into t1 values ("chistics", 1)| +show create procedure chistics| +Procedure sql_mode Create Procedure +chistics CREATE PROCEDURE `test`.`chistics`() + MODIFIES SQL DATA + COMMENT 'Characteristics procedure test' +insert into t1 values ("chistics", 1) call chistics()| select * from t1| id data @@ -890,6 +897,7 @@ alter procedure chistics sql security invoker name chistics2| show create procedure chistics2| Procedure sql_mode Create Procedure chistics2 CREATE PROCEDURE `test`.`chistics2`() + MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'Characteristics procedure test' insert into t1 values ("chistics", 1) @@ -899,14 +907,24 @@ language sql deterministic sql security invoker comment 'Characteristics procedure test' - return 42| + return 42| +show create function chistics| +Function sql_mode Create Function +chistics CREATE FUNCTION `test`.`chistics`() RETURNS int + DETERMINISTIC + SQL SECURITY INVOKER + COMMENT 'Characteristics procedure test' +return 42 select chistics()| chistics() 42 -alter function chistics name chistics2 comment 'Characteristics function test'| +alter function chistics name chistics2 +no sql +comment 'Characteristics function test'| show create function chistics2| Function sql_mode Create Function chistics2 CREATE FUNCTION `test`.`chistics2`() RETURNS int + NO SQL DETERMINISTIC SQL SECURITY INVOKER COMMENT 'Characteristics function test' |