1--disable_warnings
2--enable_warnings
3CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
4CREATE TABLE t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
5CREATE TABLE t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
6INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
7INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
8INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
9UPDATE   t1, t2 ,t3 SET t1.c2 = 30, t2.c2 = 40, t3.c2=50 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
10SELECT * FROM t1 ORDER BY c1;
11SELECT * FROM t2 ORDER BY c1;
12SELECT * FROM t3 ORDER BY c1;
13DROP TABLE t1,t2,t3;
14CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
15CREATE TABLE t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
16CREATE TABLE t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
17INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
18INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
19INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
20UPDATE   t1, t2 ,t3 SET t1.c2 = 30, t2.c2 = 40, t3.c2=50 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
21SELECT * FROM t1 ORDER BY c1;
22SELECT * FROM t2 ORDER BY c1;
23SELECT * FROM t3 ORDER BY c1;
24DROP TABLE t1,t2,t3;
25CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
26CREATE TABLE t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
27CREATE TABLE t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
28INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
29INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
30INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
31UPDATE   t1, t2 ,t3 SET t1.c2 = 30, t2.c2 = 40, t3.c2=50 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
32SELECT * FROM t1 ORDER BY c1;
33SELECT * FROM t2 ORDER BY c1;
34SELECT * FROM t3 ORDER BY c1;
35DROP TABLE t1,t2,t3;
36CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
37CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
38CREATE TABLE t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
39INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
40INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
41INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
42UPDATE   t1, t2 ,t3 SET t1.c2 = 30, t2.c2 = 40, t3.c2=50 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
43SELECT * FROM t1 ORDER BY c1;
44SELECT * FROM t2 ORDER BY c1;
45SELECT * FROM t3 ORDER BY c1;
46DROP TABLE t1,t2,t3;
47CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
48CREATE TABLE t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
49CREATE TABLE t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
50INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
51INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
52INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
53UPDATE   t1, t2 ,t3 SET t1.c2 = 30, t2.c2 = 40, t3.c2=50 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
54SELECT * FROM t1 ORDER BY c1;
55SELECT * FROM t2 ORDER BY c1;
56SELECT * FROM t3 ORDER BY c1;
57DROP TABLE t1,t2,t3;
58CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
59CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
60CREATE TABLE t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
61INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
62INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
63INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
64UPDATE   t1, t2 ,t3 SET t1.c2 = 30, t2.c2 = 40, t3.c2=50 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
65SELECT * FROM t1 ORDER BY c1;
66SELECT * FROM t2 ORDER BY c1;
67SELECT * FROM t3 ORDER BY c1;
68DROP TABLE t1,t2,t3;
69CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
70CREATE TABLE t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
71CREATE TABLE t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
72INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
73INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
74INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
75UPDATE IGNORE t1, t2 ,t3 SET t1.c2 = 30, t2.c2 = 40, t3.c2=50 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
76SELECT * FROM t1 ORDER BY c1;
77SELECT * FROM t2 ORDER BY c1;
78SELECT * FROM t3 ORDER BY c1;
79DROP TABLE t1,t2,t3;
80CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
81CREATE TABLE t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
82CREATE TABLE t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
83INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
84INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
85INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
86UPDATE IGNORE t1, t2 ,t3 SET t1.c2 = 30, t2.c2 = 40, t3.c2=50 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
87SELECT * FROM t1 ORDER BY c1;
88SELECT * FROM t2 ORDER BY c1;
89SELECT * FROM t3 ORDER BY c1;
90DROP TABLE t1,t2,t3;
91CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
92CREATE TABLE t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
93CREATE TABLE t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
94INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
95INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
96INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
97UPDATE IGNORE t1, t2 ,t3 SET t1.c2 = 30, t2.c2 = 40, t3.c2=50 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
98SELECT * FROM t1 ORDER BY c1;
99SELECT * FROM t2 ORDER BY c1;
100SELECT * FROM t3 ORDER BY c1;
101DROP TABLE t1,t2,t3;
102CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
103CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
104CREATE TABLE t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
105INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
106INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
107INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
108UPDATE IGNORE t1, t2 ,t3 SET t1.c2 = 30, t2.c2 = 40, t3.c2=50 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
109SELECT * FROM t1 ORDER BY c1;
110SELECT * FROM t2 ORDER BY c1;
111SELECT * FROM t3 ORDER BY c1;
112DROP TABLE t1,t2,t3;
113CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
114CREATE TABLE t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
115CREATE TABLE t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
116INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
117INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
118INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
119UPDATE IGNORE t1, t2 ,t3 SET t1.c2 = 30, t2.c2 = 40, t3.c2=50 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
120SELECT * FROM t1 ORDER BY c1;
121SELECT * FROM t2 ORDER BY c1;
122SELECT * FROM t3 ORDER BY c1;
123DROP TABLE t1,t2,t3;
124CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
125CREATE TABLE t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
126CREATE TABLE t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
127INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
128INSERT INTO t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
129INSERT INTO t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
130UPDATE IGNORE t1, t2 ,t3 SET t1.c2 = 30, t2.c2 = 40, t3.c2=50 WHERE t1.c1=t2.c2 AND t2.c1=t3.c2;
131SELECT * FROM t1 ORDER BY c1;
132SELECT * FROM t2 ORDER BY c1;
133SELECT * FROM t3 ORDER BY c1;
134DROP TABLE t1,t2,t3;
135
136