Debian Codegraph @

mysql-test/suite/innodb/r/innodb_multi_update.result

raw
1 CREATE TABLE bug38999_1 (a int not null primary key, b int not null, key (b)) engine=innodb;
2 CREATE TABLE bug38999_2 (a int not null primary key, b int not null, key (b)) engine=innodb;
3 INSERT INTO bug38999_1 values (1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9),(10,10),(11,11),(12,12);
4 INSERT INTO bug38999_2 values (1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9);
5 update bug38999_1,bug38999_2 set bug38999_1.a=bug38999_1.a+100;
6 select * from bug38999_1;
7 a b
8 101 1
9 102 2
10 103 3
11 104 4
12 105 5
13 106 6
14 107 7
15 108 8
16 109 9
17 110 10
18 111 11
19 112 12
20 update bug38999_1,bug38999_2 set bug38999_1.a=bug38999_1.a+100 where bug38999_1.a=101;
21 select * from bug38999_1;
22 a b
23 102 2
24 103 3
25 104 4
26 105 5
27 106 6
28 107 7
29 108 8
30 109 9
31 110 10
32 111 11
33 112 12
34 201 1
35 update bug38999_1,bug38999_2 set bug38999_1.b=bug38999_1.b+10 where bug38999_1.b=2;
36 select * from bug38999_1;
37 a b
38 102 12
39 103 3
40 104 4
41 105 5
42 106 6
43 107 7
44 108 8
45 109 9
46 110 10
47 111 11
48 112 12
49 201 1
50 update bug38999_1 force index (b) straight_join bug38999_2
51 set bug38999_1.b=bug38999_1.b+2,
52 bug38999_2.b=bug38999_1.b+10
53 where bug38999_1.b between 3 and 5 and bug38999_1.a=bug38999_2.a+100;
54 select * from bug38999_1;
55 a b
56 102 12
57 103 5
58 104 6
59 105 7
60 106 6
61 107 7
62 108 8
63 109 9
64 110 10
65 111 11
66 112 12
67 201 1
68 select * from bug38999_2;
69 a b
70 1 1
71 2 2
72 3 13
73 4 14
74 5 15
75 6 6
76 7 7
77 8 8
78 9 9
79 drop table bug38999_1,bug38999_2;
80 #
81 # Bug#54475 improper error handling causes cascading crashing failures in innodb/ndb
82 #
83 CREATE TABLE t1(f1 INT) ENGINE=INNODB;
84 INSERT INTO t1 VALUES(1);
85 UPDATE (SELECT ((SELECT 1 FROM t1), 1) FROM t1 WHERE (SELECT 1 FROM t1)) x, (SELECT 1) AS d SET d.f1 = 1;
86 ERROR 21000: Operand should contain 1 column(s)
87 DROP TABLE t1;