|
1.4.1
by Marc Deslauriers
Import upstream version 5.1.61 |
1 |
include/master-slave.inc |
2 |
[connection master] |
|
|
1
by Norbert Tretkowski
Import upstream version 5.1.45 |
3 |
drop database if exists test1; |
4 |
create database test1; |
|
5 |
use test1; |
|
6 |
CREATE TABLE `t1` ( |
|
7 |
`id` int(10) unsigned NOT NULL auto_increment, |
|
8 |
`fname` varchar(100) default NULL, |
|
9 |
PRIMARY KEY (`id`) |
|
10 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; |
|
11 |
INSERT INTO `t1` VALUES (1, 'blablabla'); |
|
12 |
CREATE TABLE `t2` ( |
|
13 |
`id` int(10) NOT NULL auto_increment, |
|
14 |
`comment` varchar(255) NOT NULL default '', |
|
15 |
PRIMARY KEY (`id`) |
|
16 |
) ENGINE=MyISAM AUTO_INCREMENT=3 ; |
|
17 |
INSERT INTO `t2` VALUES (1, 'testtest 1'); |
|
18 |
INSERT INTO `t2` VALUES (2, 'test 2'); |
|
19 |
CREATE PROCEDURE simpleproc3 () |
|
20 |
NOT DETERMINISTIC |
|
21 |
BEGIN
|
|
22 |
INSERT INTO t1 (fname) (SELECT t2.comment FROM t2 WHERE t2.id = '1'); |
|
23 |
INSERT INTO t1 (fname) VALUES('test'); |
|
24 |
END
|
|
25 |
$
|
|
26 |
CALL simpleproc3(); |
|
27 |
select * from t2; |
|
28 |
id comment |
|
29 |
1 testtest 1 |
|
30 |
2 test 2 |
|
31 |
TRUNCATE TABLE `t1`; |
|
32 |
CALL simpleproc3(); |
|
33 |
select * from t1; |
|
34 |
id fname |
|
35 |
1 testtest 1 |
|
36 |
2 test |
|
37 |
use test1; |
|
38 |
select * from t1; |
|
39 |
id fname |
|
40 |
1 testtest 1 |
|
41 |
2 test |
|
42 |
drop database test1; |
|
|
1.4.1
by Marc Deslauriers
Import upstream version 5.1.61 |
43 |
include/rpl_end.inc |