← Back to branch summary

~ubuntu-branches/ubuntu/maverick/mysql-5.1/maverick-proposed

« back to all changes in this revision

Viewing changes to mysql-test/t/sp-bugs.test

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 14:16:05 UTC
  • mto: This revision was merged to the branch mainline in revision 20.
  • Revision ID: package-import@ubuntu.com-20120222141605-nxlu9yzc6attylc2
Tags: upstream-5.1.61
Import upstream version 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/sp-bugs.test
101
101
DROP TABLE t1;
102
102
DROP PROCEDURE p1;
103
103
 
 
104
--echo #
 
105
--echo # Bug#54375: Error in stored procedure leaves connection
 
106
--echo # in different default schema
 
107
--echo #
 
108
 
 
109
--disable_warnings
 
110
SET @@SQL_MODE = 'STRICT_ALL_TABLES';
 
111
DROP DATABASE IF EXISTS db1;
 
112
CREATE DATABASE db1;
 
113
USE db1;
 
114
DROP TABLE IF EXISTS t1;
 
115
CREATE TABLE t1 (c1 int NOT NULL PRIMARY KEY);
 
116
INSERT INTO t1 VALUES (1);
 
117
DELIMITER $$;
 
118
CREATE FUNCTION f1 (
 
119
        some_value int
 
120
)
 
121
RETURNS smallint
 
122
DETERMINISTIC
 
123
BEGIN
 
124
        INSERT INTO t1 SET c1 = some_value;
 
125
        RETURN(LAST_INSERT_ID());
 
126
END$$
 
127
DELIMITER ;$$
 
128
DROP DATABASE IF EXISTS db2;
 
129
CREATE DATABASE db2;
 
130
--enable_warnings
 
131
USE db2;
 
132
SELECT DATABASE();
 
133
--error ER_DUP_ENTRY
 
134
SELECT db1.f1(1);
 
135
SELECT DATABASE();
 
136
USE test;
 
137
DROP FUNCTION db1.f1;
 
138
DROP TABLE db1.t1;
 
139
DROP DATABASE db1;
 
140
DROP DATABASE db2;
104
141
--echo End of 5.1 tests